On 15 Nov 2016, at 6:11pm, Jens Alfke <j...@mooseyard.com> wrote: > I verified in the built-in sqlite3 tool on macOS 10.12.1 that the result of > `pragma fullfsync` is 0.
The default setting is 0. But you can change it. On my Mac running 10.12.x, SQLite version 3.14.0 2016-07-26 15:17:14 Enter ".help" for usage hints. sqlite> PRAGMA fullfsync; 0 sqlite> PRAGMA fullfsync=1; sqlite> PRAGMA fullfsync; 1 sqlite> PRAGMA checkpoint_fullfsync; 1 sqlite> My understanding is that F_FULLFSYNC still works the way you describe on a Mac and SQLite still uses it the way the documentation says. But I'm not in touch with either development group. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users