Good ideas and conversation. No ads, no tracking. Login or Take a Tour!
That's another way to do trees, yeah. If you mean the direct parent, that's an Adjacency List, and it requires a bunch of queries (or a slow recursive query). Hubski currently does that. If you mean the root post of all comments, yeah, that's another way, but it's less powerful. E.g. we have a way to display only one comment and it's children. Storing only the root would require querying all comments on a post, even when we only need a subtree.