Category: SQL++ / N1QL Query

Midwest JS Project Source on Full Stack Node Development, Available
Midwest JS Project Source on Full Stack Node Development, Available

The full stack Node.js, Angular, and Couchbase NoSQL project source from Midwest JS is now available, with full write-up guide to success.

Paging Data Queries with N1QL
Paging Data Queries with N1QL

Dive into paging data queries with N1QL. Guest author David Allen shows us how to use a docker instance and learn about common paging use cases.

Aggregate grouping with N1QL / MapReduce
Aggregate grouping with N1QL / MapReduce

Aggregate grouping (similar to GROUP_CONCAT) can be done in Couchbase Server with N1QL's ARRAY_AGG or with a MapReduce View.

How to transition from Equivalent Indexes to Index Replicas?
How to transition from Equivalent Indexes to Index Replicas?

Moving to Index Replicas from Equivalent Indexes is easy and leads to an efficient system and also makes index manageability a breeze.

Diving into Couchbase Index Replicas
Diving into Couchbase Index Replicas

Index Replicas in Couchbase provide benefits, including high availability and load-balanced querying, simplified index management and improved performance.

Using Couchbase with R
Using Couchbase with R

Learn by example how to integrate Couchbase and R using N1QL and REST API

Couchbase Meetup Project on the OCEAN Stack Available
Couchbase Meetup Project on the OCEAN Stack Available

See how to build an API using Ottoman.js and then with N1QL instead of Ottoman.js. Both APIs will be consumed by a front-end developed in Angular.

Querying Date Ranges within Embedded JSON Document Arrays.  A Simple Example Using N1QL, Nodejs and Docker
Querying Date Ranges within Embedded JSON Document Arrays. A Simple Example Using N1QL, Nodejs and Docker

Querying and indexing document arrays is one of the most powerful features of Couchbase.  Finding array entries within a specific date range is a common requirement.  Consider the following use case. User Story: “I want to index an embedded account...

Bringing SQL to NoSQL – Rich, Declarative Querying for JSON
Bringing SQL to NoSQL – Rich, Declarative Querying for JSON

Check out the video to learn why you’d use NoSQL, NoSQL data modeling, and querying NoSQL using SQL with the N1QL language.

N1QL Performance and Feature Enhancements in Couchbase 5.0
N1QL Performance and Feature Enhancements in Couchbase 5.0

Learn about all the new N1QL and indexing features and enhancements made available in Couchbase Server 5.0.

Getting Started with NoSQL Using Couchbase Server and PHP
Getting Started with NoSQL Using Couchbase Server and PHP

Learn how to get started using NoSQL in your PHP applications with Couchbase Server, N1QL queries, and the Couchbase PHP SDK.

Music City Code Workshop on Full Stack JavaScript Development Available
Music City Code Workshop on Full Stack JavaScript Development Available

Obtain the workshop material used at Music City Code 2017 in Nashville for the workshop Full Stack Development with Node.js, Angular, NativeScript and NoSQL