Get started
Overview PostgreSQL Manage schema
Overview Column types Indexes & Constraints Migrations Views Schemas Access your data
Query Select Insert Update Delete Filters Joins Magic sql`` operator Performance
Queries Serverless Advanced
Set Operations Transactions Batch Dynamic query building Read Replicas Custom types Goodies Extensions
ESLint Plugin drizzle-zod drizzle-typebox drizzle-valibot PostgresJS
According to the official website, PostgresJS is the fastest fully featured PostgreSQL client for Node.js and Deno.
Drizzle ORM natively supports postgresjs driver with drizzle-orm/postgres-js package.
npm
yarn
pnpm
bun
npm i drizzle-orm postgres
npm i -D drizzle-kityarn add drizzle-orm postgres
yarn add -D drizzle-kitpnpm add drizzle-orm postgres
pnpm add -D drizzle-kitbun add drizzle-orm postgres
bun add -D drizzle-kitimport { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';
// for migrations
const migrationClient = postgres("postgres://postgres:[email protected]:5432/db", { max: 1 });
migrate(drizzle(migrationClient), ...)
// for query purposes
const queryClient = postgres("postgres://postgres:[email protected]:5432/db");
const db = drizzle(queryClient);
await db.select().from(...)... ⚙️
For the built in migrate function with DDL migrations we strongly encourage you to use max: 1 connection configuration.
For querying purposes feel free to use pool size of your choice based on your business demands.