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

ohassidi's picture
Asked 8 hours 17 min ago
Latest activity 7 hours 29 min ago

where fieldName in [value1, value2]

Hey

I saw that "where fieldName in [value1, value2]" is the same as "where fieldName=value1 or fieldName=value2 which is great the thing is that when using the in array I can't add an "and" after which where in "or" I can do an "and" after. For example:

where name in [value1,...

ohassidi's picture
Asked 2 weeks 3 days ago
Latest activity 2 weeks 1 day ago

Create multiple indexes

Today I have multiple views in order to use they ability to filter and sort, for example if I have employee object the I have several views for it:

  • emit(employeeId);
  • emit(employeeAddress)
  • emit(employeeName)
  • This view are used mainly for filtering and sorting...

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