Category: Global Secondary Index

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...

/ January 27, 2021

Data Structures & Algorithms For NoSQL Applications

This article introduces Data Structures and how they work with Couchbase Server 7.0 Scopes and Collections features. What are data structures? Couchbase Data Structures is an API feature that aligns the language of the database interface with a programming language....

/ January 22, 2021

N1QL Transactions : Elastic, Scalable, and Distributed

SQL is the only 22nd-century language available for developers today. ABSTRACT In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics.  SQL as a query...

/ October 14, 2020

Fully Configured Couchbase on Red Hat OpenShift in 5 Minutes

I recently did a presentation at Red Hat Users Group – North Texas on Couchbase NoSQL Operator on OpenShift. Thank you to the Red Hat Dallas team for extending the invitation for a joint session – Sam Nicholls, John Gammon, and Nick Wallace.  In the...

Index Advisor Service for N1QL (June refresh)

This is our June drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in May. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

/ June 15, 2020

Announcing Spring Data Couchbase 4.0

We are delighted to announce that the eagerly awaited Spring Data Couchbase 4.0 is now available with enhanced capabilities. Built on top of Couchbase Java SDK 3.0, Spring Data Couchbase out-of-the-box comes with technology enhancements and leverages the latest Couchbase...

/ May 12, 2020

Using Eviction Effectively to Manage Memory in Couchbase GSI

Eviction In Couchbase server, the Plasma storage subsystem used by Global Secondary Index is initialized with a specific value to be used as its memory quota. The storage subsystem constantly tracks its memory usage and adheres to its memory quota...

Flexible Query & Indexing for Flexible JSON Model.

Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...

/ April 13, 2020
N1QL

Index Advisor Service for N1QL (March refresh)

This is our March drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in Feb. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

/ March 31, 2020

FTS and N1QL: Better Performance Querying Multiple Arrays

Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays.  In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...