When comparing Apache Cassandra vs Couchbase, the Slant community recommends Apache Cassandra for most people. In the question“What are the best databases to use for Node.js applications?” Apache Cassandra is ranked 13th while Couchbase is ranked 14th. The most important reason people chose Apache Cassandra is:
Once setup database is set up, it becomes highly available without any downtime.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Highly available cluster
Once setup database is set up, it becomes highly available without any downtime.
Pro Highly scalable
Cassandra is very scalable and achieves the highest throughput for the maximum number of nodes compared to other alternatives. Unfortunately this also brings rather high write and read latencies.
Pro Familiar to developers used to SQL
The query language that Cassandra uses (CQL) is similar to SQL even though it's a NoSQL database.
Pro Rapid writing and lightning-fast reading
After measuring the read/write performance values on one server, you can simply calculate how many more servers you should add to the cluster to reach the required performance levels, and scale easily.
Pro Open source
Couchbase and Couchbase Mobile are open source and released under the Apache License.
Pro Easy to implement N1QL queries
Pro Ability to run ad-hoc SQL like queries on realtime big data
Couchbase N1QL allows native SQL processing over JSON data with high performance indexing for low latency queries at scale.
Pro Easy sync protocol to mobile devices
The minimal code needed to pull data down to a device
Pro Available on Windows, Linux & macOS
Pro Ability to make predefined fast queries
With Couchbase you can make "Views" of data, which are practically predefined queries which are fetched with an O(1) algorithm.
Cons
Con No JOINS
Cassandra has no support for JOINS.
Con Vendor lock-in
Con No model mapper for Android
Couchbase does not have a model mapper for Android built-in and out of the box, instead you will have to write your own from scratch.
Con Not Compatible with couchdb
Since version 2 the sync-protocol is no longer compatible with couchdb. This makes couchbase nearly worthless