Re:Apache Age, a PostgreSQL Extension with Graph Database Fu...
by ramraj07 on Wednesday November 02, 2022 @11:55PM
(#33446795)
I once achieved it by setting a parent_id string column - for root comments it’ll just be article id. For replies it’ll be “parent_comment.parent_id || parent_comment.id”. Then it’s just a single list no recursion needed to get the full hierarchy at whatever level. Can also be easily migrated to dynamodb and get infinite scaling and zero downtime costs.
[ Parent
| on HN ]
There are no comments on this comment yet.