Postgres

Pass a pg.Pool straight into restaq({ database }). Restaq detects the dialect automatically and applies its own schema migrations.

pnpm add pg

npm install pg

yarn add pg

bun add pg

// relay.ts
import { restaq as createRestaq } from 'restaq';
import { Pool } from 'pg';

export const restaq = createRestaq({
  database: new Pool({ connectionString: process.env.DATABASE_URL! }),
  plugins: [
    // ...
  ],
});

Recommended for production, and for any deployment running more than one instance of your app. See Migrations for how to apply schema changes before scaling up.