codedlabdev
diff --git a/‎app/IPC/db/index.ts‎
Lines changed: 38 additions & 0 deletions b/‎app/IPC/db/index.ts‎
Lines changed: 38 additions & 0 deletions
diff --git a/‎drizzle.config.ts‎
Lines changed: 13 additions & 0 deletions b/‎drizzle.config.ts‎
Lines changed: 13 additions & 0 deletions
diff --git a/‎scripts/migrate.ts‎
Lines changed: 1 addition & 0 deletions b/‎scripts/migrate.ts‎
Lines changed: 1 addition & 0 deletions
@@ -0,0 +1,38 @@
+import { drizzle } from 'drizzle-orm/postgres-js';
+import postgres from 'postgres';
+import * as schema from './schema';
+
+// Lazy-loaded database connection
+let dbInstance: ReturnType<typeof drizzle> | null = null;
+
+export const getDb = () => {
+  if (!dbInstance) {
+    const connectionString = process.env.DATABASE_URL;
+
+    if (!connectionString) {
+      throw new Error('DATABASE_URL environment variable is not set');
+    }
+
+    try {
+      const client = postgres(connectionString, {
+        prepare: false,
+        ssl: 'require',
+        max: 1,
+        idle_timeout: 20,
+        connect_timeout: 10,
+      });
+      dbInstance = drizzle(client, { schema });
+    } catch (error) {
+      console.error('Failed to create database client:', error);
+      throw error;
+    }
+  }
+
+  return dbInstance;
+};
+
+// For backward compatibility
+export const db = getDb();
+
+// Export types
+export type Database = typeof db;
@@ -0,0 +1,13 @@
+import { defineConfig } from 'drizzle-kit';
+import * as dotenv from 'dotenv';
+
+dotenv.config();
+
+export default defineConfig({
+  schema: './app/IPC/db/schema.ts',
+  out: './app/IPC/db/migrations',
+  dialect: 'postgresql',
+  dbCredentials: {
+    url: process.env.DATABASE_URL!,
+  },
+});
@@ -21,6 +21,7 @@ async function runMigrations() {
   console.log('🔄 Connecting to database...');
 
   const sql = postgres(connectionString, {
+    prepare: false,
     ssl: 'require',
     max: 1,
   });