Querying in Couchbase - N1QL

Now available in Developer Preview 3!

Welcome to the N1QL (pronounced "Nickel") corner! We're excited to introduce N1QL - our next generation query language. N1QL presents easy and familiar abstractions to quickly develop scalable applications that work with next generation database systems. It allows for joins, filter expressions, aggregate expressions and many other features to build a rich application. Go ahead and give N1QL a spin today by trying out the online tutorial or downloading N1QL for Couchbase Server.

N1QL Developer Preview - Online Tutorial

Try it now

N1QL Developer Preview - Downloads

Operating System

N1QL

Community Edition - Developer Preview

64-bit Linux

32-bit Linux

64-bit Windows

32-bit Windows

64-bit Mac OS X

Operating System

N1QL

Community Edition - Developer Preview

64-bit Linux

32-bit Linux

64-bit Windows

32-bit Windows

64-bit Mac OS X


Going beyond the download - Instructions

Step 1. Expand the package archive
Step 2. Run ./start_tutorial.sh (On Windows start_tutorial.bat)
Step 3. Open http://localhost:8093/tutorial in your browser
 
To connect to a Couchbase Server 
./cbq-engine -couchbase http://<couchbase-server-name>:8091/
 
To use the command-line interactive query tool
./cbq -engine=http://<couchbase-query-engine-server-name>:8093/


Getting Started with Couchbase on N1QL

Latest N1QL Questions

ANdrei Nechifor's picture
Asked 23 hours 14 min ago
Latest activity 6 hours 44 min ago

couchbase-net-client-2.0-dp3 -> SELECT don't work at all

I took the last couchbase-net-client-2.0-dp3
Inserting and updating of the documents works fine
The interesting part is that I can't select anything using N1QL

I also tried version 1 and version 2 and I have the same problem.
In version 1 -> results.Rows is NULL...

TomS's picture
Asked 1 week 21 hours ago
Latest activity 6 days 23 hours ago

N1QL and non-default buckets

Have downloaded and implemented N1QL per instructions. I can query the beer-sample and default buckets successfully with cbq. However, when I try to query a new bucket I have created and loaded, I get the "Bucket xxxx does not exist" error.

What have I done wrong?

cbq> select...

Latest Community Blogs

Shopper or Merchant? Check-out N1QL Querying

N1QL is a next generation query language for Couchbase Server. It goes beyond SQL and the...
Tags:   N1QL

Announcing Couchbase Query Language (N1QL) - Developer Preview 2!

I am very excited to announce the latest Developer Preview release of the Couchbase Query Language...

N1QL - It Makes Cents!

*Ba Dum Tschhh* …See what I did there? Makes cents? Get it? Haha. So… N1QL (pronounced Nickel)…...