fix: enable WAL before SQLite sync tuning

TheLastCicada · TheLastCicada · commit f48d46375461 · 2026-05-06T10:41:16.000-07:00
Set WAL mode on the same SQLite connection before lowering synchronous so
startup never observes NORMAL durability outside WAL mode.
diff --git a/src/database/sqlite-pragmas.js b/src/database/sqlite-pragmas.js
@@ -1,6 +1,7 @@
 import { logger } from '../config/logger.js';
 
 const SQLITE_PRAGMAS = [
+  'PRAGMA journal_mode = WAL',
   'PRAGMA synchronous = NORMAL',
   'PRAGMA cache_size = -65536',
   'PRAGMA temp_store = MEMORY',
