Hacker News new | ask | show | jobs
by tadkar 1944 days ago
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!
1 comments
lixtra 1944 days ago
> 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.

link
zX41ZdbW 1944 days ago
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.

link
lixtra 1944 days ago
ACID seems to be a very recent feature.

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

link