Category: N1QL / Query

Sub-documents: find and change only what you need

What separates a document store from a key-value store? A document database can query and manipulate the contents of what it stores, whereas the value remains an opaque mystery to the key-value store. With Couchbase Server 4.5, we’ve introduced our...

Prepare for This!

Get Prepared…. One of the more impressive aspects of using N1QL is the ability to use prepared statements. What are prepared statements? Why use them? What's the big deal? Consider the following example from the travel-sample bucket and dataset that are bundled...

/ February 4, 2016

Locating cbq

cbq is the command-line REPL environment for N1QL and, since version 4.0, it comes along with Couchbase Server. It's a great tool to not only learn N1QL but also to try out and optimise queries before using them in your...

Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 4: Image Uploads with Multer and base64 encoding

Part 4: Picture Upload So far, Part 0 and Part 1 cover the data model and user document used in the application followed by Part 2 where we verify accounts through email using Nodemailer and Sendgrid. We then had part...

/ January 8, 2016

Workaround for N1QL* Queries in the .NET SDK

This blog was originally posted on David Ostrovsky's personal blog. To see to original blog post, click here.  TL;DR: SELECT myBucket.* FROM myBucket A change in the way N1QL returns results for star queries in Couchbase Server 4.1 seems to have...

N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server

SQL has been around for a loooooong time. It is very intuitive and efficient way to process structured data and has been the choice for databases for many years. With the world of BIG DATA however, data has velocity, variety...

Hands-on with N1QL in London!

We're kicking off the 2016 Couchbase meet-up calendar in London with a hands-on N1QL workshop! Come and join us on January 20th at the Couchbase London office, in Shoreditch, to learn: the fundamentals of N1QL: what you can do and why how N1QL...

N1QL Samples

Learn N1QL by sample N1QL is the document query language used to query data in Couchbase Server (CB). N1QL will be an integrated part of CB 4, until then there is a preview version available. SQL for JSON Documents N1QL...

Indexes for N1QL: or how I got an order magnitude speed increase

Indexes for N1QL: or how I got an order magnitude speed increase In Couchbase 4.0 we introduced N1QL query language: a flexible query language that brings SQL-like query to JSON documents. Whenever we talk about N1QL the conversation always opens...

Are you up for a N1QL challenge?

We are looking for some awesome developers to show the world what creative apps they can build using N1QL and Couchbase 4.0 beta.   Need some infrastructure to run your app? Give Joyent a try. Joyent's Triton Elastic Container Service...