CockroachDB

What do you like best?

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..

What do you dislike?

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.

Recommendations to others considering the product:

If you need a highly scalable, robust and high availability distributed database, You can always consider cockroachDB. Though the consumer forum is not that great as of now but the customer support is really quick and awesome.

What problems are you solving with the product? What benefits have you realized?

We wanted a robust, highly scalable and a distributed database with very low read latency across multiple geographical locations. CockroachDB solves this in a very effective manner.

CockroachDB also support change data capture(CDC) on its own. We just need to redirect the CDC traffic to the end solution where we want to store our CDC data.