Dba: When using JSONb for a complex hierarchy of references, is it better to Join by aggregating ...

Channel:
Peter Schneider
Subscribers:
4,140
Published on ● Video Link: https://www.youtube.com/watch?v=iEVMYBMP2Xw


Duration: 1:57
0 views
0

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?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA
Thanks to all those 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 (https://dba.stackexchange.com/questions/334615/when-using-jsonb-for-a-complex-hierarchy-of-references-is-it-better-to-join-by)Stackexchange community

I wish you all a wonderful day! Stay safe :)

join json postgresql



Other Videos By Peter Schneider


2024-01-08Codereview: Parsing PDFs into Python structures
2024-01-08Arduino: LED control with a string variable
2024-01-08How do I check whether a type is derived from vector / list / deque?
2024-01-08check common ids in multiple dataframes in R
2024-01-08Wordpress: Schedule Wordpress plugin activation and / or deactivation on a custom date and time, ...
2024-01-08How to iterate over the remaining items in a dict while looping through that dict?
2024-01-08Gis: Converting QgsPoint() to QgsGeometry() and vice versa
2024-01-08Tex: expl3's regex_replace_all has a problem with German ß, why?
2024-01-08Softwareengineering: Explain 90th-percentile response time of 2 seconds when handling 200 concurr...
2024-01-08Arduino: How does the serial monitor know where a string terminates when we use Serial.print inst...
2024-01-08Dba: When using JSONb for a complex hierarchy of references, is it better to Join by aggregating ...
2024-01-08Dba: Secondary Replica can not be joined again
2024-01-08Softwareengineering: Microservices: separate db instance vs. separate db server
2024-01-08Bitcoin: Security Of Public Bitcoin Nodes / Servers
2024-01-08Unix: Interactive bash shell: Set working directory via commandline options
2024-01-08Gis: Strange behaviour of pie diagrams in QGIS -- Pies "disappear" while zooming out
2024-01-08Unix: Is it possible to query versions of APT packages from not-my-current release without editin...
2024-01-08Ruby iterator with a function. Return the first value from function without iterating the whole list
2024-01-08C++ back method for sub-range not found after chunking list
2024-01-08Retrocomputing: Size-optimization of a 256-byte "LDIR" adapter
2024-01-08Gis: This code is giving me empty line layer


Tags:
join
json
postgresql