Category: SQL++ / N1QL Query

Videos: Putting the SQL back into NoSQL

Videos: Putting the SQL back into NoSQL

Are you interested in using the familiar SQL language while also benefiting from the flexibility of JSON data? We’ve got a series of three videos that can help you achieve the best of both worlds. Putting the SQL back into...

September 5, 2023
Couchbase Capella Expands Security: Broadening SSO and Compliance Capabilities

Couchbase Capella Expands Security: Broadening SSO and Compliance Capabilities

In today’s digital landscape, where data breaches and security threats are a constant concern, the role of databases in safeguarding sensitive information has never been more crucial. Building upon its commitment to robust security measures, Couchbase Capella™ has further enhanced...

Recursive Query Processing in SQL++ (N1QL)

Recursive Query Processing in SQL++ (N1QL)

It is extremely likely that you have come across issues with hierarchical lookups or graph traversal in your application as a developer who handles real-world use cases. And, for obvious reasons, you prefer solving them at the database layer and...

Data Migration from Oracle to Couchbase

Data Migration from Oracle to Couchbase

You may know Couchbase as the fastest, most scalable NoSQL platform available. However, did you know that Couchbase can also be a relational database? Couchbase is a data platform that can operate with multiple simultaneous personalities all in the same...

May 2, 2023
Updating Sensor Data: Exploring Couchbase’s Multi-Model Options

Updating Sensor Data: Exploring Couchbase’s Multi-Model Options

Couchbase has become a popular choice for IoT use cases, thanks to its flexible multi-model data management capabilities. Recently, I was working with a customer in the cruise industry that had a unique challenge – they needed Couchbase to receive...

April 4, 2023
How to Model Data: A Guide To JSON Data Modeling

How to Model Data: A Guide To JSON Data Modeling

When beginning to learn about document databases, it’s nice to have a grasp of JSON data modeling basics. This will help you navigate the space and topics easier having an expanded vocabulary on the subject. Experience with a traditional relational...

November 18, 2022
Why Choose a NoSQL Database? There Are Many Great Reasons

Why Choose a NoSQL Database? There Are Many Great Reasons

NoSQL, short for “Not only SQL,” is a term used for database systems that store information in a variety of formats to support requirements that traditional relational (or SQL) databases have difficulties addressing. Legacy relational systems were designed to minimize...

From N1QL to JavaScript and Back – Part 7: Hierarchical JavaScript Storage

From N1QL to JavaScript and Back – Part 7: Hierarchical JavaScript Storage

In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data, handling errors, prepared statements and other advanced topics. The final topic to cover is a newly added feature to 7.1 that enables JavaScript library storage options....

Introducing Couchbase Capella Developer Experience Enhancements

Introducing Couchbase Capella Developer Experience Enhancements

A Fresher Couchbase Capella Developer Experience As the world around us becomes smarter and more connected, the end-user expectations for application experience, integrated functionality, performance and availability have skyrocketed. This creates a problem when organizations attempt to weave together multiple...

From N1QL to JavaScript and Back – Part 6: Advanced Topics

From N1QL to JavaScript and Back – Part 6: Advanced Topics

In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data, handling errors, and using prepared statements. We have a few more advanced topics to cover before we move onto manipulating JavaScript libraries, such as calling other...

QuickStart: Couchbase with Apache Spark on Databricks

QuickStart: Couchbase with Apache Spark on Databricks

Couchbase is the world’s leading NoSQL document database. It offers unmatched performance, flexibility and scalability on the edge, on-premise and in the cloud. Spark is one of the most popular in-memory computing environments. The two platforms can be combined to...

September 27, 2022
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...