Predictable SQLite WAL Checkpointing Under Concurrent Reads
Write-ahead logging lets readers proceed while a writer appends frames, but an idle cursor left open in a background worker prevents PASSIVE checkpoints from recycling early frames.
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA busy_timeout = 5000;
Keeping read scopes strictly bounded inside short context managers eliminated unexpected WAL growth across multi-day soak runs.