Category: SQL++ / N1QL Query
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?
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
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...
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 PHP and NoSQL databases. For example, how do you read and write data with...
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 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...
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...