N1QL was first released with Couchbase 4.0 in the fall of 2015. After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special edition of the N1QL book is intended to be read with the more expansive N1QL Book, N1QL: A Practical Guide, second edition. If you don’t have the physical book, you can read it here: https://www.couchbase.com/blog/n1ql-practical-guide-second-edition/
Couchbase 5.5 includes important N1QL language, security and performance features. ANSI join improvements not only makes the N1QL joins closer to SQL standard joins, but also extends the joins expressions to include arrays and adds the hash join to improve the performance of joins with a large number of documents. Index partitioning improves index capacity, query-ability, and performance. Couchbase 5.5 improves grouping and aggregate performance by orders of magnitude. N1QL auditing and x.509 support make it easier for compliance and security with N1QL. Query, indexing and the performance teams have worked closely to measure the performance of all these operations.
Hope you’ll find the improvements and the articles about these improvements useful to progress in your enterprise journey.
Click on the image to DOWNLOAD the PDF of the SECOND EDITION (Covers up to Couchbase 5.0).