4 ms·
> 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 co
by felixyz 4y ago
> 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.
- refset 4y ago> 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/ 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-12-25.md https://github.com/frankmcsherry/blog/blob/master/posts/2022...
- felixyz 4y agoOf all the anti-SQL screeds out there, this is my favorite as well. And Frank McSherry... well, everything he writes is gold.