Connect Drizzle to Neki

• A Neki database with a ready branch.
• An application role for that branch. Use pg_read_all_data for read traffic and add pg_write_all_data when the application writes rows. These inherited data roles do not grant CREATE or ALTER, so application credentials cannot change the schema.
• A separate migration role, if you run schema changes against the branch. DDL requires the postgres inherited role. Neki restricts execution of the cross-router DDL barrier function __neki.wait_for_ddl to its neki_viewer role, so add neki_viewer, which requires pg_read_all_data, to the same role. Keep the migration credentials out of the application’s runtime configuration.
• The Primary connection details from the database’s Connect page.

​

Install the dependencies

npm install drizzle-orm pg dotenv

​

Add the connection string

DATABASE_URL='postgresql://<USERNAME>:<PASSWORD>@<HOST>:5432/postgres?sslmode=verify-full'

​

Connect and run a query

import 'dotenv/config'

import { sql } from 'drizzle-orm'
import { drizzle } from 'drizzle-orm/node-postgres'
import pg from 'pg'

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

const db = drizzle(pool)

const result = await db.execute(sql`
  SELECT current_database() AS database, current_user AS role
`)

console.log(result.rows[0])
await pool.end()

node app.js

psql "$MIGRATION_DATABASE_URL" -f <MIGRATION_FILE>

NOTICE: DDL is committed and the change is visible on this router; other routers may not see it yet. To wait until it is visible on every router, use __neki.wait_for_ddl(42, 7)

SELECT __neki.wait_for_ddl(42, 7);

​

Need help?