When comparing Cassandra vs Couchbase, the Slant community recommends Couchbase for most people. In the question“What are the best databases for building social network like apps?” Couchbase is ranked 8th while Cassandra is ranked 10th. The most important reason people chose Couchbase is:
Couchbase and Couchbase Mobile are open source and released under the Apache License.
Ranked in these QuestionsQuestion Ranking
Pros
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 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 Not for newbies
If your dataset is in order of gigabytes then maybe consider a toy database, not a serious one like Cassandra.
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