At 6:23 AM +0200 6/14/06, Olaf Beckman Lapré wrote:
Hi,
I'm using SQLite as the storage engine in my
e-mail client but I'm worried that a user
crashes or kills the client during normal
operation resulting in a corrupted SQLite
database. If the file is corrupted I'm afraid
the user's entire e-mail database may be lost.
Are there any standard procedures to recover from a corrupted database?
Thanks,
O.
A user simply killing off the email client
process, or shutting off the power to your
machine, should not corrupt the database, since
the database is ACID compliant; it will correct
itself using its journal file when your client
next is run. That said, if they manually edit
the database file with some other program, or
remove its journal file, then that could cause
problems, as that goes outside the SQLite code
and its ability to enforce ACID. -- Darren Duncan
