News for hackers. Stuff that matters.
Re:ClickHouse as an alternative to Elasticsearch for log sto... by alexisread on Tuesday March 02, 2021 @03:54PM (#26320538)
I'm late to the party here, but as stated in other comments, dyplr / Linq etc. Compose better so you can extend a query easier.

Another advantage of composable syntaxes is that you can lazily evaluate parts of a query, and combine others, which allows the equivalent of a CTE on parts of a query you need to optimise.

It's also true that SQL allows pushdown of queries to the database much easier than composable syntaxes, as SQL is usually the native language there. As such it can make for a more exploratory syntax than say graphQL where you need to define joins at design-time.

There are no comments on this comment yet.