![]() The parent objects are stored in one SQL table, the child objects in another one and they can be joined based on a FK attribute, but I don't know an easy way of converting a query output (that joins both tables) into a structure like the one above. The issue I'm facing is that I'm first fetching the list of parents and appending them all to the JSON and then I have to parse the JSON to retrieve the details for the child objects.įor reference we can consider a JSON structure like this (not giving exact objects, but structure is very similar) This is just one of the new features we have delivered recently – read more about What’s New in Couchbase Server 7.1.I'm currently building an API where the requirement is to retrieve a list (nested structure) in JSON format based on the data existing in an external database. The Couchbase 7.1 FLATTEN_KEYS feature combines multiple array element predicates into a single index.Multiple relational model indexes could be combined into a single document model.The SQL++ query is simpler because there is no need to perform any JOINs.When a relational model is denormalized into a single object in the document model: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |