POSTGRESQL – Idiomatic approach to query hierarchical of heterogeneous data
I’m working on a personal project implying to represent hierarchical data with permission management on each node level (inheritance allowed) which I’ll call containers here for simplicity. Like a structure of folder and files in standard file system. I am working on a stack which is PostgreSQL on one side and go(lang) as backend language. I’m a complete beginner with PostgreSQL so don’t hesitate to tell me if my design is completely wrong…