• Dessalines@lemmy.ml
      link
      fedilink
      arrow-up
      32
      ·
      4 months ago

      It’s wild how it has the fastest read performance of any other sql backend, even postgres.

      • 4am@lemmy.zip
        link
        fedilink
        arrow-up
        16
        ·
        4 months ago

        I remember using SQLite like 12 years ago as a backend for Minecraft mods, and even more recently as a backend for HomeAssistant and switching away to something else for performance…and now switching back. Kudos to them for all the work that went into that! Worst to first!

      • Cargon@lemmy.ml
        link
        fedilink
        arrow-up
        3
        ·
        edit-2
        4 months ago

        I love SQLite but is this still true? I thought DuckDB was on its way to supplanting SQLite is this areai

        • enumerator4829@sh.itjust.works
          link
          fedilink
          English
          arrow-up
          1
          ·
          4 months ago

          Oh, have they started working on aviation grade test harnesses?

          SQLite will rule our world for a long time, far after we are gone.

    • jacksilver@lemmy.world
      link
      fedilink
      arrow-up
      3
      ·
      4 months ago

      Am I missing something? SQLite is great, but it isn’t really comparable to most other SQL databases, unless you’re talking about nosql alternatives?

    • dogs0n@sh.itjust.works
      link
      fedilink
      arrow-up
      3
      ·
      4 months ago

      It is beautiful. I haven’t even thought of using a database server for personal projects in years. SQLite all the way. It’s so simple and performant (for my use cases).