Hierarchical Structures in PostgreSQL (2020)
A great overview of the pros and cons of different approaches is given in <a href="https://de.slideshare.net/billkarwin/models-for-hierarchical-data" rel="nofollow">https://de.slideshare.net/billkarwin/models-for-hierarchical...</a>