Tag: SQL

From N1QL to JavaScript and Back – Part 5: Prepared statements

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

Couchbase Lands A Third Database Patent

Couchbase Lands A Third Database Patent

It seems that with our third database patent, Couchbase is keeping the US Patent & Trademark Office very busy. We are thrilled to announce that Couchbase has been granted its third database patent in the last nine months. The Third...

From N1QL to JavaScript and back – Part 4: Error Handling

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

Upgrade to Couchbase Capella from Community Edition Now

Upgrade to Couchbase Capella from Community Edition Now

Couchbase is a NoSQL database platform that offers several editions and deployment options, including a free installation binary as well as a fully managed database as a service. This blog briefly compares our free Couchbase Community Edition to Couchbase Capella™...

August 10, 2022
Couchbase vs MongoDB: NoSQL Misconceptions Part 5

Couchbase vs MongoDB: NoSQL Misconceptions Part 5

Misconceptions on NoSQL have been around for a long time. This blog series is now wrapping up with a discussion of what it means to be “most dreaded” and what it means to give memory to a database. Be sure...

July 27, 2022
Reflecting on the BASE IPO One Year Later 

Reflecting on the BASE IPO One Year Later 

On this day last year, Couchbase became a publicly traded company. This significant milestone reflected the team’s hard work and consistent track record of success. In the time since we completed the IPO, we have achieved so much together including...

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
Couchbase vs. MongoDB: NoSQL Misconceptions Part 2

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

June 10, 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