What I like best about CockroachDB is how it feels both powerful and simple at the same time. It’s built to scale automatically, so you don’t need to stress about servers going down or handling huge amounts of data—it just works and keeps your app running smoothly. The best part is that it uses SQL, which most developers are already familiar with, so you get the benefits of a modern, distributed database without a steep learning curve. It’s reliable, resilient, and developer-friendly, which makes it a strong choice for building apps that need to grow and stay online no matter what. Review collected by and hosted on G2.com.

What I dislike about CockroachDB is that while it’s powerful, it can sometimes feel a bit complex to configure and optimize, especially for beginners. The learning curve around understanding how data is distributed and how to get the best performance can take some time. Also, certain advanced features aren’t always as mature or as widely supported as in more traditional databases, which might cause a few limitations depending on the use case. Review collected by and hosted on G2.com.

CockroachDB makes it super easy to run a distributed SQL database without worrying about the complexity of managing replication, failover, or scaling. I like that it feels like using PostgreSQL, but under the hood, it’s handling things like automatic sharding and strong consistency across nodes. Review collected by and hosted on G2.com.

The learning curve can be a bit steep when you’re first trying to understand how it handles transactions and consistency compared to traditional databases. Some advanced features still feel less mature compared to Postgres, and debugging distributed queries can be tricky at times. Review collected by and hosted on G2.com.

CockroachDB is a SQL database that can handle large amounts of data and keeps running even if problems happen.

Its main pros is that it keeps your data safe and available in different locations, which is useful for apps with users in many places. Review collected by and hosted on G2.com.

It’s not completely simple to use, though. You need to think about how your data is organized and be ready for some steps if you have many users writing at the same time. For small projects in one location, For simpler setups, a regular Postgres database work better.

Although, CockroachDB is a good choice for teams who want a reliable database that can grow as their business grows. Review collected by and hosted on G2.com.

CockroachDB does what a database should do. Just sit there and hold my data reliably without me having to babysit. No worrying about partitioning. I don't care about servers going up or down or load balancers. I don't care if a new version is available. I just keep my schema up to date. Perform my CRUD operations and get on with building my business.

And did I mention the support? Recently I had an issue where backups to an S3 compatible bucket stopped working. Within 24 hours I was on a call with a product manager talking through the issue to understand exactly what happened and what my recommended path forward would be. Yes, by running a serverless database in the cloud as a non-enterprise I am giving up some level of control, which is what happened here when they upgraded to the latest AWS S3 SDK that had some incompatible headers, but the tradeoff is that I have zero operational headaches to deal with.

The last feature that works perfectly with my business model is the pay-as-you-go model where I can spin up as many clusters and databases as I like without getting nailed for every instance. I am in early days and I'm constantly spinning up new clusters for testing or very small customers. When I can create an isolated cluster for a customer and it only costs me a few dollars a month that's a huge win. Review collected by and hosted on G2.com.

The mot difficult thing about working with CockroachDB is learning how to think differently about the operational aspects. You have to accept that you are going to lose some level of control if you want to the Serverless cost effective model. Another challenge I've faced is that although there is a high level of Postgres protocol compatibility there are enough differences that you can't assume a zero effort lift and shift. Review collected by and hosted on G2.com.

fault tolerance, and distribution across multiple regions without downtime Review collected by and hosted on G2.com.

Not which I found so far. Looking forward to work more on it. Review collected by and hosted on G2.com.

Really good and simple to understand documentation.

Easy to work with, supports SQL.

Scales horizontally.

Low Latency Review collected by and hosted on G2.com.

Licensing fee was a bit pricy. Needed only when the scale you need is really much. Otherwise, directly using Postgres should be enough. Review collected by and hosted on G2.com.

We integrated CockroachDB into our existing analytics service stack, which relies on PostgreSQL connections, without encountering any issues. Everything worked immediately without needing any code modifications, workarounds, or special configurations. Review collected by and hosted on G2.com.

Based on our experience to date using it for our analytics platform, we haven't identified any dislikes Review collected by and hosted on G2.com.

The ease of use offered by the cloud options and the capabilities of the self hosted option. Review collected by and hosted on G2.com.

Maybe I lack experience with concurrent use of the DB, but sometimes the default config causes me trouble and I need to change it. Review collected by and hosted on G2.com.

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.