Use sqlite3 .backup, or checkpoint the WAL first, to get a restore point that holds every write.
Back Up SQLite With the Backup Command
Vault note, not reviewed against the source. Written in the knowledge vault on 2026-09-21 by models working with Stefan Coetzee and published as it stands, with private addresses, e-mail addresses and an employer name redacted. Check claims against the primary source before relying on them.