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

Citus Data vs CockroachDB comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Citus Data
Ranking in Relational Databases Tools
21st
Average Rating
8.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
CockroachDB
Ranking in Relational Databases Tools
11th
Average Rating
8.0
Reviews Sentiment
7.7
Number of Reviews
12
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of Citus Data is 1.7%, up from 1.2% compared to the previous year. The mindshare of CockroachDB is 3.0%, up from 2.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Arucy Lionel - PeerSpot reviewer
Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management
There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward. Currently, setting up a multi-node environment is challenging. It's a bit tricky. Installation on each PostgreSQL node can lead to communication issues between nodes. An automatic rebalancing feature would be a significant improvement. Currently, I have to manually command the rebalance. It would be more convenient if it was rebalanced automatically. The dashboard and monitoring capabilities are good, but it would be helpful to have an integrated availability dashboard.
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

"It's very straightforward to implement the solution. It took us two days to set up everything."
"Its distributed processing capabilities are a standout feature. It requires minimal changes to get up and running if you already have a system on PostgreSQL. Citus can run in its natural state."
"You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"The most valuable feature is that CockroachDB is a distributed database, which can deploy nodes running in different regions."
"The product has valuable security features."
"The subset of SQL that my client is using is completely supported."
"The initial setup and deployment are simple."
"The availability and the easy to use feature is the most valuable. The documentation is also good."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"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 are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward."
"More features in monitoring and the reporting could make it better."
"Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues."
"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."
"I find the serverless offer a bit confusing."
"CockroachDB needs to improve store processes."
"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."
"We are looking for more features to support distributed high availability and geo-partitioning."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"I would like CockroachDB to have more compatibility with PostgreSQL, especially with the connection string and technical integrations."
"The product must improve its disaster recovery features."
 

Pricing and Cost Advice

"Citus Data is an open-source product."
"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."
"The solution's pricing is not cheap. However, the good thing is that customers are willing to pay for it if they want it."
"The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
"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."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
12%
Manufacturing Company
10%
Comms Service Provider
8%
Financial Services Firm
39%
Computer Software Company
14%
Retailer
5%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Citus Data?
You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well.
What needs improvement with Citus Data?
Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues.
What do you like most about CockroachDB?
The subset of SQL that my client is using is completely supported.
What needs improvement with CockroachDB?
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 sy...
What is your primary use case for CockroachDB?
Cockroach nodes were installed in the following: 1. Single host, triple nodes (containers): for evaluation on a low-end PC. 2. Single host, triple nodes (process): to test applications against a ~5...
 

Comparisons

 

Overview

 

Sample Customers

Cloud Flare, Agari, Mix Rank, Heap
Baidu, Kindred, Tierion, Heroic Labs, Gorgias
Find out what your peers are saying about Citus Data vs. CockroachDB and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.