feat: Allow enabling journaling mode on the db

2 files changed, 18 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;
 
diff --git a/packages/shared/config.ts b/packages/shared/config.ts
index 97467289..757ca2e4 100644
--- a/packages/shared/config.ts
+++ b/packages/shared/config.ts
@@ -132,6 +132,9 @@ const allEnv = z.object({
   CRAWLER_HTTP_PROXY: z.string().optional(),
   CRAWLER_HTTPS_PROXY: z.string().optional(),
   CRAWLER_NO_PROXY: z.string().optional(),
+
+  // Database configuration
+  DB_WAL_MODE: stringBool("false"),
 });
 
 const serverConfigSchema = allEnv
@@ -295,6 +298,9 @@ const serverConfigSchema = allEnv
           assetSizeBytes: val.PAID_QUOTA_ASSET_SIZE_BYTES,
         },
       },
+      database: {
+        walMode: val.DB_WAL_MODE,
+      },
     };
   })
   .refine(