See https://github.com/jimfulton/acl-filtered-search
In addition to exploring materialized paths, I looked at using Postgres arrays ACEs, which seemed to be the best approach, mainly because ur tied for being the fastest and provided the cleanest database representation. https://github.com/jimfulton/acl-filtered-search#recursive-search-representing-acls-as-postgres-arrays
See https:/ /github. com/jimfulton/ acl-filtered- search
In addition to exploring materialized paths, I looked at using Postgres arrays ACEs, which seemed to be the best approach, mainly because ur tied for being the fastest and provided the cleanest database representation. https:/ /github. com/jimfulton/ acl-filtered- search# recursive- search- representing- acls-as- postgres- arrays