Category: N1QL / Query

N1QL (Query) Basic Order of Execution.

Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...

/ June 8, 2019
AmazonxCB Blog Banner

Building a Chatbot with Couchbase, Amazon Lex, and Node.js

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

The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.

The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more.  These requirements evolve slowly. They remain even when you choose a NoSQL database....

/ May 26, 2019
data analytics dashboard tableau couchbase blog

Building a real-time data visualization dashboard with Couchbase Analytics and Tableau

This blog covers how to set up a Couchbase Analytics cluster in under 5 clicks and create a real-time visualization dashboard with Tableau.  Introduction Couchbase Server is a hybrid NoSQL database that supports operational and analytical workloads. Couchbase Analytics in...

N1QL Index Advisor: Improve Query Performance and Productivity

As application developers, your main focus is to design the most efficient queries  for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...

/ May 9, 2019

Approaches to Query Optimization in NoSQL.

A man returned home after walking around the globe for eleven years.  Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...

/ May 5, 2019

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

/ April 2, 2019

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