4 ms·
However, SQLite, by default, always truncates the WAL files on last connection close > When the last connection to a database closes, that connection does one
by avinassh 1y ago
However, SQLite, by default, always truncates the WAL files on last connection close
> When the last connection to a database closes, that connection does one last checkpoint and then deletes the WAL and its associated shared-memory file, to clean up the disk.
https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
- lxgr 1y agoYes, but you can't rely on an orderly database close when it comes to correctness. Non-clean shutdowns are much more common than actual low-level data corruption in many SQLite applications.