Hacker News new | ask | show | jobs
by dominotw 2713 days ago
> If you surveyed most NewSQL databases today, most of them are built on top of an LSM, namely, RocksDB.

Is this actually true?

spark, foundationdb, memsql, nuodb , citus . I am not sure any of these are built on top of rocksdb.

Which ones are actually built on lsm?

2 comments

None of those are newsql other than MemSQL, which is an OLAP system that uses a custom rowstore format and parquet for columnstores.

In addition to CockroachDB there's also TiDB which runs on top of TiKV which uses RocksDB.

> None of those are newsql other than MemSQL

Why aren't citus, nuodb 'newsql'?

> there's also TiDB

One more example doesn't qualify the statement "most are built on rocksdb". I wasn't saying there is only one newsql db built on rocksdb.

Of the 14 examples listed here https://en.wikipedia.org/wiki/NewSQL

only 2 that you mentioned seem to be built on rocksdb.

I'm not disagreeing, RocksDB is not used by most. The statement in the blog post is not true.
Cassandra, MongoDB, BigTable, InfluxDB, LevelDB.
> Cassandra, MongoDB, BigTable, InfluxDB, LevelDB.

None of these are NewSql[1](ACID and SQL) though.

1. https://en.wikipedia.org/wiki/NewSQL