Dowe

SERVER / DATABASE / TRANSACTIONS

Transactions

Transactions stage local literal inserts and commit them as one server action. Readers never observe staged records before commit.

Database overview

LOCAL TRANSACTION

Stage inserts, then commit one result

query result db:db.tx opens the transaction. Nested query declarations stage inserts against the same handle, keeping every binding explicit.

dowe
handler seedClinicData req
  db db name:"clinic"
  query result db:db.tx
    query room db:db.insert table:"rooms" value:{ name:"Room 1" status:"available" }
    query doctor db:db.insert table:"staff" value:{ name:"Ada" role:"doctor" }
    commit value:room
  return response json:{ ok:true data:result }

Local only

Remote Database handles reject query result db:db.tx until a remote transaction protocol exists.

Insert stage

The current runtime stages query bindings such as query room db:db.insert with literal values inside the transaction.

Rollback safety

A failed staged operation rolls back uncommitted writes. Use normal operations for request-bound values.