SQLite Forum

Switching pragma synchronous to upgrade durability
Login
Yes.  Doing a single transaction with PRAGMA synchronous=FULL causes an
fsync() to occur on the WAL file, which makes all prior transactions durable
across power failures or OS crashes.