Feature: Use Postgres LTREE for groups hierarchy - Githubissues

absmach / magistrala

Industrial IoT Messaging and Device Management Platform

https://www.abstractmachines.fr/magistrala.html

Apache License 2.0

2.42k stars 665 forks source link

Feature: Use Postgres LTREE for groups hierarchy #2214

Open arvindh123 opened 1 month ago

arvindh123 commented 1 month ago

Is your feature request related to a problem? Please describe.

Reference: https://github.com/absmach/magistrala/issues/1980

Describe the feature you are requesting, as well as the possible use case(s) for it.

Implmentation

[x] Create Extension LTREE in postgres
[ ] Add a column with name path and type as LTREE
[ ] While inserting new row If the inserting new row have no parent . path column should have value of id If the inserting new row have parent, Get the path column should have parent path + .+ id
[ ] Retrieve Ancestors / Parents and Descendants / Children by using the below given in #1980

Indicate the importance of this feature to you.

Should-have

Anything else?

No response