Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

ChDB: Embedded OLAP SQL Engine Powered by ClickHouse

github.com

Post reply on HN
Print view View original

1–10 of 35 posts

Re: ChDB: Embedded OLAP SQL Engine Powered by ClickHouse

#3

Post by andrenotgiant »

adulion wrote: post #2

why would you use this over duckdb?

I don't have an opinion, but this article gives a fairly unbiased comparison of DuckDB vs Clickhouse-local, which I imagine exhibits similar performance characteristics as ChDB, just without the embedded part: https://www.vantage.sh/blog/clickhouse-local-vs-duckdb

Re: ChDB: Embedded OLAP SQL Engine Powered by ClickHouse

#7

Post by monstrado »

adulion wrote: post #2

why would you use this over duckdb?

One reason would be if you're already fluent in ClickHouse's SQL dialect. Although they maintain great standard SQL compatibility, they also have a great deal of special functions/aggregates/etc that are ClickHouse specific.

Other reasons include their wide range of input formats, special table functions (e.g. query a URL).

Re: ChDB: Embedded OLAP SQL Engine Powered by ClickHouse

#8

Post by simonw »

I absolutely love this trend of "pip install x" as a distribution mechanism for this kind of thing.

People badmouth Python packaging a lot, but once you've learned how to use a virtual environment (admittedly a steeper learning curve than I'd like it to be) having binary wheels for so much of this kind of stuff is a huge win.

See also Playwright, DuckDB, ziglang... I wrote a bit about those here https://simonwillison.net/2022/May/23/bundling-binary-tools-...

Post reply on HN