News for hackers. Stuff that matters.

A comment on Just use Postgres for everything. Parent comment

Re:Just use Postgres for everything by madjam002 on Saturday December 10, 2022 @01:43PM (#33935419)
Yes I've been considering evaluating ScyllaDB, I think it could be a good fit for my use case.
[ Parent | on HN ]
Re:Just use Postgres for everything by manigandham on Tuesday December 13, 2022 @06:51AM (#33967634)
ScyllaDB (a next-gen Cassandra clone) is a "wide-column" database, or better called "advanced key/value".

This is very different from columnar/column-oriented databases which are still (usually) relational and just store data by columns instead of by rows for OLAP (large-scale analytics) usage.

[ Parent | on HN ]
Re:Just use Postgres for everything by PeterCorless on Monday December 19, 2022 @04:30PM (#34058013)
Correct. A wide-column database like ScyllaDB is still a row-based store. Usually described as a "key-key-value" because it has both a partition key for data distribution and a clustering key for sort-ordering within a partition.

Not the same-same as a "column-store" like Druid or Clickhouse or Pinot.

[Disclosure: I work at ScyllaDB.]

[ Parent | on HN ]