Category: SQL++ / N1QL Query
From N1QL to JavaScript and Back – Part 5: Prepared statements
In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data. and handling errors. We now move to executing dynamic statements. Prepared statements JavaScript functions can prepare and execute prepared statements, much like any request...
Marco Greco, Software Architect, Couchbase
September 21, 2022
From N1QL to JavaScript and back – Part 4: Error Handling
In previous blogs, we have covered executing N1QL from JavaScript functions, processing documents through iterators, and manipulating data. We now move onto handling errors from N1QL statements. Error handling When an error of any nature is encountered, the jsevaluator by...
Marco Greco, Software Architect, Couchbase
August 25, 2022
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...
Marco Greco, Software Architect, Couchbase
August 4, 2022
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...
Marco Greco, Software Architect, Couchbase
July 26, 2022
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...
Marco Greco, Software Architect, Couchbase
July 13, 2022
Grafana Plugin For Couchbase Visualization Released
Storing data on a Couchbase cluster is a great way to ensure the unrivaled performance and stability of your services. Coupled with our analytics service, Couchbase allows gaining insights into the data without affecting cluster performance. The number of analysis...
Dima Chechetkin
June 16, 2022
Lower TCO With SQL++ FLATTEN_KEYS For JSON Arrays
An RDBMS with a well-established schema serves well when application functions remain static. While this rigid structure can guarantee stability, it doesn’t lend itself to fast-changing business requirements. Organizations today must consider modernizing their application infrastructure and moving from RDBMS...
Binh Le
June 15, 2022
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...
Vinai Amble
June 6, 2022
Derive Insights From Azure Blob Storage Using External Analytics Collections
Following the support for Analytics external collections for Amazon Web Services (AWS) Simple Storage Service (S3) in the Couchbase Server 6.6 release, Couchbase is excited to announce the forthcoming support and general availability for Azure Blob Storage for external Analytics...
Hussain Towaileb, Software Engineer
June 6, 2022
Couchbase vs. MongoDB: NoSQL Misconceptions Part 1
Misconceptions about NoSQL have been around for as long as NoSQL itself. It’s always good to get different perspectives, so I’m kicking off a new blog series about NoSQL misconceptions, specifically when it comes to two of the top document...
Matthew Groves
June 3, 2022
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...
Binh Le
May 26, 2022
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...
Rick Jacobs
April 26, 2022