I don't understand the obsession with ClickHouse. While it seems like it fits this particular use case, it still deals with the same limitations and challenges of columnar DBs. Your queries will be very fast with counts/averages, but there's a tradeoff with other functions: inserts are efficient for bulk inserts only, your deletes and updates are slow, no secondary indexes...
While Clickhouse can be lightning fast, is it really designed to be a main backend database?
While Clickhouse can be lightning fast, is it really designed to be a main backend database?