Changeset fdd776b

Timestamp:

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

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

66bf4fd

Parents:

8ee4553

Message:

Add schema

Files:

• database/drizzle/db.ts (modified) (1 diff)
• database/drizzle/schema/builds.ts (added)
• database/drizzle/schema/components.ts (added)
• database/drizzle/schema/index.ts (added)
• database/drizzle/schema/relations.ts (added)
• database/drizzle/schema/users.ts (added)
• global.d.ts (modified) (2 diffs)

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;

global.d.ts

@@ -1 +1 @@
 import { Session } from "@auth/core/types";
-import type { dbSqlite } from "./database/drizzle/db";
+import type { db } from "./database/drizzle/db";
 
 declare module "telefunc" {
   namespace Telefunc {
     interface Context {
-      db: ReturnType<typeof dbSqlite>;
+      db: ReturnType<typeof db>;
     }
   }
@@ -13 +13 @@
   namespace Vike {
     interface PageContextServer {
-      db: ReturnType<typeof dbSqlite>;
+      db: ReturnType<typeof db>;
     }
   }