anonymous added on 2018-08-15 11:42:09:
The functions necessary for manually issueing checkpoints, sqlite3_wal_checkpoint() and _checkpoint_v2() are not available in the lua bindings.
I've got an application proof of concept that is experiencing unbounded wal file growth, and would like to issue some manual checkpoints, but the API isn't available.
(I'm also going to try returning to default, and setting a busy timeout, which will reduce the importance of this to me personally if it works. I enabled wal mode because I was getting "db busy" too much)