Tag: query

Introducing the Query Interface in Couchbase Mobile 2.0

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, brings a plethora of new features and enhancements. We discussed one such enhancement, namely the new replication protocol between in an earlier blog post on Replication 2.0. In this blog post, we will introduce you...

Create the Right Index, Get the Right Performance.

Create the Right Index, Get the Right Performance.

Introduction There are three things important in database systems: performance, performance, performance. For NoSQL database systems, there are three important things: performance at scale, performance at scale, performance at scale. Understanding the index options, creating the right index, with the...

Keshav Murthy November 12, 2017
Optimize N1QL performance using request profiling

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

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

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

Announcing Couchbase Server 4.6 – What’s New and Improved

Announcing Couchbase Server 4.6 – What’s New and Improved

Couchbase delivers the Couchbase Data Platform that powers Web, Mobile, and IoT applications for digital businesses. With our newest release, Couchbase Server 4.6 provides the availability, scalability, performance, and security that enterprises require for their mission-critical applications. What’s New and...

Couchbase and the Document-Oriented NoSQL Database

Couchbase and the Document-Oriented NoSQL Database

As a developer advocate at Couchbase, I often travel around and meet people who either have no idea what NoSQL is, or more importantly what Couchbase is. For the people who are already familiar with NoSQL, Couchbase often gets compared...

Using N1QL Subquery Expressions to Query Over Nested Couchbase Documents

Using N1QL Subquery Expressions to Query Over Nested Couchbase Documents

Back in Couchbase 4.0, N1QL was introduced as a way to give developers more flexibility when querying their NoSQL data stored within Couchbase Server. You could run SQL queries against JSON data and everything would be amazing. However, with N1QL...

New to NoSQL?  Meet N1QL!

New to NoSQL? Meet N1QL!

A few years ago NoSQL might have sounded like a alien monster, but given the advances in the technology and how modern web and mobile applications are storing and accessing data, it is and has become a critical part of...

Querying for Couchbase Documents in a NativeScript Angular Mobile Application

Querying for Couchbase Documents in a NativeScript Angular Mobile Application

I recently wrote about using Couchbase as a key-value store in a NativeScript iOS and Android application built with Angular. In this example we saw how to collect user profile information to be saved or loaded from Couchbase on the...

Create a URL Shortener with Node.js and Couchbase using N1QL

Create a URL Shortener with Node.js and Couchbase using N1QL

With the boom of Twitter, SMS text messages, and other forms of short message interactions, there has been a boom in URL shortening services. For example, you can use TinyURL, Bitly, Owly, and so many others. The purpose here is...