CockroachDB Pros and Cons

There are multiple benefits of using CockroachDB, however, some of the best features which I like the most are: Ideal for ACID consistent transaction requirement, create multiple data copies across multiple nodes to provide the highest availability in case some other node goes down or fails. Robust SQL Interface, don't need to learn a new dialect for administering data. You can easily scale it and couple it as per your application necessities without much hectic as it balances data automatically as more nodes are added. Operational Simplicity is another great benefit of using CockroachDB. Due to which a cluster can easily be started using a few commands along with data replication to multiple regions. Focus on taking advantage of cloud scale and developed primarily for cloud-based applications making it perfect for modern-day requirements. Review collected by and hosted on G2.com.

Though it supports most of the Postgres SQL dialect, still it lacks support for some very useful Postgres queries which is a major drawback. Moreover, as the complexity increases it can lead to difficulty in large-scale data querying and can cause frequent crashes. Due to the major focus encompassing strong consistency & availability it results in multiple data replication. Overall the performance becomes considerably slow which can be a major drawback depending on the application requirements and architecture. Review collected by and hosted on G2.com.

Best documentation from CockroachDB helps adoption in a faster manner and DB works exceedingly better than expected. Postgres compatibility is really done in such a great manner that migrating from Postgres to CockroachDB was pretty easy than expected. Review collected by and hosted on G2.com.

None as of now. My application needs do not get me into a state where I feel like i dislike to not have any needed feature in CockroachDB. Review collected by and hosted on G2.com.

I like it auto replicating which makes it hard to kill.

We are using this where high traffic is going on , so if one node crash we are still operational.

And it's SQL is just like postgreDB.

It can be used on heavy traffic project.

It's Auto replication features provide high abilities. Review collected by and hosted on G2.com.

Few features like concat is not available for community. Review collected by and hosted on G2.com.

Distributed SQL DB with focus on OLTP

The best feature of Cockroach DB is it is managed database ,

Horizontal Scalabilty which is very helpful as in modern world of stateful application .

Cockroach DB is platform-agonisitic

Multi Active Availability Database

Geo-replication startegy

It support all modern languages include Go , Python , JS Review collected by and hosted on G2.com.

Large DB cluster requires manual start which is the drawback in production ready env Review collected by and hosted on G2.com.

The initial setup, how straight forward it is to get started with the globally distributed data store. Beats everything I have tried so far from Oracle to Cassandra DB! Review collected by and hosted on G2.com.

Missing capabilities to create SQL functions. They a very handy to manage complex relationships or to manipulate large data sets - instead of having to pull them in the application layer. Review collected by and hosted on G2.com.

High Availability feature, and easy to manage Review collected by and hosted on G2.com.

Havent found anything as of now. May be exploring more will help Review collected by and hosted on G2.com.

Found good as distributed, and gets updates frequently Review collected by and hosted on G2.com.

Performance issue regarding transactional support with java Review collected by and hosted on G2.com.

Feature rich, has great online tutorials and Cockroach University.

Wish this was around 20 years ago! ACID compliant. Review collected by and hosted on G2.com.

It can be simple but gets complex quite quickly as you start using Geolocation features, i guess there is a steep learning curve but worth it to master the advanced features. Review collected by and hosted on G2.com.

The most helpful is how easy you can setup a cockroach DB with a few steps. Also their support can be absolutely helpful. Review collected by and hosted on G2.com.

An upside is that some of their features are only in enterprise edition. Review collected by and hosted on G2.com.

Data Distribution

Access mechanism

ACID guarantee Review collected by and hosted on G2.com.

Features are great did not find any conflict yet Review collected by and hosted on G2.com.