News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.