Tag: SQL
Announcing Couchbase Capella: a Database-as-a-Service for Building Modern Applications
I’m excited to announce the release of Couchbase CapellaTM, a database-as-a-service that makes it faster, easier, and more affordable for developers and teams to build enterprise applications. Over the past decade, there’s been a strong movement of shifting technologies to...
Scott Anderson
October 19, 2021
How to Add Full-Text Search Functionality to Your JavaScript App
It’s unavoidable: If you’re working with a document database, you’re eventually going to need to search for (and through) your JSON documents. In this tutorial, you’ll add the full-text search capabilities of Couchbase to the basic REST API built with...
Tyler Mitchell
September 20, 2021
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...
Tyler Mitchell
September 15, 2021
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...
Marco Greco, Software Architect, Couchbase
September 8, 2021
Your Guide to User-Defined Functions in Couchbase Analytics
User-defined functions put you in the driver’s seat when it comes to querying and analyzing your data. In the Couchbase ecosystem, user-defined functions (UDFs) are reusable and parameterizable SQL++ queries that enable you to modularize queries and increase code reuse...
Idris Motiwala
August 26, 2021
Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics
Data analytics capabilities in Couchbase just got more robust with the 7.0 release. I’m excited to announce two new powerful capabilities now available as part of Couchbase Analytics: 1) the CUBE functionality, and 2) ROLLUP aggregation, both to help you...
Idris Motiwala
August 17, 2021
Ending the Relational vs NoSQL Debate, Once and for All
Couchbase 7.0 is a major milestone for databases. In the latest release, there are over 33 major innovations and 100 minor innovations, all culminating in a product that is both ground breaking and yet familiar to developers and DevOps engineers....
Ravi Mayuram, CTO and SVP, Products & Engineering
July 30, 2021
Couchbase Goes Public: Making Tomorrow Better Than Today
Today Couchbase has entered its next chapter as a publicly traded company as we officially began trading on the Nasdaq under the ticker symbol “BASE.” This is a significant milestone for our company – one that reflects Team Couchbase’s hard...
Matt Cain, President & CEO
July 22, 2021
3 Reasons Customers Turn from MongoDB to Couchbase
Let’s face it. MongoDB is a popular NoSQL database upon which to build applications. But just like many “beginner” data analysis projects that start in a spreadsheet, when it’s time to get serious, it’s also time to upgrade. And when...
Tim Rottach, Director of Product Line Marketing
July 14, 2021
Why NoSQL JSON Databases Are So Useful
My family hears me talk about JSON databases rather frequently. Naturally, I had to explain that Jason is not the owner of my company! Instead, many modern databases use JSON as a data format. They usually leave the room at...
Jeff Morris, VP Product Marketing
June 14, 2021
What is SQL? Navigating Databases for DBAs and Developers
This article briefly introduces the essentials of SQL – its meaning, definition, and application to different database technologies. We introduce many different types of systems that use SQL – from databases to event stream processing. What is SQL? Define: SQL...
Tyler Mitchell
April 7, 2021
Data Structures & Queries with Couchbase N1QL (SQL for JSON)
In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...
Tyler Mitchell
January 27, 2021