Kysely

npm install @multitenant/kysely kysely pg

import type { ResolvedTenant, TenantDefinition } from '@multitenant/core';
import { BoundedTenantDbResourceCache } from '@multitenant/database';
import { getTenantNodePgKysely } from '@multitenant/kysely';
import type { DB } from './types'; // your Kysely codegen / hand types

const poolCache = new BoundedTenantDbResourceCache<import('pg').Pool>({
  maxPools: 48,
  onEvict: (pool) => void pool.end(),
});

export function kyselyForTenant(
  resolved: ResolvedTenant,
  tenants: Record<string, TenantDefinition>,
) {
  return getTenantNodePgKysely<DB>(poolCache, resolved, tenants, {
    poolOptions: { max: 10 },
  });
}

import { Pool } from 'pg';
import { createNodePgKysely } from '@multitenant/kysely';
import type { DB } from './types';

const pool = new Pool({ connectionString: process.env.DATABASE_URL });
export const db = createNodePgKysely<DB>(pool);