3 ms·
SQL not so good for tree structures. Recursive CTEs are pretty gnarly. Graphdb would be ideal.
by grumblingdev 3y ago
SQL not so good for tree structures. Recursive CTEs are pretty gnarly.
Graphdb would be ideal.
- jeremyjh 3y agoYou want to bring in a dependency to avoid writing one 8 line CTE?
- christophberger 3y agoThe number of lines needed is not a good measure for gnarliness. (To be fair, I don't know if gnarliness is measurable at all.)
- jeremyjh 3y agoIt isn’t gnarly at all, but recursive CTE are outside the experience of most SQL devs. Here “gnarly” is used to describe “unfamiliar”.
- jbverschoor 3y agoSQLite is a pretty darn good solution for any file(set) that needs atomic / consistent writes
- edgyquant 3y agoWhy not? Just add child/parent ids