Re:Eva AI-Relational Database System
by johnthescott on Friday May 12, 2023 @07:32PM
(#35923828)
jsonb queries in postgres have been very performant for us over +tb data sets. however, we often materialize views of large json blobs, just cause we can.
- MongoDB
- ZODB
- Others
- This is also how disk file systems operate
You access items by their path, instead of id. Also path is relevant how the data is physically stored, fetching nearby data being cheaper.
To work with this kind of data in SQL you need to construct recursive CTE queries. While it’s possible, it is a bit akward sometimes.