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
Updating a Highly Nested Document in Couchbase SQL++ query , n1ql , index	2	1407	December 26, 2018
Query for nested json SQL++ query , n1ql	2	1870	July 11, 2018
Best way to query / search deeply nested data SQL++	3	2791	February 8, 2017
Select objects from nested array SQL++ query , n1ql	2	2329	May 9, 2018
Nested document - Query Data Couchbase Server query , n1ql	2	704	July 29, 2020