Comment on Stop using MySQL in 2026, it is not true open source
derpgon@programming.dev 2 weeks agoWow, I never thought about storing build data in an SQLite file. That’s quite clever.
Comment on Stop using MySQL in 2026, it is not true open source
derpgon@programming.dev 2 weeks agoWow, I never thought about storing build data in an SQLite file. That’s quite clever.
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.
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!
0x0@lemmy.zip 2 weeks ago
They also have a (one-time fee) encryption extension.