Category: SQL++ / N1QL Query

N1QL Index Advisor: Improve Query Performance, Productivity
N1QL Index Advisor: Improve Query Performance, Productivity

Couchbase N1QL Index Advisor, a new feature in Couchbase 6.5, provides recommendations for Global Secondary Indexes for N1QL query statements.

Approaches to Query Optimization in NoSQL
Approaches to Query Optimization in NoSQL

The NoSQL and query optimization tool evaluates the possibilities and selects the efficient plan. Find out what to do when you don’t have a good optimizer.

Search & Rescue: 7 Reasons N1QL Developers Use Search
Search & Rescue: 7 Reasons N1QL Developers Use Search

Couchbase N1QL/SQL can call full-text search queries, providing powerful benefits described here including fuzzy and natural language matching.

The Unreasonable Effectiveness of SQL
The Unreasonable Effectiveness of SQL

Visit the post to learn why SQL is called a successful 4th generation language. Check out Data Models and it's implementation.

Couchbase in Telecom:  MegaFon, Russia
Couchbase in Telecom: MegaFon, Russia

Egor Kovalchuk is a deployment manager in MegaFon, one of the largest telecommunication companies in Russia.  His career in telecom spans more than a decade.  Egor’s team is in charge of developing, integrating, and monitoring multiple business systems and applications...

Couchbase’s N1QL Query Shatters the Limits of MongoDB™
Couchbase’s N1QL Query Shatters the Limits of MongoDB™

See how Couchbase’s SQL-based language for JSON (N1QL), brings the expressive power of SQL to the Couchbase Data Platform & shatters the limits of MongoDB.

Get a Bigger Picture with N1QL Window Functions and CTE
Get a Bigger Picture with N1QL Window Functions and CTE

This article focuses on a couple of examples of how you can leverage N1QL Window functions and CTE to address two very common business questions.

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

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

See how to work with Amazon Alexa requests and respond appropriately so that Alexa will relay an audio message back to the user.

N1QL: To Query or To Analyze?
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. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...

Developing AWS Lambda Functions with Golang and Couchbase NoSQL
Developing AWS Lambda Functions with Golang and Couchbase NoSQL

This post focuses on how to create a new AWS Lambda function with the Go programming language that communicates with Couchbase Server.