import Database from "bun:sqlite";
import { drizzle as drizzleSqlite } from "drizzle-orm/bun-sqlite";
import { drizzle as drizzlePsql } from "drizzle-orm/node-postgres";
import { Pool } from "pg";

const SCHEMA = {};

export function dbSqlite() {
  const sqlite = new Database(process.env.DATABASE_URL);
  return drizzleSqlite(sqlite, {schema: SCHEMA});
}

export function dbPostgres() {
  const pool = new Pool({
    connectionString: process.env.DATABASE_URL,
  });
  return drizzlePsql({ client: pool, schema: SCHEMA });
}