rust-soham/golem-claw/golem-add-postgres-ts

import { DbConnection, type DbValue } from "golem:rdbms/postgres@1.5.0";

const conn = DbConnection.open("postgres://user:password@localhost:5432/app");

const result = conn.query("SELECT $1::text", [{ tag: "text", val: "hello" } satisfies DbValue]);
const value = result.rows[0]?.values[0];
if (!value || (value.tag !== "text" && value.tag !== "varchar" && value.tag !== "bpchar")) {
  throw new Error(`Unexpected PostgreSQL value: ${JSON.stringify(value)}`);
}
const message = value.val;

conn.execute(
  "INSERT INTO notes (id, body) VALUES ($1, $2)",
  [
    { tag: "int4", val: 1 },
    { tag: "text", val: "hello" },
  ],
);

const tx = conn.beginTransaction();
tx.execute("UPDATE notes SET body = $1 WHERE id = $2", [
  { tag: "text", val: "updated" },
  { tag: "int4", val: 1 },
]);
tx.commit();