3 ms·
this is where you really want to consider something like datalog instead. but wouldn't an abstraction (I think like 'connect by') that computes the fixed point
by convolvatron 3y ago
this is where you really want to consider something like datalog instead.
but wouldn't an abstraction (I think like 'connect by') that computes the fixed point or transitive closure be really useful in many of these cases and involve less cognitive overhead (even if its less general)
- cmrdporcupine 3y agoI hadn't written SQL in 10ish years (while working in embedded, etc where I didn't need it.) and when I came back SQL had added the recursive stuff to the standard and OMG, is it ever awkward. Their rolled out linear English-like syntax makes stuff like this so awkward, and this article is evidence of that, including the reach for the imperative style with the procedure and loops and so on. I'd love for someone to rewrite the examples in here in Datalog (or RAI's "Rel") just to show how much clearer and brief they become.