Live data from Hacker News

Ask HN: What Is the Value of CockroachDB?

news.ycombinator.com

11–20 of 30 posts

Re: Ask HN: What Is the Value of CockroachDB?

#11

Everytime CockcroachDB has been on HN, the conversation has been always about their name ("what a shitty name for an enterprise software" vs. "who cares if it works well"), but I have been also wondering the same question. Are they getting adoption? And what's their unique value proposition?

> "what a shitty name for an enterprise software" vs. "who cares if it works well")

It think you mean “who cares, if it works well?”. Or, if you don't want that much disambiguating load being held up by a comma, “if it works well, who cares?”

Re: Ask HN: What Is the Value of CockroachDB?

#12
NOTE: I am on the product marketing team at CockroachLabs.

Cockroach Labs has been building CockroachDB for over five years and has reached a level of maturity where many enterprise and community customers are gaining value from the database.

We consider it a cloud-native database as it was architected with the same principles as a distributed platform like Kubernetes. It is built for scale, resilience, is shared-nothing and is comprised of a single binary across all nodes with consistent API. We have also gone to great lengths to ensure it is wire-compatible with PostgreSQL and implements a large portion of standard SQL syntax. \It is used as a relational database.

The key points we typically talk about fall into four key areas, that we lovingly refer to as CRLS (an acronym for Cockroach Labs)

Consistency - the database implements serializable isolation across distributed nodes within a cluster with acceptable latencies even both local and globally dispersed deployments.

Resilience - the database replicates data across nodes in the cluster and you can configure this to survivability at the table level for optimization of a loss of a node, zone or even region. It is an active-active system that is always on and data is always available. Further, you can implement online schema changes and rolling upgrades in production without downtime,

Scale - scaling the database is accomplished by simply spinning up a node and pointing it at the cluster. The database will take care of redistributing replicas to incorporate the new node. This is basically auto-sharding and adheres to the aforementioned policy of survivability mentioned above.

Locality - Unique to CockroachDB, you can also tie data to any particular node in the cluster. You define this at the table level. The database uses KV at the storage layer to accomplish this. Each table is represented as ordered KV pairs using the PK for the table for the Key. You work the location into the key and the distribution policy will ensure data is written to explicit nodes. This is used to ensure low latency access of data and/or to tie data to a location for compliance and privacy requirements. With online schema changes, you can manipulate the PK in production and rearrange where data is physically stored in a live production cluster.

There are numerous other capabilities in the database. We have a complete UI, deliver distributed backup/restore, change data capture and have implemented a cost-based optimizer that uses locality.

It is a relational database that you can deploy the database as a service on kubernetes and or in any cloud.

There are countless more capabilities and we invite you to check out one of our features we are most proud of… our documentation!

Also, please check out customer page - yes, these are high level but there are some stories there.

Re: Ask HN: What Is the Value of CockroachDB?

#14

Everytime CockcroachDB has been on HN, the conversation has been always about their name ("what a shitty name for an enterprise software" vs. "who cares if it works well"), but I have been also wondering the same question. Are they getting adoption? And what's their unique value proposition?

I think the name is probably hurting adoption.

The creature it refers to pretty universally considered repulsive. I'm no psychologist or anything, but I would expect that to have an undue influence on even the most rational person.

Re: Ask HN: What Is the Value of CockroachDB?

#15
The locality features are huge. Being able to do database operations near where your users are is a big win for latency in global environments.

Pairing that with edge compute like fly.io is a killer combination. That you can use most of your normal Postgres libraries with it make it an easy transition.

Re: Ask HN: What Is the Value of CockroachDB?

#16
post #13

It's relational, it scales horizontally, and it's free. That combination is surprisingly hard to find.

i'm not a database person, but does postgres not scale horizontally?

No. Read replication approaches linear horizontal scaling (though global latencies can lead to weird edge cases).

Write replication requires external products.

Re: Ask HN: What Is the Value of CockroachDB?

#17
post #13

Earlier quoted context omitted.

i'm not a database person, but does postgres not scale horizontally?

No. Read replication approaches linear horizontal scaling (though global latencies can lead to weird edge cases). Write replication requires external products.

Specifically, Postgres extensions that add write sharding are generally either (a) non-FOSS commercial products or (b) not very well maintained.

Re: Ask HN: What Is the Value of CockroachDB?

#19

what "data warehousing"/"data management" tools are missing?

In case of OLAP queries is performance[1] which is not surprising since it's an OLTP database AFAIK.

I don't know what he means by "data management"

[1]https://www.cockroachlabs.com/docs/stable/frequently-asked-q...

Re: Ask HN: What Is the Value of CockroachDB?

#20

Everytime CockcroachDB has been on HN, the conversation has been always about their name ("what a shitty name for an enterprise software" vs. "who cares if it works well"), but I have been also wondering the same question. Are they getting adoption? And what's their unique value proposition?

I think the name is probably hurting adoption. The creature it refers to pretty universally considered repulsive. I'm no psychologist or anything, but I would expect that to have an undue influence on even the most rational person.

I don't know anything about it, but my first impression is that it's as robust as a cockroach, able to take a lot of damage.
Post reply on HN