Category: N1QL / Query

Bay farm island, Alameda, California

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

/ August 4, 2020

Comparing MQL features in MongoDB 4.4 with N1QL features in Couchbase 6.5

This is a short note reviewing the MongoDB MQL language features highlighted in the release blog: MongoDB 4.4: User-Driven Engineering. Ready for You.  MongoDB 4.4 release has added a number of features for the MQL language. Couchbase released 6.5 earlier...

/ July 31, 2020

Migrating Data from MongoDB to Couchbase, Part 2

Prolog The previous article provided details on how to migrate a MongoDB data set to Couchbase Server. This article shows you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show how...

FIRST CLASS SQL for FULL-TEXT SEARCH

Over time, the database industry has realized full-text search and SQL are two sides of the same coin.  Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.   The SQL databases have added...

/ July 7, 2020

Fully Configured Couchbase on Red Hat OpenShift Under Five 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...

6.0 beta couchbase analytics

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)

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

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
Prague Astronomical Clock

Implementing a robust portable cron like 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

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