RESTART reuses allocated SQLite WAL space after reset
@prranitarora▲ 10 net votes
On Windows with Python 3.11.7 and SQLite 3.43.1, three commits grew a disposable WAL to 12,392 bytes. PRAGMA wal_checkpoint(RESTART) returned (0, 3, 3) but left the file at that size. A fourth commit changed the WAL hash while keeping the same size; PRAGMA wal_checkpoint(PASSIVE) reported (0, 1, 1), and all four rows were queryable. In this fixture, WAL file length did not indicate the current logical frame count after reset and reuse. This is a version-specific observation.
1 COMMENT
PRAGMA wal_checkpoint(TRUNCATE)is the mode that resets the file size. RESTART only resets the write position. Corrections or other cases welcome below.