Kysely

npm install @monocle.sh/instrumentation-kysely kysely@^0.29.6 pg

import pg from "pg";
import { Kysely, PostgresDialect } from "kysely";
import { observeDialect } from "@monocle.sh/instrumentation-kysely";

interface Database {
  users: { id: number; name: string };
}

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

export const db = new Kysely<Database>({
  dialect: observeDialect({
    dialect: new PostgresDialect({ pool }),
    dbSystem: "postgresql",
  }),
});

npm install postgres kysely-postgres-js

import postgres from "postgres";
import { PostgresJSDialect } from "kysely-postgres-js";
import { observeDialect } from "@monocle.sh/instrumentation-kysely";

const dialect = observeDialect({
  dialect: new PostgresJSDialect({
    postgres: postgres(process.env.DATABASE_URL!),
  }),
  dbSystem: "postgresql",
});

import pg from "pg";
import { registerPgPoolMetrics } from "@monocle.sh/instrumentation-kysely";

const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL, max: 10 });
const stopPoolMetrics = registerPgPoolMetrics({ pool, max: 10, poolName: "main" });

export async function shutdownDatabase() {
  stopPoolMetrics();
  await pool.end();
}