import "dotenv/config";
import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2";
// we are using createPool instead of createConnection as createConnection won't work over long run time.
export const sql = mysql.createPool({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_DATABASE,
})
const db = drizzle(sql);
export default db;
import "dotenv/config";
import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2";
// we are using createPool instead of createConnection as createConnection won't work over long run time.
export const sql = mysql.createPool({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: process.env.DB_DATABASE,
})
const db = drizzle(sql);
export default db;