PostgreSQL

Installing driver

npm

npm install pg
npm install --save-dev @types/pg

pnpm

pnpm add pg
pnpm add --save-dev @types/pg

bun

bun add pg
bun add --dev @types/pg

yarn

yarn add pg
yarn add --dev @types/pg

Creating ZenStackClient

import { schema } from './zenstack/schema';
import { Pool } from 'pg';
import { ZenStackClient } from '@zenstackhq/orm';
import { PostgresDialect } from '@zenstackhq/orm/dialects/postgres';

const db = new ZenStackClient(schema, {
    dialect: new PostgresDialect({
        pool: new Pool({
            connectionString: process.env.DATABASE_URL,
        }),
    }),
});