Not for free, but without the needing additional software.
synchronous_commit = on
That’s about the local transaction, not replication. SQLite WAL also gives you strict durability.
PRAGMA synchronous = full
alt Hacker News
That’s about the local transaction, not replication. SQLite WAL also gives you strict durability.