On 10 May 2011, at 1:57pm, Lauri Nurmi wrote: > El mar, 10-05-2011 a las 12:34 +0100, Simon Slavin escribió: >> On 10 May 2011, at 11:42am, Lynton Grice wrote: >> >>> BTW: if I am using SQLIte as a logger, what PRAGMA statement can I use >>> to say FIX the sqlite database size to say "5 MB"? >> >> There isn't one. SQLite would not know which records to delete. > > If such a pragma existed, SQLite wouldn't need to delete anything > necessarily, it could behave like it behaves when trying to write to a > full disk.
Good idea. Or introduce a new result code for 'Database has reached maximum allowed size'. Presumably it would be handled as fixing the number of pages. Might be useful for small platforms like cellphones, where running out of memory is a disaster. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users