Re: [sqlite] PRAGMA synchronous = OFF on transaction-safe file system TFAT WinCE

Daniel wrote: > Is it safe do set PRAGMA synchronous = OFF when a > transaction-safe file system is used? > > We are working on WinCE with TFAT (see below) - but this might > be a general question. > TFAT: > ... By making file operations > transaction-safe, TFAT stabilizes the file system and

Re: [sqlite] rollback/replay journals and durability of the most recent transaction

Igor Tandetnik writes: > Karl Tomlinson wrote: > >> I really meant, as a first possibility, that writing the pages >> to the database itself would be performed during the commit >> process after syncing the replay journal (but the database need >> not be syn

Re: [sqlite] rollback/replay journals and durability of the most recent transaction

Thank you for your comments. >> Karl Tomlinson wrote: >> >>> One thing I'm trying to understand is whether there was a reason for >>> SQLite choosing to use a rollback journal (of the steps to undo a >>> transaction) rather than a replay journal (of the

[sqlite] rollback/replay journals and durability of the most recent transaction

I've done a little looking into journals, fsyncs, and filesystems recently. One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay journal (of the steps to perform a transaction). In