The journal file enables Sqlite to roll back a part-posted transaction
on restart and ensure transactional integrity.
Dave Dyer wrote:
The main purpose of the journal is so that if the program
or OS crashes or there is a power failure, once the machine
reboots and some other process tries to read the database,
the other process can see the journal and roll it back.
Private anonymous mapped objects defeat that purpose, it
would seem.
I thought the purpose was to prevent corruption in the main
database. If you assume the power fails, or some other
program disaster occurs, it doesn't really matter if the
last transaction was made persistant or not. It's just
like the power failed a few seconds sooner.
So as long as sqlite is still safe if a journal file is deleted
after a restart, I don't think there's a problem.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------