On Mon, 18 May 2015 19:00:28 +0200, Zsb?n Ambrus <ambrus at math.bme.hu> 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, which could disrupt other processes that >are trying to write the same filesystem. > >However, I don't see a setting that would let me limit the size of the >write-ahead log file, or of other temporary files listed in >"http://sqlite.org/tempfiles.html";. Is there a setting for that? >Also, is there perhaps a way to limit the size of temporary files >opened for a database handle? > >I expect that SQLite itself should be able to handle such a limit, >because SQLite promises that it can handle failed filesystem >operations gracefully in all cases. > >The PRAGMA journal_size_limit does not do this, at least according to >the documentation. The WAL file may still grow limitlessly regardless >that pragma as long as that file is still needed by active database >connections. Did you consider PRAGMA wal_autocheckpoint=N; and PRAGMA database.wal_checkpoint(); ? http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint -- Regards, Kees Nuyt
