Two years and two weeks ago, on a crisp fall day at Wall Street in New York, we launched N1QL in Couchbase 4.0. Even before the launch, we had customers using pre-release N1QL because it solved the critical business problem: manipulate the JSON data as a set, just like SQL.  In the two years since, the customers, community and the product have grown rapidly. We have hundreds of customers using it in production.  Customers have continued to innovate building modern scalable applications for CRM, user profile, entitlement, inventory, gaming and more. Community participation and interaction on the Couchbase N1QL forum have increased in quality, quantity, and complexity. We love all the interactions and tough questions. Customers and customer jobs inspire us to innovate and do more.

Since the initial release, we’ve learned from use cases and enhanced query & indexing language, performance, and capabilities in all of the releases. Novel indexing technology based on lock-free skip list has improved the performance by orders of magnitude.  Generalized array indexing is the best in the industry.  Pagination query performance has given customers both agility and scale.

We’re delighted to release the second edition of the N1QL book with updates to query optimization, monitoring, profiling, security, and tooling to reflect the features in 5.0.

Click on the image to DOWNLOAD the PDF.

 

Posted by Keshav Murthy

Keshav Murthy is a Senior Director at Couchbase R&D. Previously, he was Senior Director of Product Management at MapR, Senior Architect for IBM, with more than 20 years experience in database design & development. He lead the SQL and NoSQL query processing team IBM Informix database. He received a President's Club award 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 and holds eight US patents.

Leave a reply