Hacker News Reader

Comment by geenat | Hacker News Reader

Overall I feel like this is a step in the right direction.

I do love Cockroach, but the old licensing model was pretty brutal if you required any enterprise features (ex: incremental backup).

For reference, some other data stores doing "horizontal scale of writes" ..any others I'm missing ?

* MySQL: Vitess, Planetscale, TiDB, MariaDB Spider

* Postgres: Citus, YugabyteDB, YDB, Neon

* SQLite: mvsqlite, marmot

* Document: ScyllaDB, Cassandra, DynamoDB

View on HN

If what you mean by "horizontal scale of writes" is a distributed database, then there is FoundationDB, which is one of the very few databases that offers strict serializability (see https://jepsen.io/consistency). But it isn't quite comparable, because it isn't an easy-to-use shiny tool, rather a database-building toolkit (hence the name).

What? FoundationDB disappeared down the memory hole whenever Apple acquired them.

It's still open source and actively maintained by Apple, they use it internally.

https://github.com/apple/foundationdb

It is now. There were a few years where it had basically disappeared (2015-2018). When Apple eventually put it back in the open-source world, it was done with little fanfare so it could be easy to miss.

> put it back in the open-source world

Just to clarify - FoundationDB was never open source before 2018. Binaries were available under certain conditions, but no source.

Deno KV uses FoundationDB, for example:

https://deno.com/blog/building-deno-kv

same guy who wrote mvsqlite btw

It re-appeared after 10 or so years though.

Really, what is the reason why?

Apple thought it would be in their best interest to release it.

Apple acquired the company in 2015 and 3 years later open-sourced the database.

(so much misinformation in this thread, this isn't hard to check)

Most of the others listed are relational SQL databases, FoundationDB is a key-value store.

Not a distributed systems guy, but Spanner also offers that right? Or at least I'd assume they do considering they coordinate with actual clocks so you're naturally tied with real-time.

Neon doesn't horizontal scale of writes. Just like Aurora doesn't.

Also, not all alternatives listed are ACID compliant with serializable transactions like CockroachDB is.

Most of those solutions are not on part with Cockroach, Cockroach is basically Spanner usable outside of Google. So global transaction with cluster world wide.

Spanner is cheap in comparison depending on your storage requirements. I've seen CockroachDB quoted as 10x more, and for a product that is harder to sell to stake holders.

There are some contenders in that list: TiDB, YugabyteDB, YDB.

spanner != cockroach. Spanner has specialized hardware with atomic clocks. It's better.

https://www.cockroachlabs.com/blog/living-without-atomic-clo...

> if you required any enterprise features

For me it was the multiple regions. It's like.. with that disabled why are we even here? Data residency is the whole point...

I don’t believe Neon supports multiple write nodes.

It currently does not, but it's something we would like to eventually support.

- employee

The only thing I don't like is the mandatory telemetry.

I don't like the fact that even free users need an annual license key.

Odd to see the market leader in this space not listed. It's "web scale"

Ah you must be referring to /dev/nullDB?

Right which has been come along way in 15 yrs

Reply on news.ycombinator.com