Re:Hierarchical Structures in PostgreSQL (2020)
by acidburnNSA on Saturday June 26, 2021 @01:20AM
(#27639324)
I like using Modified Preorder Tree Traversal. In Django apps there's a pretty good plugin [1]. Makes working with lots of hierarchical data a breeze. Good admin integration as well. Hook it up to a Quasar q-tree component on the front end and things get really fancy [2].
[1] https://django-mptt.readthedocs.io/en/latest/
[2] https://next.quasar.dev/vue-components/tree#basic