So ScyllaDB allows you to choose how much Consistency in CAP you desire, in order to gain performance. Pretty interesting. In contrast to CockroachDB, Postgres

So ScyllaDB allows you to choose how much Consistency in CAP you desire, in order to gain performance. Pretty interesting. In contrast to CockroachDB, Postgres, etc, where Consistency in CAP is always enforced and there's no way to turn it off. You turn it on/off by simply specifying IF NOT EXISTS which is insanely simple: https://www.scylladb.com/2020/07/15/getting-the-most-out-of-lightweight-transactions-in-scylla/ https://www.scylladb.com/2020/07/15/getting-the-most-out-of-... (called "lightweight transactions" or LWT) I wish CockroachDB had a way to trade consistency for speed when desired. Another sidenote, in my limited investigation so far- when using LWT in ScyllaDB: performance of CockroachDB INSERT and ScyllaDB INSERT both line up fairly evenly. Still investigating, but this makes sense- Only when you avoid IF NOT EXISTS, ScyllaDB pulls away massively in performance.