Category: N1QL / Query

Optimize N1QL performance using request profiling

Monitoring uncovered the resource hog. Now what? Couchbase Server 4.5 introduced a mechanism to keep an eye on executing requests, so that slow performers could be highlighted. This DZone article covers the subject of N1QL monitoring in great detail, but...

CURL Comes to N1QL: Querying External JSON Data

JSON is a helpful way to transmit data. Now, N1QL can query it thanks to a CURL update in Couchbase 5.0. See how to connect to various endpoints to do just that. N1QL has many functions that allow you to...

/ October 6, 2017

Dates, Timestamps and Timezones – A Comparative study of Oracle and N1QL support for the Date-Time feature : Part 1

Read the pdf version here. Date and Time formats/types are very different for different databases. In the article we shall compare Couchbase N1QL Date-Time functions with Oracle’s Date-Time support. Oracle contains multiple data types associated with date-time support, namely, DATE, TIMESTAMP,...

/ September 22, 2017

Blazing Fast Index Performance with Plasma

In the earlier post, we got an opportunity to introduce Plasma as the new performant storage engine that powers Global Secondary Indexes in Couchbase 5.0(beta out!). We saw some of the features of Plasma and how it is designed with...

Gear up with N1QL to the era of Engagement Databases

Couchbase Engagement Database Platform Woo-Hoo!!! Have you heard of Engagement Databases? I am sure, “No”, not until Couchbase announced it with 5.0 release. In today’s digital economy, success of a business is dependent on its ability to leverage successful digital...

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

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

/ September 7, 2017

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

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