What does HackerNews think of chdb?

I recommend using ClickHouse instead of DuckDB.

It has been around since 2016, and it covers and extends the feature set of DuckDB with a huge margin. Worth noting that it never has breaking changes in its table format MergeTree.

I'm tracking the progress of DuckDB and see that it is modeled after ClickHouse, but does not approach it in terms of feature completeness, stability, or performance.

The closest to DuckDB option is to use its self-contained version, clickhouse-local: https://clickhouse.com/blog/extracting-converting-querying-l... or an embedded version, chdb: https://github.com/chdb-io/chdb

Different beasts, but if by any chance you love ClickHouse already and just want to run OLAP queries in-process, there's chdb: https://github.com/chdb-io/chdb

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 ...

> Can you embed it in Python as a library?

https://github.com/chdb-io/chdb

    pip install chdb