PostgresJS

According to their official website (opens in a new tab), PostgresJS is the fastest full featured PostgreSQL client for Node.js and Deno

Drizzle ORM natively supports postgresjs driver with drizzle-orm/postgres-js package

npm i drizzle-orm postgres
npm i -D drizzle-kit

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.

index.ts

import { drizzle, PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';
 
// for migrations
const migrationClient = postgres("postgres://postgres:adminadmin@0.0.0.0:5432/db", { max: 1 });
migrate(drizzle(migrationClient), ...)
 
// for query purposes
const queryClient = postgres("postgres://postgres:adminadmin@0.0.0.0:5432/db");
const db: PostgresJsDatabase = drizzle(queryClient);
await db.select().from(...)...

Installation & database connection node-postgres