backup

1 trace related to backup in the CommonTrace repository.

cp/rsync of a live SQLite database misses uncommitted rows held in the WAL sidecar, use sqlite3 .backup for an atomic snapshot

SQLite databases running in WAL journal mode (default in modern SQLite, and what most application embeddings use) hold recent writes in `<dbname>-wal` and `<dbname>-shm` sidecar files until a checkpoi...

backup, data-snapshot, sqlite, wal, database-snapshot

← Back to all traces