Category: SQL++ / N1QL Query

Couchbase Analytics: Customers’ Moments of Truth Revealed!

Couchbase Analytics: Customers’ Moments of Truth Revealed!

Introduction I recently joined Couchbase’s product team to lead Couchbase Analytics. This Analytics Service enables our customers to measure near-real time business operations, derive insights from data, and drive agile decisions to expand business growth. Within my first few weeks...

June 16, 2020
Index Advisor Service for N1QL (June refresh)

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
Implement FHIR REST server with Couchbase

Implement FHIR REST server with Couchbase

This is a follow up to my previous post that covered the topic of FHIR Data Model with Couchbase N1QL. In this blog, I will discuss the topic of how to implement the FHIR Search REST API Server over the...

June 8, 2020
Implementing a Scheduler Via Couchbase Eventing (Part 1)

Implementing a Scheduler Via Couchbase Eventing (Part 1)

This is the first of a multi-part series to leverage the Couchbase Eventing Service to run multiple scheduled tasks at specific recurring intervals in a cron like fashion completely inside the database without requiring additional infrastructure via a single general-purpose...

Couchbase Data Platform Partner Training

Couchbase Data Platform Partner Training

Thanks to Binh Le, Jon Strabala & Keshav Murthy for contributing to this post. Introduction Couchbase provides a wide variety of self paced online courses as well as in-person (or virtual) training through both Couchbase’s training portal. Advent of open...

May 19, 2020
Announcing Spring Data Couchbase 4.0

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
FHIR Data Model with Couchbase N1QL

FHIR Data Model with Couchbase N1QL

Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...

April 25, 2020
Couchbase Intro for MongoDB Developers and NoSQL Experts

Couchbase Intro for MongoDB Developers and NoSQL Experts

Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from its humble beginnings of a single...

April 25, 2020
Manage Time-To-Live (TTL) Documents with Couchbase N1QL

Manage Time-To-Live (TTL) Documents with Couchbase N1QL

There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is very common. NoSQL databases were designed...

April 14, 2020
Flexible Query & Indexing for Flexible JSON Model.

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
Index Advisor Service for N1QL (March refresh)

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 MongoDB in Operator Performance Querying Multiple Arrays

FTS and N1QL: Better MongoDB in Operator 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...