Company
Date Published
Author
Nic Raboy, Developer Advocate, Couchbase
Word count
962
Language
English
Hacker News points
None

Summary

With the recent March 2017 Developer build of Couchbase, there were several bug fixes and feature enhancements, including improvements to core technologies like N1QL. One notable enhancement is simplified array indexing in Couchbase Server 5.0, which simplifies the syntax for creating indexes on array elements. This allows for more flexibility and ease of use when working with arrays. Additionally, relaxed variable match requirements for array indexes enable using different variable names in SELECT queries compared to CREATE INDEX statements. Furthermore, a relaxed whole array index key requirement for array indexes allows for covering array indexes without requiring the entire array attribute as an index-key. The new feature also enables indexing document meta information, such as the `cas` and `expiration` properties, which can be used to create more efficient queries. Overall, these enhancements bring power and efficiency to Couchbase's N1QL query language.