import { PrismaClient } from "@prisma/client";

/**
 * Single PrismaClient instance.
 *
 * Next.js dev mode hot-reloads modules, which would otherwise open a new
 * connection pool on every reload and exhaust PostgreSQL's connection limit.
 * Caching the instance on `globalThis` keeps a single pool alive.
 */

const globalForPrisma = globalThis as unknown as {
  prisma: PrismaClient | undefined;
};

export const prisma =
  globalForPrisma.prisma ??
  new PrismaClient({
    log:
      process.env.NODE_ENV === "development"
        ? ["warn", "error"]
        : ["error"],
  });

if (process.env.NODE_ENV !== "production") {
  globalForPrisma.prisma = prisma;
}

export type { Prisma } from "@prisma/client";
