Taking Control of the SQLite WAL (opens in new tab)

rqlite is a lightweight, open-source, fault-tolerant relational database built on SQLite and Raft. Version 10 is out now. rqlite has a particular relationship with the SQLite Write-Ahead Log (WAL). SQLite, left to itself, manages its own WAL: it checkpoints when the WAL grows, it checkpoints when the last connection closes, and it decides when frames move from…