On Jul 18, 2006, at 16:40 UTC, Nuno Lucas wrote: > Any chance of being the OS file system that "rollbacked" the files > after the crash?
It seems unlikely. It wasn't a system crash; actually, I just killed my application process. Anything the app had written out to disk already, should have still been there after the restart. It's very disturbing -- I'm hearing that SQLite should automatically flush to disk, and that what I observed shouldn't be possible. I'm relying on it to keep my data safe (backups notwithstanding). Yet in practice, it really did roll back two days' worth of data. -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/