• Dessalines@lemmy.ml
      link
      fedilink
      arrow-up
      37
      ·
      8 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
        18
        ·
        8 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
        ·
        8 months ago

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

    • dogs0n@sh.itjust.works
      link
      fedilink
      arrow-up
      4
      ·
      8 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).

    • jacksilver@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      8 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?