><quote> >I apologize and I conclude my statement is not correct. > >I have experienced this problem once (out of disk space and sqlite >database corruption) but I made the mistake of confusing correlation >with causality. Except in that occasion I never had any problem with >sqlite and I do use it on production. On my web site (web2py.com) I >only run sqlite. > >Massimo > ></quote>
I wonder whether Massimo was referring to the possibility that a DB can get into an unrecoverable state when you reach the disk space limit - there's no room to create a rollback journal so you can't delete any records or vacuum. Obviously this is only a concern for systems with limited disk space. It would be great to see a disk quota management system in a future version of SQLite - or at least a way to associate sqlite3_file objects with the DB connections that created them. I'm trying to implement a quota system at the VFS level for an embedded platform, but it is proving tricky to manage temp files... Cheers, Dave. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
