Tag: N1QL

Divide and Conquer: Couchbase GSI Index partitioning.

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

Keshav Murthy April 11, 2018
Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

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

Sitaram Vemulapalli April 3, 2018
Index Partitioning in Couchbase Server 5.5

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

Matthew Groves March 19, 2018
Auditing Couchbase N1QL Statements

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

Johan Larson March 19, 2018
New Querying Features in Couchbase Server 5.5

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

Matthew Groves March 9, 2018
Announcing Couchbase Server 5.5 – Developer Build

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

Tyler Mitchell March 8, 2018
ANSI JOIN Support in N1QL

ANSI JOIN Support in N1QL

Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key from one side of the join...

Working with JSON Arrays in N1QL

Working with JSON Arrays in N1QL

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

Johan Larson February 28, 2018
Introducing JOIN Queries in Couchbase Mobile

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

Announcing Couchbase Mobile 2.0 Beta

Announcing Couchbase Mobile 2.0 Beta

I am happy to announce that Couchbase Mobile 2.0 beta is now available for download here. Couchbase Mobile 2.0 Couchbase Mobile 2.0 is a ground breaking release with really exciting new features Improved Couchbase Lite Simplified API with built in...

Using Google Artificial Intelligence Services in Couchbase N1QL

Using Google Artificial Intelligence Services in Couchbase N1QL

“If you’re not using deep learning, you should be.” – Jeff Dean, Google Fellow. Google has started out with a mission to empower everything and everyone with Artificial Intelligence (A.I.).  It has open-sourced Tensorflow and supporting libraries to enable developers...

Keshav Murthy February 10, 2018
Couchbase for Oracle developers — Part 3 : Database Objects

Couchbase for Oracle developers — Part 3 : Database Objects

Here’s the home page for the series: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ Oracle DBAs work with clusters, machines, storage systems, disks, etc. Oracle developers and their applications work with databases, tables, rows, columns, partitions, users, data types within the Oracle database system.  Let’s compare and...

Keshav Murthy January 27, 2018