Comment on Stop using MySQL in 2026, it is not true open source

• dan@upvote.au ⁨2⁩ ⁨weeks⁩ ago

  SQLite is underrated. If your system has a large number of readers and a small number of writers, it performs very well. It’s not as good for high-concurrency write-heavy use cases, but that’s not common (most apps read far more than they write).

  source

  • derpgon@programming.dev ⁨2⁩ ⁨weeks⁩ ago

    Wow, I never thought about storing build data in an SQLite file. That’s quite clever.

    source

    • dan@upvote.au ⁨2⁩ ⁨weeks⁩ ago

      One of SQLite’s recommended use cases is as an alternate to proprietary binary formats: sqlite.org/appfileformat.html. Programs often store data in binary files for performance, but you get a lot of the same functionality included with SQLite (fast random access, concurrent usage, atomicity, updates that don’t need to rewrite the whole file, etc) without having to implement a file format yourself.

      source

      • hoppolito@mander.xyz ⁨2⁩ ⁨weeks⁩ ago

        Fascinating read, I should definitely also make way more use of sqlite for little side projects.
        Thanks for the link!

        source
      • 0x0@lemmy.zip ⁨2⁩ ⁨weeks⁩ ago

        They also have a (one-time fee) encryption extension.

        source