Transactions

Running a transaction

Wrap related writes in db.transaction(). If any statement throws, every write in the block is rolled back.

await db.transaction(async (tx) => {  const invoice = await tx.invoices.insert({ customerId, total })  await tx.balances.update(customerId, { owed: sql`owed + ${total}` })})

Isolation levels

Transactions default to read committed. Pass isolation: "serializable" for workflows that must never interleave.

Retries

Serialization failures are retried up to three times automatically. Make the callback safe to run more than once.