Adjacency List Tree Using Recursive WITH (Postgres 8.4) instead of Nested Set
- by Koobz
I'm looking for a Django tree library and doing my best to avoid Nested Sets (they're a nightmare to maintain).
The cons of the adjacency list model have always been an inability to fetch descendants without resorting to multiple queries. The WITH clause in Postgres seems like a solid solution to this problem.
Has anyone seen any performance…