From 64a0d9185bf292ca0f4b407bfe302f6db7232493 Mon Sep 17 00:00:00 2001 From: Mohamed Bassem Date: Sat, 19 Jul 2025 10:37:43 +0000 Subject: feat: Allow enabling journaling mode on the db --- packages/db/drizzle.ts | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'packages/db') 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; -- cgit v1.2.3-70-g09d2