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

bdmcleod's picture
Asked 42 min 59 sec ago

querying key with wildcard seems slow

I'd like to do somthing like:
select META().id from mybucket where META().id like "blah%";

This seems to be slow. I created a primary index, which helped, but
it's still pretty slow. They couchbase logs make it seem like the n1ql
client is querying through every doc...

SasaBHoda's picture
Asked 2 weeks 5 days ago
Latest activity 1 week 5 days ago

where can I write my questio for couchbase

I used to practice on Couchbase queries on N1Q1 which is already provided with sample data

I mean that usually, I open this folder
couchbase-query_dev_preview3_x86_64_win
and then I run the start_tutorial.bat and start learning

now I have got a Couchbase server and I...

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)…...