While Clickhouse can be lightning fast, is it really designed to be a main backend database?
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!
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.
This allows to safely use ClickHouse for billing data.
https://stackoverflow.com/questions/60163070/is-clickhouse-d...
This is not your application backend database.
https://clickhouse.tech/docs/en/engines/table-engines/merget...
They are not like indexes for point lookups, but also sparse. Actually they are the best you can do without blowing up the storage.