Re:CockroachDB Interactive, D3-Powered Simulations
by cube2222 on Friday February 23, 2018 @03:51PM
(#16449503)
CRDB and Cassandra are to totally different databases.
CockroachDB is full SQL ACID database. With transactions, consistent indexes, joins. It's also strongly consistent overall.
Cassandra is really just a key-value store, with a hierarchy of sorting keys as part of the key, so that you can do range scans with good performance (and various access patterns). Indexes are asynchronously updated (as far as I know). No transactions nor joins. Its consistency is varying (configurable).
CockroachDB is full SQL ACID database. With transactions, consistent indexes, joins. It's also strongly consistent overall.
Cassandra is really just a key-value store, with a hierarchy of sorting keys as part of the key, so that you can do range scans with good performance (and various access patterns). Indexes are asynchronously updated (as far as I know). No transactions nor joins. Its consistency is varying (configurable).