Category: SQL++ / 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...
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...
Couchbase vs. MongoDB: NoSQL Misconceptions Part 2
Misconceptions about NoSQL have been around as long as NoSQL itself. It’s always good to get different perspectives, and so I’m continuing this blog series about NoSQL misconceptions, specifically when it comes to two of the top document database companies...
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...
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...
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...
What’s New In Couchbase Server 7.1
Can a Database Fight Inflation? Introducing Couchbase Server 7.1 This year, I’ve asked myself, how can a database help fight inflation? The answer is to make efficiency improvements in the database that outpace inflation. For as long as I’ve worked...
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...
Creating Python and JavaScript User Defined Functions For Geospatial Queries
SQL++ 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 User Defined Functions...
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...
Reuse SQL Queries between Server & Mobile App Databases
As we all know, code is expensive to maintain—the more complex the code, the higher the cost of maintaining it. Therefore, since the beginning of time, software developers have worked very hard to achieve the goal of code reusability. Couchbase...