Alternative to MPTT using stored path
Odoo has changed the MPTT in favor of stored path: https://github.com/odoo/odoo/pull/22558
I found this comparison: https://stackoverflow.com/questions/8196175/managing-hierarchies-in-sql-mptt-nested-sets-vs-adjacency-lists-vs-storing-path
It is a good alternative but have some drawbacks:
- it limits the depth on some database backends which have a limit on VARCHAR
- it takes more space to store (unlimited VARCHAR vs 2 INTEGER)
So I think we could have both options available in trytond.