News for hackers. Stuff that matters.

A comment on Ask HN: How do I represent a hierarchy in RDBMS?.

Re:Ask HN: How do I represent a hierarchy in RDBMS? by ahsd1 on Tuesday May 28, 2019 @12:52PM (#20031929)
http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgr...

Look into ltree in postgres or similar

[ Parent | on HN ]
Re:Ask HN: How do I represent a hierarchy in RDBMS? by metapsj on Tuesday May 28, 2019 @02:04PM (#20032697)
great for data that is mostly read intensive. not so great if you have lots of writes.

@maxk42 approach with the relationship table works well for both read and write intensive applications.

[ Parent | on HN ]