Drizzle ORM | Postgres.js driver
# npm
npm i drizzle-orm postgres
npm i -D drizzle-kit
# yarn
yarn add drizzle-orm postgres
yarn add -D drizzle-kit
# pnpm
pnpm add drizzle-orm postgres
pnpm add -D drizzle-kit
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
const client = postgres(connectionString);
const db = drizzle(client);
See main docs for further usage.
In order to run the migrations, you need to use max: 1
in the postgres.js connection options. You can create a separate connection instance for migrations with that setting.
import postgres from 'postgres';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import { drizzle } from "drizzle-orm/postgres-js";
const migrationsClient = postgres(connectionString, {
max: 1,
});
const db = drizzle(migrationsClient);
await migrate(db, { migrationsFolder: '...' });
See main migrations docs for further info.