Category: SQL++ / N1QL Query

Lower TCO With SQL++ FLATTEN_KEYS For JSON Arrays

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

June 15, 2022
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
Derive Insights From Azure Blob Storage Using External Analytics Collections

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

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

June 3, 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
Creating Python and JavaScript User Defined Functions For Geospatial Queries

Creating Python and JavaScript User Defined Functions For Geospatial Queries

SQL++ (or Couchbase N1QL) queries can access data stored in your Couchbase cluster in a variety of ways. There are situations where having the business logic as part of your data queries can also be beneficial. SQL++ supports this with...

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

Why Uplevel From MongoDB™

Why Uplevel From MongoDB™

Today’s applications need to deliver a great experience to users anywhere, all the time. For business-critical applications, there is no downtime, they must support customers 24/7, 365. Applications are being architected to run on micro-services and to be developed in...

February 22, 2022
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...

Top Blogs of 2021 – Part 2

Top Blogs of 2021 – Part 2

And now for Part 2 in our series, here are the top 5 blog posts published in 2021: 5. How we implemented distributed multi-document ACID transactions in Couchbase, by Denis Rosa In this blog post, we gave you an overview...

December 29, 2021