Category: N1QL / Query

JSON Data Modeling

A JSON Data Modeling Guide

When starting to learn about document databases, it’s nice to have a grip on JSON data modeling best practices. This will help you navigate the space and topics easier having an expanded vocabulary on the subject. Experience with a traditional...

/January 20, 2021

Index Advisor Supports Self-Verification and Index Pushdowns

Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...

/January 19, 2021

Simplify Couchbase Analytics: User-Defined Functions (UDFs)

Introduction One of our exciting new features in Couchbase Server 7.0 Beta is support for User-Defined Functions (UDFs) in the Analytics Service. UDFs are reusable and parameterizable N1QL queries that can be used to modularize queries and increase code reuse....

/January 4, 2021

N1QL User Defined Functions

Introduction Couchbase Server 6.5 introduced User Defined Functions as a Developer Preview feature. N1QL is primarily a declarative language – where you ask what to get, and the language works out for you the actual method. While declarative languages have...

Indexing Service Optimizations with Couchbase Collections

Couchbase Collections introduces the separation of the bucket data into logical scopes and collections, on top of the Couchbase JSON database. The separation allows the data to be separated out to different schema and tables, a concept that most RDBMS...

/December 9, 2020

New in Couchbase Server 7.0: N1QL per request memory quota

Introduction Unlike other services, the N1QL service so far hasn’t offered the ability to size its memory footprint. The principal reason for this disparity boils down to one simple fact: while the bulk of the memory consumption for services like...

Collections – simplify your analysis with Couchbase Analytics

Introduction Couchbase is excited to announce a new product feature of Collections as part of its beta release 7.0 and support for collections has been extended to Analytics Service as well. Collections and scopes are logical containers within a bucket....

/December 1, 2020

Cost Based Optimization with Couchbase JSON database

Couchbase Query Cost Based Optimization (CBO) was released as a Developer Preview in Couchbase 6.5, and it is now ready for GA with Couchbase v7.0. While CBO is a ubiquitous feature with traditional RDBMS, and that users have come to...

/November 30, 2020

Simplifying Query & Index with Collections

Couchbase Collections available with the upcoming version 7 brings Couchbase JSON database closer to that of other RDBMS. Collections will make it easier for customers who are looking to migrate their current RDBMS data model to Couchbase document model. This...

/November 25, 2020
Transactions-in-N1QL

Couchbase Transactions with N1QL

Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to Couchbase N1QL Query in the upcoming release 7. A quick recap – Couchbase provides support for multi-document ACID transactions for its...

/November 17, 2020