Category: Application Design

N1QL query with Self Referencing Hierarchy

N1QL query with Self Referencing Hierarchy

A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...

Binh Le February 17, 2019
Searching JSON: compare text search in Couchbase and MongoDB.

Searching JSON: compare text search in Couchbase and MongoDB.

“Apps without search is like Google homepage without the search bar.” It’s hard to design an app without a good search.  These days, it’s also hard to find a database without a built-in search. MySQL to NoSQL, Sybase to Couchbase,...

Keshav Murthy December 21, 2018
Meeting data protection needs for Couchbase Data Platform

Meeting data protection needs for Couchbase Data Platform

In the world where data is the currency, backup & recovery for a database is as essential as any other defining parameter such as consistency or performance because the customers cannot afford data loss under any circumstance. Couchbase offers a...

JSON to Insights: Analyzing US healthcare Data.

JSON to Insights: Analyzing US healthcare Data.

“Nothing is certain except for death and taxes.” This isn’t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let’s see if we can quickly learn anything here. The dataset is the following. “name”...

Keshav Murthy December 7, 2018
Understanding Cross Data Center Replication (XDCR) – Part 1

Understanding Cross Data Center Replication (XDCR) – Part 1

If you have any familiarity with Couchbase, you definitely know XDCR. If you use Couchbase for any of your applications, you are very likely using XDCR. I wouldn’t be wrong if I said, XDCR is indeed one of our customers’...

On Par with Window Functions.

On Par with Window Functions.

Use golf analogy when explaining to executives. Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency improve...

Keshav Murthy November 22, 2018
It’s the Workload, Stupid!

It’s the Workload, Stupid!

As an application architect, eventually, you’d have to choose the database or database as a service (DBaaS) to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly...

Keshav Murthy November 14, 2018
YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this paradigm perfectly. But when it comes...

Alex Gyryk October 6, 2018
Tutorial on Using Couchbase Lite for data storage in React Native Apps

Tutorial on Using Couchbase Lite for data storage in React Native Apps

Couchbase Lite is an embedded NoSQL database for iOS, Android and .Net platforms. The framework’s API supports native platform bindings for Android (Java), iOS (Swift, ObjC) and UWP/Xamarin (csharp). This implies that if you are building a React Native app...

Using YCSB to Benchmark JSON Databases

Using YCSB to Benchmark JSON Databases

Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”.  Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an open way so they can compare...

Keshav Murthy September 10, 2018
The Couchbase Data Platform in Action: Analytics

The Couchbase Data Platform in Action: Analytics

Contents What is CBAS and how does it compare to “standard” Couchbase? Example Data and Configuration Code and Queries Web Client Web Server and Queries Querying with SQL++ Query Optimization Query Results and REST Response Conclusion Postscript With the release...

Create a GraphQL-Powered API with PHP and NoSQL

Create a GraphQL-Powered API with PHP and NoSQL

If you’ve been keeping up, you’ll know that I’ve been writing a sort-of mega series around developing with GraphQL and Couchbase. In past tutorials we’ve explored how to use GraphQL with Java, how to use GraphQL with Node.js, and how...