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

mshaw's picture
Asked 9 months 2 weeks ago
Latest activity 1 hour 1 min ago

Does N1QL support AND's

Does N1QL support a query like so:

SELECT * FROM posts WHERE category = 'Cars' AND visibility = 'EVERYONE' ORDER BY created

Will created sort on dates? I know with views getting posts that only contain specific category and visibility text is not possible, but wondering if N1QL...

jonathonl's picture
Asked 7 months 6 days ago
Latest activity 1 hour 13 min ago

How does N1QL handle the stale parameter?

1. Does N1QL use "stale=ok" for queries that use created indexes?

2. Is there an issue with stale documents for buckets that have no indexes created on them? In other words, if a primary index is not created and "SELECT * FROM default" is called, is it possible for the result from the...

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