import mysql from "mysql2/promise";

const globalForDb = globalThis as unknown as { db: mysql.Pool | undefined };

const db =
  globalForDb.db ??
  mysql.createPool(process.env.DATABASE_URL!);

if (process.env.NODE_ENV !== "production") globalForDb.db = db;

export default db;