N1QL: docs update and articles

[keshav_m]

Some of the Couchbase N1QL documentation has been vastly rewritten and expanded recently. It’s still a work in progress. See the following.

http://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/selectintro.html
http://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-language-reference/select-syntax.html
http://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-language-reference/insert.html

We’ve also published a number of articles on N1QL to help you with understanding plans, indexes, language, etc.

Understanding Index Scans in Couchbase N1QL Query - DZone Database

Indexing JSON in Couchbase - DZone Database

JOIN Faster With Couchbase Index JOINs - DZone Database

How Couchbase Won YCSB - DZone Database

KEEP CALM and QUERY JSON - DZone Database

Concurrency Behavior: MongoDB vs. Couchbase - DZone Database

[manusyone]

Hi @keshav_m. Is the issue of the LEFT OUTER JOIN addressed in this documentation?

See:

N1ql join by array

Hello @keshav_m, if you see my example you will see that I did a LEFT OUTER JOIN. In my last paragraph, I state that if I remove the o.docType from the conditions, only then will user2 appear. Am I missing something here?

[geraldss]

Hi @prasad,

Please see question on documentation of LEFT OUTER JOIN.