Comment

Comment by charleslmunger

The default is FULL

https://sqlite.org/compile.html#default_synchronous

>SQLITE_DEFAULT_SYNCHRONOUS=<0-3> This macro determines the default value of the PRAGMA synchronous setting. If not overridden at compile-time, the default setting is 2 (FULL).

>SQLITE_DEFAULT_WAL_SYNCHRONOUS=<0-3> This macro determines the default value of the PRAGMA synchronous setting for database files that open in WAL mode. If not overridden at compile-time, this value is the same as SQLITE_DEFAULT_SYNCHRONOUS.

Many wrappers for sqlite take this advice and change the default, but the default is FULL.

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton