Category: SQL++ / N1QL Query

How to Denormalize Imported Documents from RDBMS Tables Using N1QL

How to Denormalize Imported Documents from RDBMS Tables Using N1QL

Data migration is full of challenges. While migrating from a relational database (RDBMS) like SQL Server or Oracle, your main challenge comes at the time of denormalizing migrated documents as per the target data models. With the introduction of scopes...

December 1, 2021
ML Meets NoSQL: Integrating Python User-Defined Functions with SQL++ for Analytics

ML Meets NoSQL: Integrating Python User-Defined Functions with SQL++ for Analytics

After conversations with our customers about the delay in obtaining analytical insights from their Python-based machine learning models, we set out to create a seamless pipeline from Python to Couchbase Analytics that returns faster insights in real time.  Introduction With...

, November 8, 2021
Announcing the 3.0 Beta Release for Mobile & Edge Computing

Announcing the 3.0 Beta Release for Mobile & Edge Computing

We’re pleased to announce the GA release of the Couchbase Lite 3.0 and Sync Gateway 3.0 platforms for mobile and edge computing solutions This major release makes great strides in the area of edge computing by expanding our edge device platform...

Level Up Your Data Visualization with Charts in Couchbase 7.0.2

Level Up Your Data Visualization with Charts in Couchbase 7.0.2

If a picture is worth a thousand words, data visualization is worth a thousand data points. With the release of Couchbase 7.0.2, the Query Workbench (and the Analytics Workbench) now include a Charts tab that allows you to create charts...

October 22, 2021
Accelerate Your Database Migration to Couchbase with erwin Data Modeler

Accelerate Your Database Migration to Couchbase with erwin Data Modeler

The relational database has been foundational to the information economy just like the steam engine enabled the industrial revolution. However, the past success of relational databases (RDBMS) is no measure for what’s needed in today’s economy. Digital transformation driven by...

Get Started with Couchbase + Java [Developer Walkthrough]

Get Started with Couchbase + Java [Developer Walkthrough]

If you’re a developer who’s new to Couchbase, this article helps you get started. This weekly walkthrough series helps you understand the basics of connecting to Couchbase, shows you how to retrieve and modify data in Couchbase Server, how to...

October 7, 2021
Introducing Ottoman v2.0: An ODM for Node.js & Couchbase

Introducing Ottoman v2.0: An ODM for Node.js & Couchbase

On behalf of the Couchbase team, I’m absolutely thrilled to announce the General Availability of Ottoman 2.0. Ottoman is an Object Document Mapper (ODM) library for Couchbase and Node.js that maps JSON documents stored in Couchbase to native JavaScript objects....

September 30, 2021
What Is a Database-as-a-Service (DBaaS)? And Why Is It Important?

What Is a Database-as-a-Service (DBaaS)? And Why Is It Important?

Two decades on, the global shift to the cloud only continues to accelerate. As part of their larger digital transformation strategy, leading enterprises are investing in modern applications that are easy to use, evolve rapidly and deliver a highly customized...

How to Build Observability Dashboards with Prometheus, Grafana & Couchbase

How to Build Observability Dashboards with Prometheus, Grafana & Couchbase

You’ve certainly heard it before: “What gets measured gets done.” It’s true: what you observe and measure is what you can improve. The key to any improvement is to first identify what to measure and then collect the related metrics....

How to Query JSON Data Using SQL++ for Node.js and Couchbase

How to Query JSON Data Using SQL++ for Node.js and Couchbase

Today’s the day your Node.js app learns “go fetch.” By following this basic tutorial, you’ll learn how to build a REST API for your Node.js app that sends SQL++ (aka N1QL) queries to retrieve data from Couchbase. This post continues...

September 15, 2021
Level Up Your Database Platform Best Practices at Couchbase Connect

Level Up Your Database Platform Best Practices at Couchbase Connect

My colleagues have already told you a lot about how amazing Couchbase ConnectONLINE will be. This free two-day tech conference is the premier event for exploring modern data, NoSQL technology and the cloud. John spoke about the need for modernization,...

September 14, 2021
The N1QL Query Language Now Has a Per-Request Memory Quota

The N1QL Query Language Now Has a Per-Request Memory Quota

Unlike other services, the SQL++ query language so far hasn’t had the option to adjust its memory footprint. Until now. With the release of Couchbase Server 7.0, the Query Service now includes a per-request memory quota. Background The principal reason...