Category: SQL++ / N1QL Query

Preview N1QL DP4 Support for the Couchbase .NET SDK 2.0!
Preview N1QL DP4 Support for the Couchbase .NET SDK 2.0!

Yesterday, the query team here at Couchbase released the long-awaited N1QL Developer Preview 4! If you haven’t heard of N1QL, it’s an all new SQL-like query language that Couchbase is developing for querying non-relational data-stores like Couchbase. The goal is...

N1QL Developer Preview 4 (DP4) is here!
N1QL Developer Preview 4 (DP4) is here!

http://query.couchbase.com I am very excited to announce that the eagerly awaited N1QL Developer Preview 4 (DP4) is here now!   N1QL is the query language from Couchbase for querying rich data, at scale. DP4 is a significant milestone in the...

JOIN me in ushering in Developer Preview 3 of N1QL !
JOIN me in ushering in Developer Preview 3 of N1QL !

Let’s JOIN hands to welcome DP3! I am super excited to announce the immediate availability of Developer Preview 3 of the Query Language from Couchbase (N1QL). Its an amazing experience to be a part of this wonderful team that is...

Couchbase .NET SDK 2.0 Development Series: New View Querying Syntax
Couchbase .NET SDK 2.0 Development Series: New View Querying Syntax

The post focuses on providing rich query API’s to Couchbase documents. Also, it deals with new view querying enhancements to the SDK’s to get the data.

Caching queries in Couchbase for high performance
Caching queries in Couchbase for high performance

This blog provides examples of how query results can be cached into Couchbase to be retrieved from the cache instead of being served from index on disk.

Modern Big Data > Hadoop
Modern Big Data > Hadoop

That’s right. A modern big data solution requires more than Hadoop. Welcome to the data, it’s all big and fast. Welcome to Big Data Central Discuss on Hacker News Discuss on Reddit I’m excited to announce that Big Data Central...

N1QL – It Makes Cents!
N1QL – It Makes Cents!

*Ba Dum Tschhh*  …See what I did there? Makes cents? Get it? Haha. So… N1QL (pronounced Nickel)… Couchbase’s new next-generation query language; what is it?  Well, it’s a rather genius designed, human readable / writable, extensible language designed for ad-hoc...

Pagination Best Practices with Couchbase
Pagination Best Practices with Couchbase

Many documents when doing queries against a Couchbase cluster requires pagination to get rows by page. We provide best practices with sample codes.

Understanding group_level in View Queries with Compound Keys
Understanding group_level in View Queries with Compound Keys

Querying Views is what views are all about. Our documentation is great and can be found here: http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views.html Compound Keys Just to illustrate how group level works, let’s use a Map function that sorts users by the latest login timestamp, converting...

Understanding Letter Ordering in View Queries
Understanding Letter Ordering in View Queries

Map/Reduce Views are an important part of Couchbase 2.0 and understanding how to query them is also important. Our documentation is great and can be found here: http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-views.html One of the subtleties is understanding Unicode Collation ordering of letters which is...