4 ms·
> 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 transactio
by lixtra 6y 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.
- zX41ZdbW 6y agoClickHouse 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 6y agoACID seems to be a very recent feature. https://stackoverflow.com/questions/60163070/is-clickhouse-durable https://stackoverflow.com/questions/60163070/is-clickhouse-d...