[sqlite] Data integrity in extreme situations

2007-04-04 Thread Yves Goergen
Hi, I'm intending to use the SQLite database in a desktop e-mail application. Since most e-mails are quite valuable to me, I'd like to know if SQLite databases can get corrupted during normal use and exceptional situations like a sudden application/OS crash, power failure or access blocking

Re: [sqlite] Data integrity in extreme situations

2007-04-04 Thread P Kishor
On 4/4/07, Yves Goergen [EMAIL PROTECTED] wrote: Hi, I'm intending to use the SQLite database in a desktop e-mail application. Since most e-mails are quite valuable to me, I'd like to know if SQLite databases can get corrupted during normal use and exceptional situations like a sudden

Re: [sqlite] Data integrity in extreme situations

2007-04-04 Thread drh
Yves Goergen [EMAIL PROTECTED] wrote: Hi, I'm intending to use the SQLite database in a desktop e-mail application. Since most e-mails are quite valuable to me, I'd like to know if SQLite databases can get corrupted during normal use and exceptional situations like a sudden application/OS

Re: [sqlite] Data integrity in extreme situations

2007-04-04 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: It has already been reported that Apple Mail keeps all its metadata in an SQLite database. (There was quite a stir in the Mac community a few weeks ago when somebody discovered and blogged that you could substantially increase the speed of Apple Mail by running