Category: SQL++ / N1QL Query

Paging Data Queries with N1QL

Paging Data Queries with N1QL

M. David Allen is a full-stack software engineer and entrepreneur who for more than a decade has been working with just about every different programming language and different type of database system he could get his hands on.  David has...

How to transition from Equivalent Indexes to Index Replicas?

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 Server 4.x and have the following 3 equivalent indexes spread across 3 nodes; and with Couchbase 5.0 Beta available,...

Diving into Couchbase Index Replicas

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

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

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 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
Bringing SQL to NoSQL – Rich, Declarative Querying for JSON

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

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

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 PHP and NoSQL databases. For example, how do you read and write data with...

Music City Code Workshop on Full Stack JavaScript Development Available

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

Tooling Improvements in Couchbase 5.0 Beta

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

June 7, 2017
The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker

The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker

A frequent request from customers is a way to identify PII within their databases.   I thought I’d show a brief example how this can be done. User Story: “I want to identify unencrypted credit card numbers and social security numbers...

June 1, 2017