SQL Transactions

CamusDB supports explicit transaction statements:

BEGIN;
START TRANSACTION;
COMMIT;
ROLLBACK;

When a write or query request does not include a transaction id, CamusDB starts and commits a single-operation transaction automatically.

Isolation

Serializable is the default isolation level. You can be explicit at the start of a transaction:

BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
COMMIT;

Serializable read-only and read-write modes are supported:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ WRITE;

Read Committed is available as an explicit opt-out:

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;