breaking: Using DATA_DIR env variable instead of DATABASE_URL

2 files changed, 11 insertions, 2 deletions

diff --git a/packages/db/drizzle.config.ts b/packages/db/drizzle.config.ts
index ef31abc1..e2e00af9 100644
--- a/packages/db/drizzle.config.ts
+++ b/packages/db/drizzle.config.ts
@@ -1,10 +1,17 @@
 import "dotenv/config";
 import type { Config } from "drizzle-kit";
+
+if (!process.env.DATA_DIR) {
+  throw new Error("DATA_DIR environment variable is required");
+}
+
+const databaseURL = `${process.env.DATA_DIR}/db.db`;
+
 export default {
   schema: "./schema.ts",
   out: "./drizzle",
   driver: "better-sqlite",
   dbCredentials: {
-    url: process.env.DATABASE_URL || "",
+    url: databaseURL,
   },
 } satisfies Config;
diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts
index ae5bfa18..4763d9d7 100644
--- a/packages/db/drizzle.ts
+++ b/packages/db/drizzle.ts
@@ -5,7 +5,9 @@ import * as schema from "./schema";
 import { migrate } from "drizzle-orm/better-sqlite3/migrator";
 import path from "path";
 
-const sqlite = new Database(process.env.DATABASE_URL);
+import dbConfig from "./drizzle.config";
+
+const sqlite = new Database(dbConfig.dbCredentials.url);
 export const db = drizzle(sqlite, { schema });
 
 export function getInMemoryDB(runMigrations: boolean) {