Tag: array

Arrays in JSON: Modeling, Querying and Indexing Performance

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

August 4, 2020
Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build

Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build

With the recent March 2017 Developer build of Couchbase there were many bug fixes, but also feature enhancements to core technologies like N1QL.  For example, now indexes can be created on various meta information such as the document cas and...

Flattening and Querying NoSQL Array Data With Couchbase N1QL

Flattening and Querying NoSQL Array Data With Couchbase N1QL

I was browsing the Couchbase forums and I came across a question regarding queries against array data in Couchbase. Coming from a relational database, I too once struggled to grasp the concept of querying complex formatted JSON data with SQL....