Company
Date Published
Author
Nowrin Anwar Joyita
Word count
1015
Language
English
Hacker News points
None

Summary

SQL and N1QL are two query languages that support different data models, but both can be used to query JSON documents stored in Couchbase Server. The Simba Couchbase drivers use Collaborative Query Execution (CQE) feature to pass down SQL queries to Couchbase Server for execution, which enables optimal performance by reducing the load on the client-side and leveraging the server-side capabilities of N1QL. With CQE, supported SQL features like JOIN operations are translated into analogous N1QL, allowing users to execute these operations efficiently on the server-side. Additionally, Simba Couchbase drivers support UNNEST clause in N1QL, which enables joining nested arrays with parent objects, also leveraging CQE for optimal performance. By utilizing CQE and N1QL's capabilities, Simba Couchbase drivers provide high-performance query execution while supporting a wide range of SQL features.