Willamette Bench Notes

Field notes on SQLite storage durability, Linux systemd units, and small-memory server tuning.

Predictable SQLite WAL Checkpointing Under Concurrent Reads

· Storage

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.

Recommended baseline connection pragmas:
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.