Changeset fdd776b for database/drizzle/db.ts

Timestamp:

12/16/25 01:30:39 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

66bf4fd

Parents:

8ee4553

Message:

Add schema

File:

• database/drizzle/db.ts (modified) (1 diff)

database/drizzle/db.ts

@@ -1 @@
-import Database from "better-sqlite3";
-import { drizzle as drizzleSqlite } from "drizzle-orm/better-sqlite3";
+import { Pool } from "pg";
+import { drizzle } from "drizzle-orm/node-postgres";
+import * as schema from "./schema";
 
-export function dbSqlite() {
-  const sqlite = new Database(process.env.DATABASE_URL);
-  return drizzleSqlite(sqlite);
-}
+const pool = new Pool({
+    connectionString: process.env.DATABASE_URL,
+})
+
+export const db = drizzle(pool, { schema });
+
+export type Database = typeof db;