git » sdk » commit 3624a86

Set up more pragma

author Stephen Paul Weber
2026-02-04 19:02:47 UTC
committer Stephen Paul Weber
2026-02-04 19:02:47 UTC
parent e2ac9bed62cd22d3b3f048b76738b8d71ea46210
Set up more pragma

Store temp tables in RAM always, and in constrained mode don't cache anything
borogove/persistence/SqliteDriver.hx +2 -0 
diff --git a/borogove/persistence/SqliteDriver.hx b/borogove/persistence/SqliteDriver.hx
index 19e7002..d9af267 100644
--- a/borogove/persistence/SqliteDriver.hx
+++ b/borogove/persistence/SqliteDriver.hx
@@ -21,6 +21,8 @@ class SqliteDriver {
 		writePool.run(() -> {
 			final db = sys.db.Sqlite.open(dbfile);
 			db.request("PRAGMA journal_mode=WAL");
+			db.request("PRAGMA temp_store=2");
+			if (Config.constrainedMemoryMode) db.request("PRAGMA cache_size=0");
 			dbs.push(db);
 			migrate((sql) -> this.execute(writePool, sql, [])).then(_ -> {
 				setReady(true);