News for hackers. Stuff that matters.

A comment on Introduction to Datalog. Parent comment

Re:Introduction to Datalog by felixyz on Wednesday February 15, 2023 @10:39AM (#34805223)
> then I was left with "under which circumstances?"

Foremost, Datalog has great compositionality, which is one of SQL:s big weaknesses (it was designed with completely different goals). Also, things like recursive queries are completely natural in Datalog, whereas in SQL they are bolted on with recursive common table expressions.

[ Parent | on HN ]
Re:Introduction to Datalog by refset on Wednesday February 15, 2023 @10:52AM (#34805438)
> Datalog has great compositionality, which is one of SQL's big weaknesses

There's a good write-up on this aspect (amongst others) here: https://www.scattered-thoughts.net/writing/against-sql/

> recursive queries are completely natural in Datalog, whereas in SQL they are bolted on with recursive common table expressions

And similarly: https://github.com/frankmcsherry/blog/blob/master/posts/2022...

[ Parent | on HN ]
Re:Introduction to Datalog by felixyz on Thursday February 16, 2023 @08:49AM (#34818526)
Of all the anti-SQL screeds out there, this is my favorite as well. And Frank McSherry... well, everything he writes is gold.
[ Parent | on HN ]