aboutsummaryrefslogtreecommitdiffstats
path: root/packages/db/drizzle.ts
diff options
context:
space:
mode:
Diffstat (limited to 'packages/db/drizzle.ts')
-rw-r--r--packages/db/drizzle.ts20
1 files changed, 11 insertions, 9 deletions
diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts
index d436b3c6..42078b1b 100644
--- a/packages/db/drizzle.ts
+++ b/packages/db/drizzle.ts
@@ -1,24 +1,26 @@
import "dotenv/config";
-import { drizzle } from "drizzle-orm/better-sqlite3";
+
+import path from "path";
import Database from "better-sqlite3";
-import * as schema from "./schema";
+import { drizzle } from "drizzle-orm/better-sqlite3";
import { migrate } from "drizzle-orm/better-sqlite3/migrator";
-import path from "path";
+
import serverConfig from "@karakeep/shared/config";
import dbConfig from "./drizzle.config";
+import * as schema from "./schema";
const sqlite = new Database(dbConfig.dbCredentials.url);
if (serverConfig.database.walMode) {
- sqlite.pragma('journal_mode = WAL');
- sqlite.pragma('synchronous = NORMAL');
+ sqlite.pragma("journal_mode = WAL");
+ sqlite.pragma("synchronous = NORMAL");
} else {
- sqlite.pragma('journal_mode = DELETE');
+ sqlite.pragma("journal_mode = DELETE");
}
-sqlite.pragma('cache_size = -65536');
-sqlite.pragma('foreign_keys = ON');
-sqlite.pragma('temp_store = MEMORY');
+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;