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 @05:56PM (#36870160)
That's awesome! ClickHouse is a great system by all accounts and I've been meaning to try out ClickHouse Local.

I'm more familiar with DuckDB and they've also been doing some great innovation on the SQL front. I don't know offhand if they can also do the forward referencing thing but they allow putting the FROM first and having GROUP BY ALL etc..

It's great to see all this innovation happening in the SQL and Query Language space more generally at the moment.

[ Parent | on HN ]
Re:PRQL, Pipelined Relational Query Language by zX41ZdbW on Tuesday July 25, 2023 @06:19PM (#36870437)
It is strange to hear about innovation in DuckDB - I see that they are gradually re-implementing the stuff already existing in ClickHouse. Sometimes they do a better job at promoting it.
[ Parent | on HN ]
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 ]
Re:PRQL, Pipelined Relational Query Language by glogla on Wednesday July 26, 2023 @05:40AM (#36875092)
They also do bunch of stuff that ClickHouse can't do, like correlated subqueries [1] or recursive CTEs.

I kinda wish for a database with ClickHouse storage, because MergeTree seems incredibly good at what it does and DuckDB optimizer, because the ClickHouse one has a lot of limitations.

[1]: https://duckdb.org/2023/05/26/correlated-subqueries-in-sql.h...

[ Parent | on HN ]