[sqlite] Limit size of write-ahead log file

On 5/19/15, Kees Nuyt wrote: > Did you consider > PRAGMA wal_autocheckpoint=N; and > PRAGMA database.wal_checkpoint(); ? > > http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint Thank you for your reply. Yes, but that will not always limit the size of the wal file. I believe

[sqlite] Limit size of write-ahead log file

On Mon, 18 May 2015 19:00:28 +0200, Zsb?n Ambrus wrote: >The PRAGMA max_page_count statement lets me set a limit on the size >the database is allowed to grow. This is useful to protect myself >against accidental errors in my program, where I fill the file system >with a huge database file,

[sqlite] Limit size of write-ahead log file

The PRAGMA max_page_count statement lets me set a limit on the size the database is allowed to grow. This is useful to protect myself against accidental errors in my program, where I fill the file system with a huge database file, which could disrupt other processes that are trying to write the