Re: [sqlite] How to limit the size of the database files?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tobias Müller wrote: >> For an even smaller footprint change, you can write your own >> xFileControl routine and then use sqlite3_file_control to >> query/set values. > > By "write your own xFileControl routine" did you mean that we should > change

Re: [sqlite] How to limit the size of the database files?

Roger Binns wrote: > You can write your own VFS that gives an I/O error on writes that make > the file larger than you want. This won't be much code since you can > just point to existing VFS routines (eg unix/winTruncate, unix/winLock > etc) for most of the code. After a first look, this

Re: [sqlite] How to limit the size of the database files?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tobias Müller wrote: > Is there a way to limit the size of the journal and temporary files created > and filled by SQLite? Or is it possibly to find out the current file size of > the journal and tempoarary files using some API. You can write your

[sqlite] How to limit the size of the database files?

Hello list, we use SQLite on an embedded device and have the requirement to limit the maximum size the database file(s) use on the storage device. Using PRAGMA MAX_PAGE_COUNT=x works fine to limit the size of the actual database file, but does not consider the size of the journal and temporary