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.
-- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
