LuaSQLite3

View Ticket
Login
Ticket UUID: 6779edfea83bac9fc0a234b149662fdd477a5ed1
Title: sqlite3_wal_checkpoint[_v2] not available in lua binding
Status: Open Type: Feature_Request
Severity: Important Priority:
Subsystem: Resolution:
Last Modified: 2018-08-15 11:42:09
Version Found In: 0.9.5
User Comments:
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)