Category: N1QL / Query

N1QL and SEARCH: How to Leverage Full-Text Index(FTS) in N1QL

The one constant challenge for many application developers with relational databases is the query performance. It is by far the most elusive feature, because the means to resolve the query performance are often limited to what the relational databases can...

/ April 2, 2019

Couchbase’s N1QL Query Shatters the Limits of MongoDB™

As NoSQL adoption grows, developers and enterprises alike require a general purpose database to replatform their mission-critical applications and services. These databases are no longer used only by backend services that need sub-second access to the data, but also by...

/ March 25, 2019

Get a Bigger Picture with N1QL Window Functions and CTE

Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...

/ March 12, 2019

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

/ February 17, 2019

Developing an Alexa Skill with Golang, AWS Lambda, and Couchbase NoSQL

Nic Raboy is an advocate of modern web and mobile development technologies. He has experience in Java, JavaScript, Golang, and a variety of frameworks such as Angular, NativeScript, and Apache Cordova. Nic writes about his development experiences related to making web and mobile...

N1QL: To Query or To Analyze?

Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. Couchbase’s Query and Analytics Services both support N1QL (SQL for JSON).  A common question is: “Which service should run my...

/ January 24, 2019

Developing AWS Lambda Functions with Golang and Couchbase NoSQL

In this tutorial, we're going to take a look at how to build a function on AWS Lambda that communicates with Couchbase using the Go programming language.

Relational to NoSQL – CRM Application Data Visibility

As a follow up to my previous webcast on the subject of Relational to NoSQL database where I discussed that we are in the third phase of the NoSQL adoption, the “Broad Replatforming” of Enterprise Application. I want to provide an...

/ January 21, 2019

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

/ December 21, 2018

JSON to Insights: Nobel Prize Winners dataset.

Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (“It’s already tomorrow in Australia”). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to...

/ December 9, 2018