@forinda/kickjs-db-pg

PostgreSQL adapter for @forinda/kickjs-db.

Two factories:

• pgDialect({ pool }) — query-layer dialect for createDbClient({ dialect }).
• pgAdapter({ pool }) — MigrationAdapter for kick db migrate + kickDbAdapter boot-time apply.

Both consume a pg-protocol-compatible pool (pg.Pool, @neondatabase/serverless's Pool, etc.) — adopters pick whichever runtime fits.

Install

pnpm add @forinda/kickjs-db @forinda/kickjs-db-pg pg

Usage

import { Pool } from 'pg'
import { createDbClient, kickDbAdapter } from '@forinda/kickjs-db'
import { pgAdapter, pgDialect } from '@forinda/kickjs-db-pg'
import { bootstrap } from '@forinda/kickjs'
import * as schema from './db/schema'

const pool = new Pool({ connectionString: process.env.DATABASE_URL })

export const db = createDbClient({
  schema,
  dialect: pgDialect({ pool }),
  events: true,
})

const migrationAdapter = pgAdapter({ pool })

export const app = await bootstrap({
  modules,
  adapters: [
    kickDbAdapter({
      migrationAdapter,
      migrationsDir: 'db/migrations',
      migrationsOnBoot: process.env.NODE_ENV === 'development' ? 'apply' : 'fail-if-pending',
    }),
  ],
})

The pool is shared between the migration adapter (used by the CLI for kick db migrate latest and similar) and the query client (used by repositories). One pool, no duplicate connections.

Docs

• Schema Types
• DB Extensions

License

MIT © Felix Orinda