Category: N1QL / Query
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
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...
Nithish Raghunandanan April 20, 2022
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...
Hussain Towaileb, Software Engineer March 31, 2022
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...
Rick Jacobs February 22, 2022
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...
Bingjie Miao, Principal Software Engineer Couchbase January 25, 2022
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...
Ian McCloy, Principal Product Manager January 13, 2022
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...
Isheeta Lad December 29, 2021