With Couchbase Server 7.0, you can now run N1QL (the Couchbase query language) with ACID semantics. All your familiar SQL statements – SELECT, INSERT, UPDATE, DELETE, JOINs, MERGE, etc. – can now run within BEGIN and COMMIT/ROLLBACK. Save points are available within transactions, as well. Transactions even work across multiple documents from multiple collections, among different scopes and different buckets.
You can program these transactions using SDKs as well as issue commands via UI, cbq, or REST. This talk will feature demos, gotchas, restrictions, and advantages of using ACID transactions. You’ll also learn how a MySQL transaction maps to a Couchbase transaction.