Category: N1QL / Query

Couchbase for Oracle Developers – Part 1 : Overview

Back in November, we presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo This blog series will cover the following topics, comparing Oracle and Couchbase from a developer perspective. This blog: Overview Architecture Database Objects...

/ January 17, 2018
Full Text Search

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Lite 2.0, now in Developer Preview introduces powerful Full Text Search (FTS) support on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you...

Database Pagination: Using OFFSET and Keyset in N1QL.

Read the pagination background in my previous article: https://blog.couchbase.com/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand.  Using OFFSET and LIMIT is the easy way to write...

/ January 11, 2018
SQL for JSON Query

How to Query Array Collections in Couchbase Lite

One of the major features introduced in Couchbase Lite 2.0 , now in Developer Preview is the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL, you will...

Couchbase Analytics Developer Preview 4 – Bringing NoETL to NoSQL

I am very excited to announce the release of Couchbase Analytics Developer Preview 4 (DP4). The focus of the previous release was unified administration, and we have continued to build on that theme in the latest release. DP4 offers new...

Comparing Couchbase Views with Couchbase N1QL & Indexing.

As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more.  It’s logical to ask the comparative question between them.  Here is a table comparing both.  This is...

/ December 4, 2017

Indexing Best Practices

Prelude: Asynchronous Indexing: Global Secondary Indexes in Couchbase can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index inserts/updates/deletes happen asynchronously and index workloads are isolated from...

SQL for JSON Query

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, now in Developer Preview brings a plethora of new features and enhancements. We discussed one such enhancement, namely the BLIP replication protocol between Couchbase Lite 2.0 and Sync Gateway (v1.5 and above) in an earlier...

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

/ November 12, 2017
Couchbase tooling

Tooling Improvements in Couchbase 5.0 (Update)

Tooling improvements have come to Couchbase Server 5.0. Note: this is an updated repost of Tooling Improvements in Couchbase 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization –...