There is a learning curve with this tool. People who are coming from traditional databases and coders need to adjust. You have to know how to do distributed database calls. So, there's a learning curve for those who manage it and write code against it. I would recommend CockroachDB to others, especially if they need an SQL database with solid transaction capabilities. For advice, understand each database's strengths and match them to your use case. There is a learning curve, so always try to learn what problems the database solves and how it fits your needs. I rate the overall product an eight out of ten.
Software Engineer at a consultancy with self employed
User
Top 10
2023-11-15T14:41:00Z
Nov 15, 2023
It is a complex database under the hood. It scales using big data techniques, synchronizing among nodes using Raft and continually compacting. The integrated web console makes it apparently easy to use. But be prepared to study and spend some quality time with Cockroach University and the documentation. This will be useful when performing optimizations on throughput. Also, if you can distribute the load on multiple nodes (possibly more than three), you will gain in scalability. There are some little formulas that bind the replication factor to the number of nodes to use.
We were interested in CockroachDB because a few of us had experienced it long ago with Postgres and that was one of the attractions. However, there are limitations to the exact compatibility. My advice to others is before you choose CockroachDB it would be good to check if it does everything you typically use in Postgres. Cross-check that it doesn't miss something you want or need or are very used to. We used CockroachDB on a small scale and it's been great. Nominally it looks really good. Our fear is we'll scale it up and it won't scale. However, it is supposed to specifications are great. We've done spiky testing and it's never been a problem. I rate CockroachDB an eight out of ten.
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
Real User
2020-05-25T07:16:44Z
May 25, 2020
At this point, I have not used this product enough to fully rate it on all of the features. In three or four months' time, I will have a better idea and understanding of it. I would rate this solution a six out of ten.
CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.
CockroachDB is inspired by...
There is a learning curve with this tool. People who are coming from traditional databases and coders need to adjust. You have to know how to do distributed database calls. So, there's a learning curve for those who manage it and write code against it. I would recommend CockroachDB to others, especially if they need an SQL database with solid transaction capabilities. For advice, understand each database's strengths and match them to your use case. There is a learning curve, so always try to learn what problems the database solves and how it fits your needs. I rate the overall product an eight out of ten.
It is a complex database under the hood. It scales using big data techniques, synchronizing among nodes using Raft and continually compacting. The integrated web console makes it apparently easy to use. But be prepared to study and spend some quality time with Cockroach University and the documentation. This will be useful when performing optimizations on throughput. Also, if you can distribute the load on multiple nodes (possibly more than three), you will gain in scalability. There are some little formulas that bind the replication factor to the number of nodes to use.
The advice of just to read the documentation and look for examples. I would rate the overall solution an eight out of ten.
We were interested in CockroachDB because a few of us had experienced it long ago with Postgres and that was one of the attractions. However, there are limitations to the exact compatibility. My advice to others is before you choose CockroachDB it would be good to check if it does everything you typically use in Postgres. Cross-check that it doesn't miss something you want or need or are very used to. We used CockroachDB on a small scale and it's been great. Nominally it looks really good. Our fear is we'll scale it up and it won't scale. However, it is supposed to specifications are great. We've done spiky testing and it's never been a problem. I rate CockroachDB an eight out of ten.
I would rate this solution a nine out of ten.
At this point, I have not used this product enough to fully rate it on all of the features. In three or four months' time, I will have a better idea and understanding of it. I would rate this solution a six out of ten.