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. -- Zsb?n Ambrus
