[EMAIL PROTECTED] wrote:
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,
Can you repeat this test and reliably loose the data (i.e. is this a
repeatable failure)? If it is doing what you say it is, it should be
easy to reproduce.
Dennis Cote