[EMAIL PROTECTED] wrote: > > 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. > >
In 6 years of use with millions of installations, you are apparently the only person this has ever happened to. Your problem is unique. I do not believe it is the fault of SQLite. There is something else going on with your system. Nuno's suggestion seems the most plausible to me. I suggest you restart your application, then while the application is running, periodically use the SQLite command-line shell to check to see if the database is getting changed. If the command-line shell is able to see changes, then the changes really are being written to disk and the "rollback" was probably something that your OS did to you. If you are not seeing changes using the command-line shell, that suggests that your changes are going into a TEMP table and being automatically deleted upon each restart. Either way, it will help us to narrow down the problem. -- D. Richard Hipp <[EMAIL PROTECTED]>
