News for hackers. Stuff that matters.
Re:Fake Trees: Using Indents for Simpler UIs by forgetfulness on Saturday December 30, 2023 @01:15PM (#38817335)
I don't find CTEs particularly fun, copying and pasting the whole tower of CTEs into another SQL window to debug the one I'm interested in is decidedly not a form of entertainment I pursue.
Re:Fake Trees: Using Indents for Simpler UIs by barrkel on Saturday December 30, 2023 @02:16PM (#38818050)
You only need one recursive CTE typically and you can encode it into a view that you join against. It just sucks for performance when you have millions of nodes.