• Dessalines@lemmy.ml
    link
    fedilink
    arrow-up
    40
    ·
    3 days 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
      21
      ·
      3 days 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 days ago

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