SQLite and ext3 journalling mode

Dan Kennedy <[email protected]> Tue, 07 Dec 2010 01:42:08 +0700
Newsgroups gmane.comp.file-systems.ext3.user
Message-ID <[email protected]>
Hi,

Are SQLite users that are worried about losing data that has been
committed (fsynced) better off setting data=journal than
data=ordered (or even data=writeback)?

The context is trying to reduce the number of writes to a flash
file-system without sacrificing data integrity in the event of a
power failure or OS crash.

Thanks,
Dan Kennedy.