[catgirlinspace]

You could do a checkpoint first though I believe? And if the database is only being updated on your local client I don’t think WAL mode would have much benefit since it’s probably not getting many concurrent writes.

[timewizard]

The WAL has a minimum size. In this context I assumed you would not be using SQLite to serve requests serially.