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

• dan@upvote.au ⁨6⁩ ⁨hours⁩ 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⁩ ⁨hours⁩ ago

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

    source

    • dan@upvote.au ⁨2⁩ ⁨hours⁩ 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