CockroachDB Pros and Cons

Horizontal scalability of the cockroach DB allows us to add more nodes to the cluster easily based on the data growth.

Built-in high availability features that make it resilient to node failures using its automatic data replication and failover mechanism Review collected by and hosted on G2.com.

It is resource-intensive and consumes high CPU, memory, and storage. Sometimes there are latency issues too.

Setting up and configuring for the first time is a bit complex.

Also, it has a limited ecosystem Review collected by and hosted on G2.com.

I have an option to evaluate this product using an open source option and take some university courses to educate myself on how to use the database product. From there, I can figure out which projects I plan to use it for (specifically anything business-related or personal / hobby projects). Review collected by and hosted on G2.com.

I'm not sure as I am continuing to explore more of the product and I hope that there isn't too many limitations when it comes to adding specific data that I would need to create the database. Review collected by and hosted on G2.com.

CockroachDB is the only database we could find that had a truly global architecture. CockroachDB speaks PostgreSQL, so it was very easy to integrate with our existing systems. Review collected by and hosted on G2.com.

The initial pricing was very steep, however, this has since been addressed with their cloud-based free tier. Great for bootstrapping development. There is a small number of missing features from PostgreSQL, however, we have not needed any of these. Review collected by and hosted on G2.com.

Basically cockroachdb is easy to use and it is open source distributed database. It accepts complex architectures which makes it globally accepted. It's best feature is geo partitioning into it's clusters. Support team is so awesome that they solve problems in matter of minutes. Review collected by and hosted on G2.com.

Though CockroachDB is an open source , there ain't any forum except stack overflow. It's setup is slightly complex from others. Other than that everything works fine. Review collected by and hosted on G2.com.

How easy is to deploy a full distributed ACID database. Review collected by and hosted on G2.com.

Had to figure it later that some queries in your application aren't aligned with the system expectation causing production outages. Review collected by and hosted on G2.com.

It is a distributed database and it is a opensourced product. It works really well in cloud environments like AWS, azure etc. The installation and configuration is fairly simple. Review collected by and hosted on G2.com.

The cockroach db should have been had a better compatibility with the application loadbalancers as well. Although it is used for the networking loadbalancers it has the downside of not routing on the app layer Review collected by and hosted on G2.com.

CockroachDB have best support and response very fast Review collected by and hosted on G2.com.

Still don't have respective support in indonesia Review collected by and hosted on G2.com.

Help to build High availability db cluster with awesome management and aggregate a lot of opensource tools for postgres. Has operator for k8s/openshift clusters Review collected by and hosted on G2.com.

Something leader election doesnt work properly, for ocp operator very brutal setup configuration where you have a huge configmap. Management tool is required to be downloaded to local machine instead if using from container Review collected by and hosted on G2.com.

There are many cool features like:

1. Live cluster scaling options

2. Geo partitioning

3. High availability

4. backup options

5. archiving of data

6. change data capture implementation

7. different topologies for different needs

8. ACID properties

9. Authentication model

and many more.. Review collected by and hosted on G2.com.

Not exactly something I dislike but it certainly lacks consumer forums as of now because it is quite new in the market.

There are some features also that are missing in cockroach DB. Though it is coping up very good even after not having those but still sometimes those features are missed. These features include:

1. We can not write procedural code here (no support to PLSQL)

2. GIN index is a great feature but partitioning of GIN index is not yet supported

3. Some functions related to array that were present in postgres that makes the processing simpler are not available in cockroachDB. Review collected by and hosted on G2.com.

The best thing about cockroach db is that it supports various datatypes not only the standard one. Review collected by and hosted on G2.com.

It does not store timestamps properly and effectively. Review collected by and hosted on G2.com.