Dba: When using JSONb for a complex hierarchy of references, is it better to Join by aggregating ...
Channel: Sophia Wagner
Date: 24/04/2024

When using JSONb for a complex hierarchy of references, is it better to Join by aggregating the IDs in the JSON, or have additional relations table?
 Hey guys! Hopefully you found a solution that helped you!
 The Content is licensed under (https://meta.stackexchange.com/help/licensing) CC BY-SA. 
 Attention! This video does always use the same license as the source!
Thanks to all the great people for their contributions!

 (dba.stackexchange.com/users/284774/henry)Henry 
 (dba.stackexchange.com/users/150011/j-d)J.D. 
 A special thanks goes out to the awesome (https://dba.stackexchange.com/questions/334615/when-using-jsonb-for-a-complex-hierarchy-of-references-is-it-better-to-join-by)Stackexchange community 
 
 If anything is off, please write me at sophia DO.T wagner A.T ois42.de
 I wish you all a chilled day! Stay safe :)
 
  postgresql join json