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.
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.