Ion Silvestru <[EMAIL PROTECTED]> wrote: > >* In SQLite, my blobs won't be corrupted if the machine loses power > > the way they (probably) will be if I write my own code to access > > the file-system. > > But, in case of a corruption, you will have entire blob DB corrupted versus > at least one file (aka one row in DB) corrupted. >
Not. SQLite databases do not corrupt when you turn the power off. When power is restored and you attempt to access the database again, the transaction that you were in the middle of at the point of the power failure automatically rolls back, restoring the database to a sane state. This is one of the key reasons why you would want to use SQLite instead of fopen() for storing miscellaneous data. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
