PostgreSQL Antipatterns: How deep is the rabbit hole? A look at the hierarchy
In complex ERP systems, many entities have a hierarchical nature, where homogeneous objects are structured in a tree of relationships 'ancestor – descendant' — this includes the organizational structure of the enterprise (all these branches, departments, and working groups), product catalogs, project sections, and the geography of sales points. In fact, there is no area of business automation where some hierarchy isn’t present […]
