Category: N1QL / Query

Developing a Bitcoin Cryptocurrency Application with Node.js and NoSQL

I’ve been following cryptocurrency related subjects such as Bitcoin for a few months now and I’m very fascinated with everything that has been going on. As a web application developer, one topic that I’ve been particularly interested in learning more...

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 developer build for free right now. In this post, I’m going to cover: Why you might want to...

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

New Features in Index Service in Couchbase Server 5.5

In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features in our upcoming release. The themes...

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 developer build for free right now. In this post, I want to highlight a few of the new features and...

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

Machine Learning with Couchbase and Nexosis

Machine Learning is a tool that is helping developers and data scientists to accomplish all sorts of tasks: Classification – organize and tag data Regression – find relationships between data points Forecasting – use current data to predict the future...

join on array

Introducing JOIN Queries in Couchbase Mobile

Couchbase Lite 2.0 supports the ability to perform JOINS across your JSON documents . This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL,...