checkpointFullfsync

Queries or sets the checkpoint_fullfsync flag.

This pragma controls whether the fsync operation is performed with F_FULLFSYNC on systems that support it (like macOS). When enabled (true), checkpoints are more durable against power loss, but they may run slower.

The default setting is determined by the SQLITE_DEFAULT_CHECKPOINT_FULLFSYNC compile-time option. This pragma only has an effect if the fullfsync pragma is also enabled.

See also