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://blog.couchbase.com/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 below to download PDF (Couchbase 5.5)

Click on the image to DOWNLOAD the PDF of the SECOND EDITION (Covers up to Couchbase 5.0).

Posted by Keshav Murthy

Keshav Murthy is a Senior Director at Couchbase of N1QL R&D. Previously, he was a Senior Director at MapR, Senior Architect for IBM, with more than 20 years experience in database design & development. He lead the SQL and NoSQL R&D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelors degree in Computer Science and Engineering from the University of Mysore, India, holds eight US patents and invented databases for systems of engagement.

Leave a reply