[lixtra]

> 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.

[zX41ZdbW]

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.

[lixtra]

ACID seems to be a very recent feature.

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