import { migrate } from "drizzle-orm/postgres-js/migrator";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import { env } from "./lib/env";
import * as schema from "./schema";
import path from "path";
export const connection = postgres({
host: env.DB_HOST,
port: env.DB_PORT,
user: env.DB_USER,
password: env.DB_PASSWORD,
database: env.DB_NAME,
});
export const db = drizzle(connection, { schema });
export const initialMigration = () => {
const migrationsFolder = path.resolve(
process.cwd(),
"../../packages/db-web/drizzle",
);
return migrate(db, { migrationsFolder });
};
This is my initialization part, adding ssl: false or ssl: true does not work.
“drizzle-orm”: “^0.31.2”,
“drizzle-kit”: “^0.22.8”