Re:Hierarchical Structures in PostgreSQL (2020)
by jayknight on Friday June 25, 2021 @02:15PM
(#27634421)
This is wise, but in the healthcare field, there are some pretty huge trees of things that you need to deal with sometimes. I've been involved with building out a structure a lot like MeSH[0] and some disease trees similar to ICD. Some of my implementations I would definitely do differently now because both the tools and my experience have improved. MeSH's "addresses" even match the ltree syntax, so it would probably make a lot of sense to use that.
[0] https://www.nlm.nih.gov/mesh/intro_trees.html