ʻO nā ʻōnaehana hoʻokele waihona e pili ana i ka SQL he kūpono kūpono wale nō ia no nā nīnau hierarchical a recursive paha. ʻOi aku ka maikaʻi o nā ʻōnaehana ʻē aʻe e like me ArangoDB (aia kahi kamaʻilio maikaʻi e pili ana i kēia ma GOTO 2016 ). Akā hiki iā ʻoe ke hana i nā nīnau hou i SQL me ke kōkua o nā hōʻike papa maʻamau a pēlā e nīnau ai i nā papa makua / keiki maʻamau no nā kūpuna a me nā pua.
Ma PostgreSQL like ke ʻano o kēia, no ka laʻana:
0672c4761d202a35a9059fa137ace7c3
Inā makemake ʻoe e kiʻi i nā keiki āpau o kekahi mea_id, hoʻohana ʻoe i nā Hōʻike Papa Hōʻuluʻulu Manaʻo:
0672c4761d202a35a9059fa137ace7c3
ʻAʻole pilikia ka nīnau ʻana i nā mākua:
0672c4761d202a35a9059fa137ace7c3