Tag: N1QL

From N1QL to JavaScript and Back – Part 6: Advanced Topics

From N1QL to JavaScript and Back – Part 6: Advanced Topics

In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data, handling errors, and using prepared statements. We have a few more advanced topics to cover before we move onto manipulating JavaScript libraries, such as calling other...

Couchbase Lands A Third Database Patent

Couchbase Lands A Third Database Patent

It seems that with our third database patent, Couchbase is keeping the US Patent & Trademark Office very busy. We are thrilled to announce that Couchbase has been granted its third database patent in the last nine months. The Third...

From N1QL to JavaScript and Back – Part 3: Iterating over Documents and DML

From N1QL to JavaScript and Back – Part 3: Iterating over Documents and DML

This earlier blog goes through the basics of executing N1QL statements inside JavaScript functions. We now move onto… Iterators/Processing values So far we have purposely avoided statements that return data, and returning data from the function. This is where we...

From N1QL to JavaScript and Back – Part 2: Basic Usage

From N1QL to JavaScript and Back – Part 2: Basic Usage

The previous blog introduced to you new features in JavaScript user-defined functions. We are now going to explore them in more detail. We start with a basic mechanism to execute N1QL statements inside JavaScript code. N1QL in JavaScript There are...

From N1QL to Javascript and Back – Part 1: Introduction

From N1QL to Javascript and Back – Part 1: Introduction

Among the many great features introduced in Couchbase Server 7.0, one has the potential for a greater impact in later releases: N1QL User Defined Functions. A quick glance at the past N1QL is a declarative language, meaning that requests merely...

Second Patent Granted to Couchbase for Cost-Based Optimization

Second Patent Granted to Couchbase for Cost-Based Optimization

On April 5, 2022, the US Patent and Trademark Office granted a second patent to Couchbase for its novel approach to optimizing document-oriented database queries on arrays! This feature has been available since Couchbase Server 7.1 and Couchbase Capella 7.0...

June 6, 2022
Traverse Hierarchy with SQL++ User-defined functions (UDFs)

Traverse Hierarchy with SQL++ User-defined functions (UDFs)

User-defined functions (UDFs) are a feature that exist in most RDBMS. Whether it is Oracle PL/SQL (Procedural Language for SQL), SQL Server T-SQL (Transact-SQL), PL/pgSQL (Procedural Language/PostgreSQL), or other variants, all these languages have the general characteristics of providing a...

May 26, 2022
NoSQL DBaaS benchmarks: which cloud comes out on top?

NoSQL DBaaS benchmarks: which cloud comes out on top?

The COVID-19 pandemic has substantially increased the pace of digitization, and for many organizations, data demands have never been higher. As enterprises accelerate their digital transformation journeys, the need to quickly and efficiently scale their database infrastructure to meet increased...

April 26, 2022
Optimize Performance of External Analytics Collections in Couchbase

Optimize Performance of External Analytics Collections in Couchbase

It is crucial to plan for performance optimization and resource utilization now that there is support for external Couchbase Analytics collections (AWS S3 and Azure Blob Storage). External Couchbase Analytics collections read the data from external storage and do not...

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Couchbase Server 7.0 (Enterprise Edition) introduced a Cost-Based Optimizer (CBO). Previous versions of Couchbase Server used a Rule-Based Optimizer (RBO). Couchbase Server has naturally evolved from RBO to CBO like most major relational database systems. The CBO uses cost estimates...

New RBAC Roles in Couchbase 7.0

New RBAC Roles in Couchbase 7.0

Couchbase Server version 7.0 introduces some important changes as part of the role-based access control (RBAC) authorization system.  Couchbase Server has allowed fine-grained access controls to the platform with RBAC for administrators since version 4.5 and all users since version...

Couchbase Catalogs for the SQL Server DBA

Couchbase Catalogs for the SQL Server DBA

In this post, we introduce System Catalogs in Couchbase and walk through a specific use case compared to SQL Server. If you’re like me, after 20 years of working with SQL Server, you tend to pick up on things that...