In the majority of my application, I'm fine running in WAL/NORMAL and lose some committed transactions if the application crashes. (Which actually just happened to me on iOS - I thought that can only happen on a full O/S crash - not just app. But oh well).
However, every now and again I need to communicate state with an external entity and to do that, I need to ensure local durability before that. Is there any way to force a single manual fsync? (Or is it really just a matter of calling the underlying O/S API?) I know I can checkpoint, but I: 1) Don't need a full checkpoint - syncing to the WAL is fine. 2) Can't tell for sure whether doing a checkpoint while in WAL/NORMAL mode will perform a sync before returning. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Forcing-a-manual-fsync-in-WAL-NORMAL-mode-tp78260.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
