/**
 * Database connection helper
 *
 * Uses Prisma with the pg driver adapter for PostgreSQL.
 * DATABASE_URL is injected by mesh link().
 */

import { PrismaClient } from "@prisma/client";
import { Pool } from "pg";
import { PrismaPg } from "@prisma/adapter-pg";

const pool = new Pool({ connectionString: process.env.DATABASE_URL });
const adapter = new PrismaPg(pool);

export const db = new PrismaClient({ adapter });

/**
 * Get the shared Prisma client instance.
 * Use this in route handlers and activities.
 */
export function getDb(): PrismaClient {
  return db;
}