Category: SQL++ / N1QL Query

Pagination in Couchbase Server with N1QL and PHP

Pagination in Couchbase Server with N1QL and PHP

Onwuka Gideon is a freelance full stack developer with years of experience designing and coding web applications and solving complex problems. He loves security, writing, and discussing new technology. When building applications that deal with a large number of documents,...

Learn N1QL in 10 Minutes: An Interactive Online Tutorial

Learn N1QL in 10 Minutes: An Interactive Online Tutorial

N1QL is SQL for JSON. The goal of N1QL is to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. The goal of N1QL is to give developers and enterprises an expressive,...

Keshav Murthy September 7, 2017
Midwest JS Project Source on Full Stack Node Development, Available

Midwest JS Project Source on Full Stack Node Development, Available

Back in August I had participated in Midwest JS located in Minneapolis, Minnesota. As you may know, I’m a huge fan of developing full stack applications with the JavaScript stack. This is exactly what I had presented on at the conference. My...

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

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