git » sdk » commit bfa6f9c

PRAGMA synchronous=NORMAL

author Stephen Paul Weber
2026-04-12 20:13:20 UTC
committer Stephen Paul Weber
2026-04-12 20:13:20 UTC
parent 4cd603b0c51f89f21a20492d14e3b2bc87c4e480
PRAGMA synchronous=NORMAL

means we can lose a single transaction during a power failure. Not a bit
deal in our use case.
borogove/persistence/SqliteDriver.hx +1 -0 
diff --git a/borogove/persistence/SqliteDriver.hx b/borogove/persistence/SqliteDriver.hx
index 06baff8..d4ff3f7 100644
--- a/borogove/persistence/SqliteDriver.hx
+++ b/borogove/persistence/SqliteDriver.hx
@@ -21,6 +21,7 @@ class SqliteDriver {
 		writePool.run(() -> {
 			final db = sys.db.Sqlite.open(dbfile);
 			db.request("PRAGMA journal_mode=WAL");
+			db.request("PRAGMA synchronous=NORMAL");
 			db.request("PRAGMA temp_store=2");
 			if (Config.constrainedMemoryMode) db.request("PRAGMA cache_size=0");
 			dbs.push(db);