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 application/OS crash, power failure
or access blocking through a virus scanner. Can it happen that under
these circumstances all/arbitrary data from the database file can be
lost or does that only affect the data currently being written, if any.
How does it relate to transactions? I'm considering doing a full
database backup each time the application quits but keeping the entire
file twice may take much disk space. Maybe using two files, one for
current e-mails and one as growing archive (that doesn't change often),
would be a possibility.
if it is any consolation/encouragement, Apple's Mail.app version 2.x
onward use SQLite as the data store.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
