YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit of work. A transaction has four key properties: Atomicity, Consistency, Isolation, Durability (ACID).
The following table summarizes the support for transactions across the YSQL and YCQL APIs.
|Perform multi-row or multi-table transactions.
An application can connect to any node of the cluster.
|Repeatable read isolation level in PostgreSQL maps to snapshot isolation in YSQL.
AUTOCOMMIT = false setting
|The transaction must be expressed as one statement in YCQL.