Re:S3QL: an S3 FS with encryption, de-dup, immutable trees a...
by edwintorok on Tuesday September 01, 2015 @12:05PM
(#10153361)
There is also `PRAGMA synchronous = NORMAL` that helps a lot. Your database will still be consistent and cannot become corrupted, although you do have to give up transaction durabibility after a power loss:
https://www.sqlite.org/pragma.html#pragma_synchronous