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...
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...
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...
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...
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...
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...
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....
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...
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...
What Is a JSON Database & Why Are They 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...
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...
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...