News for hackers. Stuff that matters.
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.