Author
Query Graph Models With Couchbase Recursive CTE
Recursive Common Table Expressions (CTEs) and Oracle’s CONNECT BY are well-known SQL constructs among RDBMS users, facilitating the delegation of complex, interdependent data structure exploration to the database layer for enhanced processing efficiency. These constructs are crucial for querying interdependent...
Couchbase Server 7.6 Top New Features For Developers
We are thrilled to announce the launch of Couchbase 7.6, a groundbreaking update poised to redefine the landscape of database technology. This latest release is a testament to our commitment to enhancing database technology, with a significant leap in AI...
Introducing Couchbase Time Series
Couchbase is excited to announce the release of a new time-series feature as part of Couchbase 7.2. This feature is built on top of the robust Couchbase distributed database architecture, which is designed to scale horizontally as your data grows,...
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...
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...
Introducing Charts for Query & Analytics
Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...
5 Steps to Streamline Your N1QL Queries & Migrate to Collections
If you’re looking to migrate your data from a relational database to NoSQL, then now’s a better time than ever. The recent release of Couchbase 7.0 introduced Scopes and Collections – a new way to organize your JSON data. More...
Here’s How the Index Service Got Upgraded for Couchbase 7.0
Index builds and updates just got a big performance upgrade with the introduction of Scopes and Collections in Couchbase 7. The Couchbase Server 7.0 release introduces the separation of Bucket data into logical Scopes and Collections on top of the...
Boost Query Efficiency with Cost-Based Optimization in Couchbase
Database users of every kind have come to expect cost-based optimization for their queries. It’s a standard feature of all traditional relational databases (RDBMS), but there hasn’t yet been a cost-based optimizer (CBO) for NoSQL document databases. That is, until...
The N1QL Query Language Now Supports Distributed ACID Transactions
Multi-document, distributed ACID transactions are now available in Couchbase as part of the N1QL query language. Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to the Couchbase N1QL Query Service...
Couchbase’s Cost-Based Optimizer for JSON is patent pending
With NoSQL databases proving their worth over the legacy SQL approach, the next question is inevitably “how do we optimize our processes as much as possible?” Many databases have used static Rule-Based Optimization (RBO) to optimize workloads – but this...
N1QL Turns Five
As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...