diff options
Diffstat (limited to 'packages')
| -rw-r--r-- | packages/db/drizzle.ts | 12 | ||||
| -rw-r--r-- | packages/shared/config.ts | 6 |
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( |