3 ms·
> 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 replic
by bambax 5mo ago
> 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.
- mxey 5mo agoSQLite 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.
- bambax 4mo agoVacuum into or .backup work perfectly with a running, WAL enabled db.
- mxey 4mo agoAt which point there’s little difference from any other database’s backup commands.
- bambax 4mo agoI 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.
- roryirvine 4mo agoPretty 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.