Comment on Stop using MySQL in 2026, it is not true open source
dan@upvote.au 15 hours agoSQLite 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).
derpgon@programming.dev 11 hours ago
Wow, I never thought about storing build data in an SQLite file. That’s quite clever.
dan@upvote.au 11 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.
0x0@lemmy.zip 1 hour ago
They also have a (one-time fee) encryption extension.
hoppolito@mander.xyz 2 hours ago
Fascinating read, I should definitely also make way more use of sqlite for little side projects.
Thanks for the link!