News for hackers. Stuff that matters.

A comment on PRQL, Pipelined Relational Query Language. Parent comment

Re:PRQL, Pipelined Relational Query Language by snthpy on Tuesday July 25, 2023 @06:41PM (#36870717)
That's probably true but the big differentiator was that DuckDB can run in your python process so there's very low fiction to adopt it.

My impression of ClickHouse was that it was more like postgresql in that regard, i.e. OLAP : OLTP as ClickHouse : Postgres as DuckDB : SQLite.

clickhouse-local may have closed the gap on that though. Can you embed it in Python as a library?

[ Parent | on HN ]
Re:PRQL, Pipelined Relational Query Language by zX41ZdbW on Tuesday July 25, 2023 @07:16PM (#36871042)
> Can you embed it in Python as a library?

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

    pip install chdb
[ Parent | on HN ]