Is there a standard ways to work with hierarchical data in table ?

Question

Is there a standard ways to work with hierarchical data in table ?

PutinVladimir Dec '17

Created Dec '17	Last Reply Dec '17	Replies 1	Views 385	Votes 1

PutinVladimir 1.5k

Dec '17

What is the Best practice to work with classical Adjacency List (table with fields "id", "pid") in phalcon ?

May be is possible to use postgresql "WITH RECURSIVE" or exists some methods to do recursivly job for build trees in models ?

1

Serghei Iakovlev
39.2k

Accepted
answer

Dec '17

Did you try Nested Sets?

PutinVladimir · Answer 1 · 2017-12-11T00:19:55-07:00

Thanks, looks good. But nested sets much complicated then simple adjancency list. It has a lot of advatages but disavantages too. For example it is necessary to have a lot of resurces when inserting or moving element in hierarchy, it is not use db capability like "with recursive" or "ltree" of postgresql and in mysql every element modification will invalidate whole table in query_cache.