postgres.js

pnpm add postgres

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

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

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

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

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

const sql = postgres(process.env.DATABASE_URL);

const client = createClient({
  client: sql,
  schema,
});

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

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: "..." } });
});