3 ms·
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 the
by tadkar 6y 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!
- 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...