Category: N1QL / Query

How to transition from Equivalent Indexes to Index Replicas?

In the previous post, we saw the benefits of using index replicas over equivalent indexes.  Let’s say you are on Couchbase 4.x and have the following 3 equivalent indexes spread across 3 nodes; and with Couchbase 5.0 Beta available, you...

Diving into Couchbase Index Replicas

With Couchbase Server 4.x, customers used to create Equivalent Indexes to satisfy the twin requirements of keeping the indexes highly available and to load balance the N1QL queries. What this meant was that the exact same index definition was used...

Using Couchbase with R

I have seen a lot of interest in the field about using Couchbase with R. It is an easy integration, so here you have some examples to start using it right now. As a little background, R is a language...

Couchbase Meetup Project on the OCEAN Stack Available

I was recently at two different Meetup groups in Southern California presenting on what I’m calling, the OCEAN stack, which is composed of Ottoman.js, Couchbase Server, Express Framework, Angular, and Node.js. We had a great turnout of developers hungry to...

Querying Date Ranges within Embedded JSON Document Arrays. A Simple Example Using N1QL, Nodejs and Docker

Querying and indexing document arrays is one of the most powerful features of Couchbase.  Finding array entries within a specific date range is a common requirement.  Consider the following use case. User Story: “I want to index an embedded account...

/ July 18, 2017
N1QL

Bringing SQL to NoSQL – Rich, Declarative Querying for JSON

Couchbase Server is a document-oriented NoSQL database. Most NoSQL systems force you to sacrifice the rich querying capabilities of SQL in trade for the other benefits they offer. At Couchbase, we’ve developed the N1QL query language to solve this problem....

N1QL Performance and Feature Enhancements in Couchbase 5.0

With Couchbase 5.0 nearing stable release, it is a good idea to revisit some of the enhancements, both in performance and features, that are coming with the N1QL technology.

Getting Started with NoSQL Using Couchbase Server and PHP

A few days ago I wrote about using PHP with Docker and Couchbase, but I never really got into best practices of going all in with NoSQL. For example, how do you read and write data with Couchbase Server while...

Music City Code Workshop on Full Stack JavaScript Development Available

This past week I was in Nashville, Tennessee attending the Music City Code conference. It was a very interesting conference and my first experience in Nashville as I’m a California native. At Music City Code I gave a workshop titled, Full...

Couchbase tooling

Tooling Improvements in Couchbase 5.0 Beta

Tooling improvements have come to Couchbase Server 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization – to better understand how a query is going to execute Query monitoring...