Predictable SQLite WAL Checkpointing Under Concurrent Reads
Why long-lived read transactions pin the write-ahead log on small virtual machines, and how bounded reader lifetimes keep -wal files compact.
Field notes on SQLite storage durability, Linux systemd units, and small-memory server tuning.
Why long-lived read transactions pin the write-ahead log on small virtual machines, and how bounded reader lifetimes keep -wal files compact.
Using OnUnitActiveSec, Persistent=true, and flock file locks so periodic housekeeping tasks never overlap after a reboot.
Practical notes on setting conservative vm.swappiness and capping systemd-journald disk retention on Debian Bookworm.