Couchbase Server 4.0 introduces SQL-based query language N1QL (Nickel)

Couchbase Server 4.0 is designed to give software application development pros a route to building more apps on Couchbase.

What is Couchbase?

Couchbase is an open-source distributed NoSQL document-oriented database that is specifically optimised for interactive applications — the play here is: the power of SQL with the flexibility of JSON, in one place.

(Ed — aren’t, like, all applications, kind of interactive applications?)

When Couchbase says ‘interactive applications’, it is referring to document access, index and query power in terms of read and write data access.

The new release introduces Couchbase’s own SQL-compatible query language for this NoSQL system, potentially then expanding the total deployment areas for the platform.

According to the firm’s website, users can, “Sort, filter, transform, group, and combine data with N1QL (“nickel”) — a declarative query language that extends SQL for JSON — by leveraging language and framework integration and fluent APIs, or writing query statements.”

“Build and extend applications with greater agility by separating how data is queried from how it is modeled. This powerful abstraction enables applications to model data one way, but query it in many ways — including those that may not yet be anticipated.”

The firm’s products and engineering ‘veep’ Ravi Mayuram says that with N1QL, and what he calls “foundational improvements” like Global Secondary Indexes, Multi-Dimensional Scaling and Cross Datacenter Replication, the firm is a new breadth of functionality to deploy a single distributed database under the majority of web, mobile and IoT applications.

1 ohodewdd.png

“N1QL (Nickel) helps developers build enterprise-class applications with less code and greater agility. N1QL is an efficient and complete declarative query language that makes it easy for developers familiar with SQL to build applications on top of a JSON data model that can be extended on demand,” said the company, in a press statement.

Couchbase Server 4.0 with N1QL also enables standard SQL-based reporting and data visualisation tools to access data stored within Couchbase.

Through ODBC and JDBC connectivity provided via Simba drivers, that can work with both the standard SQL-92 and N1QL dialects, for insight using the most widely adopted BI and data visualisation tools, including Microsoft Excel, Tableau, Looker, Qlik and more to access data stored in Couchbase.