Tag: N1QL

render_documentation_xcode_playground

Xcode Playground for Exploring Query API in Couchbase Lite 2.0

This post is a step-by-step guide for using an Xcode Playground for exploring the new querying API in Couchbase Mobile 2.0. The Couchbase Lite 2.0 Release introduces a simplified query API based on N1QL, Couchbase’s declarative query language that extends...

The Couchbase Data Platform in Action: The Couchbase Connect 2017 Silicon Valley Technical Demo

A Full Stack Application Built Using the Couchbase Data Platform This past year, at the annual Couchbase Connect conference in Silicon Valley, we were proud to present a technical demonstration showing much of the breadth of the Couchbase Data Platform...

Divide and Conquer: Couchbase GSI Index partitioning.

In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes.  Couchbase Global Secondary Index (GSI) abstracts the indexing operations and runs as a distinct service within...

/ April 11, 2018

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Couchbase N1QL is a modern query processing engine designed to provide SQL for JSON on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL supports enhanced SQL...

/ April 3, 2018

Index Partitioning in Couchbase Server 5.5

Index partitioning is a new feature available in Couchbase Server 5.5. Check out the Couchbase Server 5.5 Developer Build announcement and download the release for free right now. In this post, I’m going to cover: Why you might want to use index...

Auditing Couchbase N1QL Statements

Couchbase Server 5.5 includes the ability to keep a record of all N1QL actions taken by users. This is part of Couchbase’s more general audit functionality, introduced in 5.0. Auditing is only available in Enterprise edition. Auditing lets the administrators...

/ March 19, 2018
Question marks, querying from https://pixabay.com/en/question-mark-important-sign-1872665/

New Querying Features in Couchbase Server 5.5

New querying features figure prominently in the latest release of Couchbase Server 5.5. Check out the announcement and download the release for free right now. In this post, I want to highlight a few of the new features and show...

Announcing Couchbase Server 5.5 – Developer Build

Announcing Couchbase Server 5.5 Developer Build It is my pleasure to share this early preview of Couchbase Server 5.5 features – there are some very exciting improvements coming and this Developer Build (DB) highlights several of them. There are many...

/ March 8, 2018

ANSI JOIN Support in N1QL

Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. Previous versions of Couchbase only support lookup join and index join. Lookup join and index join works great when the document key from one side of the join...

Working with JSON Arrays in N1QL

The N1QL query language has a rich set of facilities for working with arrays in JSON. In this article, we’ll cover array constants, facilities for searching in arrays, ways to transform arrays, and some useful array functions. The format is...

/ February 28, 2018