I am writing a Reddit like comment store using Couchbase. For each comment, I am storing its parentId and a list of its childrenIds . Each top-level comment on a web page will have its parentId as null . I want to retrieve a comment block efficiently. By a comment block, I mean a top-level co…

Querying Highly Nested JSON

vsr1 December 25, 2018, 3:29pm 2

Couchbase doesn’t support CONNECT BY. You can use technique described here N1QL - array join

Topic		Replies	Views
Joining and nesting multiple objects under a single parent SQL++ n1ql	2	2894	July 6, 2016
How to get a node of nested arrays without knowing the deep SQL++	2	1255	August 29, 2017
How to get tree of documents in couchbase. Bottom up approach? SQL++ query	3	679	March 24, 2021
Updating a Highly Nested Document in Couchbase SQL++ query , n1ql , index	2	1447	December 26, 2018
Nested complex query across linked documents SQL++	1	857	June 12, 2019