Try our new research platform with insights from 80,000+ expert users

Cassandra vs CockroachDB comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Cassandra
Average Rating
8.0
Reviews Sentiment
6.1
Number of Reviews
24
Ranking in other categories
NoSQL Databases (6th), Vector Databases (14th)
CockroachDB
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
13
Ranking in other categories
Relational Databases Tools (10th)
 

Featured Reviews

Himanshu Amodwala - PeerSpot reviewer
Well-equipped to handle a massive influx of data and billions of requests
The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time updates is paramount. For instance, when a customer leaves comments or feedback on an image, they anticipate an immediate reflection of these changes on the portal. Similarly, sellers altering product attributes or updating images expect instant visibility of these modifications. Handling large data volumes with Cassandra has been an excellent experience. Despite challenges related to the influx, these were not attributed to Cassandra itself but rather to middle-layer issues. Generally, it demonstrated scalability with workloads, thanks to its horizontal scaling capabilities. We could easily add new nodes to the system as needed, ensuring the platform coped well with increasing loads. The tool's most beneficial feature for scalability is its entire architecture. The absence of a single point of failure or a leader within the ecosystem contributes to its robust scalability. This key aspect influenced our decision to opt for the Cassandra ecosystem. In terms of performance, it demonstrated the ability to handle approximately 1.6 billion requests per day. This was achieved on AWS using EC2 instances, and it was during a period about four to five years ago.
Antonio Tringali - PeerSpot reviewer
Open source with extensive documentation and a University for training
I am a freelancer. A client of mine wanted a solution that would allow them to scale yet not abandon the familiar PostgreSQL front-end (and rewrite a part of their source code). Scalability aside, CockroachDB is a fine way forward from PostgreSQL and is not changing the client source code part of the system. If you are lucky and you do not use newer features from recent versions of PostgreSQL or PostgreSQL extensions, it's fine. There are nice-to-have features for big organizations like regional tables. At the moment, my client simply does not use these. However, the serverless offer from CockroachDB is reacting well as data grows.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I am satisfied with the performance."
"I'd rate the solution ten out of ten."
"The most valuable feature of Cassandra is its fast retrieval. Additionally, the solution can handle large amounts of data. It is the quickest application we use."
"Its retrieval is similar to an RDBMS, so our team finds it easy to adapt."
"The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time updates is paramount."
"The time series data was one of the best features along with auto publishing."
"The solution's database capabilities are very good."
"I am getting much better performance than relational databases."
"The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"What I like best is its ability to solve data residency issues. The main advantage is auto geo partitioning, built into the product. This means we don't have to spin up separate servers in each region, which would be much more costly."
"The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."
"The product has valuable security features."
"The subset of SQL that my client is using is completely supported."
"CockroachDB is excellent for managing relationships in RDBMS with multiple benefits such as the ability to create views and dynamic queries that save data and reduce the use of complex algorithms in code."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."
 

Cons

"There could be more integration, and it could be more user-friendly."
"We found some issues with the batch inserts when the data volume is large."
"The initial setup of Cassandra can be difficult in the configuration. There might be a need to have assistance. The implementation process can six months for connecting to certain databases."
"Maybe they can improve their performance in data fetching from a high volume of data sets."
"There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using the Java SDK."
"The solution is limited to a linear performance."
"Doesn't support a solution that can give aggregation."
"Interface is not user friendly."
"I find the serverless offer a bit confusing."
"The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."
"For multi-region deployment, CockroachDB requires at least three plus replicas across data centers to achieve strong consistency across regions, which increases infrastructure costs including compute, storage, and networking."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"The product must improve its disaster recovery features."
"I think the engine itself could be improved. If you miss a partition key, it should be able to be modeled. This is where AI could be really helpful. For example, if a user is from Australia, the system should know to look for their data there first instead of searching in the US or another continent."
"The initial setup and pricing could be improved."
"I would like CockroachDB to have more compatibility with PostgreSQL, especially with the connection string and technical integrations."
 

Pricing and Cost Advice

"There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."
"I don't have the specific numbers on pricing, but it was fairly priced."
"I use the tool's open-source version."
"Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."
"We are using the open-source version of Cassandra, the solution is free."
"We pay for a license."
"The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
"The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."
"I've used CockroachDB at a small scale on the free accounts because we are only testing."
"The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."
"The solution's pricing is not cheap. However, the good thing is that customers are willing to pay for it if they want it."
report
Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
869,202 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
11%
Comms Service Provider
7%
Retailer
7%
Financial Services Firm
31%
Computer Software Company
12%
Educational Organization
8%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise1
Large Enterprise13
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise1
Large Enterprise5
 

Questions from the Community

What do you like most about Cassandra?
The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-ti...
What needs improvement with Cassandra?
While Cassandra can handle NoSQL, I think there should be more flexibility for whole schema design when data is stored in wide columns. Additionally, I believe that eventual consistency should be e...
What do you like most about CockroachDB?
The subset of SQL that my client is using is completely supported.
What needs improvement with CockroachDB?
The platform should provide a UI feature where users have the ability to manage it. The CockroachDB platform should have a chatbot where users can inquire about pricing or seek solutions for querie...
What is your primary use case for CockroachDB?
We have been using CockroachDB for the last two years. From 2023, we started working on a product similar to Google Capture. We decided to work with CockroachDB with Hasura. Hasura is a UI for the ...
 

Comparisons

 

Overview

 

Sample Customers

1. Apple 2. Netflix 3. Facebook 4. Instagram 5. Twitter 6. eBay 7. Spotify 8. Uber 9. Airbnb 10. Adobe 11. Cisco 12. IBM 13. Microsoft 14. Yahoo 15. Reddit 16. Pinterest 17. Salesforce 18. LinkedIn 19. Hulu 20. Airbnb 21. Walmart 22. Target 23. Sony 24. Intel 25. Cisco 26. HP 27. Oracle 28. SAP 29. GE 30. Siemens 31. Volkswagen 32. Toyota
Baidu, Kindred, Tierion, Heroic Labs, Gorgias
Find out what your peers are saying about Microsoft, LanceDB, Elastic and others in Vector Databases. Updated: September 2025.
869,202 professionals have used our research since 2012.