feat: Allow enabling journaling mode on the db

1 files changed, 12 insertions, 0 deletions

diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts
index 843b21cc..d436b3c6 100644
--- a/packages/db/drizzle.ts
+++ b/packages/db/drizzle.ts
@@ -4,10 +4,22 @@ import Database from "better-sqlite3";
 import * as schema from "./schema";
 import { migrate } from "drizzle-orm/better-sqlite3/migrator";
 import path from "path";
+import serverConfig from "@karakeep/shared/config";
 
 import dbConfig from "./drizzle.config";
 
 const sqlite = new Database(dbConfig.dbCredentials.url);
+
+if (serverConfig.database.walMode) {
+  sqlite.pragma('journal_mode = WAL');
+  sqlite.pragma('synchronous = NORMAL');
+} else {
+  sqlite.pragma('journal_mode = DELETE');
+}
+sqlite.pragma('cache_size = -65536');
+sqlite.pragma('foreign_keys = ON');
+sqlite.pragma('temp_store = MEMORY');
+
 export const db = drizzle(sqlite, { schema });
 export type DB = typeof db;