pg (node-postgres)

pnpm add pg

import { createClient } from "viborm/drivers/pg";

const client = createClient({
  databaseUrl: process.env.DATABASE_URL,
  schema,
});

import { createClient } from "viborm/drivers/pg";

const client = createClient({
  options: {
    host: "localhost",
    port: 5432,
    user: "postgres",
    password: "password",
    database: "mydb",
    max: 20,
  },
  schema,
});

import { Pool } from "pg";
import { createClient } from "viborm/drivers/pg";

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

const client = createClient({
  pool,
  schema,
});

import { createClient } from "viborm/drivers/pg";

const client = createClient({
  databaseUrl: process.env.DATABASE_URL,
  pgvector: true,
  schema,
});

await client.$transaction(async (tx) => {
  await tx.user.create({ data: { name: "Alice" } });
  await tx.post.create({ data: { title: "Hello", authorId: "..." } });
}, { isolationLevel: "serializable" });