They solve the same problem in that they are OLAP data stores, but that's where the similarity ends. Clickhouse is a centralised OLAP store (like 10s of others) whilst DuckDB is an embedded database that is usually ran in process.

What is it about DuckDB and it's strange cult like following? It's nice that it's in process, but then it's an incremental improvement over Pandas. Nice tool and well implemented but I don't see what is transformative about it.

ClickHouse power is to have one binary that runs anywhere :

- local - server - cloud (*) - serverless - in-process https://github.com/chdb-io/chdb similar to DuckDB

(*) except for the forked cloud versions, ClickHouse Inc, Huawei, etc ...