News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by bambax on Saturday May 30, 2026 @06:06AM (#48334578)
> SQLite is an embedded database

Yes, but that's not its main selling point. An SQLite database is also a single file, which makes it incredibly easy to replicate, backup, transfer, restore, etc.

Re:SQLite is all you need for durable workflows by mxey on Saturday May 30, 2026 @06:13AM (#48334616)
SQLite in WAL mode which you want for server apps is multiple files.

Files which you cannot just copy while your application is running if you want a correct backup.

Re:SQLite is all you need for durable workflows by bambax on Saturday May 30, 2026 @06:57AM (#48334879)
Vacuum into or .backup work perfectly with a running, WAL enabled db.
Re:SQLite is all you need for durable workflows by mxey on Saturday May 30, 2026 @07:10AM (#48334968)
At which point there’s little difference from any other database’s backup commands.
Re:SQLite is all you need for durable workflows by bambax on Saturday May 30, 2026 @07:18AM (#48335023)
I don't think you can install "any other database" by pasting one file in a direcory somewhere? Even if you can produce such a backup with the same command.
Re:SQLite is all you need for durable workflows by roryirvine on Saturday May 30, 2026 @12:22PM (#48337909)
Pretty much every embedded database since about 1988 has worked like that.

You say that being an embedded database isn't the main selling point, being contained within a single file is. But that's a completely normal feature of an embedded db, to the point that the one implies the other.