• Dessalines@lemmy.ml
    link
    fedilink
    arrow-up
    42
    ·
    2 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
      22
      ·
      2 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
      4
      ·
      edit-2
      2 months ago

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

      • freijon
        link
        fedilink
        arrow-up
        2
        ·
        2 months ago

        I thought Turso is the new cool kid on the block

      • enumerator4829@sh.itjust.works
        link
        fedilink
        English
        arrow-up
        1
        ·
        2 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.