N1QL

N1QL (pronounced "nickel") is a declarative query language developed by Couchbase for its Couchbase Server document database. It extends the familiar SQL syntax to allow querying, creating, updating, and deleting JSON documents, effectively bridging the gap between traditional relational…

Key facts

First appeared
2014
Category
technology
Problem solved
N1QL was created to address the significant challenge developers faced when querying semi-structured JSON data within NoSQL document databases. Before N1QL, interacting with JSON data in Couchbase often meant relying on low-level key-value lookups, imperative application logic, or complex and static MapReduce views, which were cumbersome for ad-hoc queries, analytical tasks, and complex data retrieval, making the transition from relational databases difficult.
Platforms
Couchbase Server (Linux, Windows, macOS), Cloud environments (AWS, Azure, GCP)

Related technologies

Notable users

  • Capital One
  • United Airlines
  • Sky
  • Verizon
  • AT&T
  • Comcast