Hacker News Reader

Clickhouse is not something you use for a CRUD backend.

The obsession with Clickhouse is the phenomenal performance for the OLAP use case, a scenario where there were not many open source, easy to install and maintain options. For the most part you can treat it as a “normal” database, insert data into it and query it without messing about with file format conversions and so on. The fact that it is blindingly fast is a big bonus!

View on HN

> For the most part you can treat it as a “normal” database

While Clickhouse is great at what it does, I would expect a „normal“ database to support transactions. Don’t use it to handle bank accounts.

ClickHouse supports transactional (ACID) properties for INSERT queries. It can also replicate data across geographically distributed locations with automatic support for consistency, failover and recovery. Quorum writes are supported as well.

This allows to safely use ClickHouse for billing data.

ACID seems to be a very recent feature.

https://stackoverflow.com/questions/60163070/is-clickhouse-d...

Reply on news.ycombinator.com