Tag: SQL

How to Add Full-Text Search Functionality to Your JavaScript App

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

September 20, 2021
How to Query JSON Data Using N1QL for Node.js and Couchbase

How to Query JSON Data Using N1QL 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 N1QL / SQL queries to retrieve data from Couchbase. This post continues...

September 15, 2021
Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics

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

August 17, 2021
Ending the Relational vs NoSQL Debate, Once and for All

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

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

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

Why NoSQL JSON Databases Are So Useful

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

What is SQL? Navigating Databases for DBAs and Developers

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

April 7, 2021
Data Structures & Queries with Couchbase N1QL (SQL for JSON)

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

January 27, 2021
Index Advisor Supports Self-Verification and Index Pushdowns

Index Advisor Supports Self-Verification and Index Pushdowns

Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...

January 19, 2021
NoSQL Is Dead, Long Live NoSQL

NoSQL Is Dead, Long Live NoSQL

Dynamo accelerated the NoSQL revolution that’s driving the database industry. Recently, Amazon announced PartiQL – A SQL-Compatible Query Language for their flagship NoSQL database Amazon DynamoDB. This has brought the NoSQL “re:evolution” full circle. It’s wonderful to see the collaborative research from UCSD and...

December 16, 2020
Building Customer-Obsessed Database Applications

Building Customer-Obsessed Database Applications

Customer obsession is a powerful concept for any company. Whether your customers are internal or external users of your platform – every experience should be timely and meaningful. Customer 360 NoSQL database development is a powerful approach to delivering these...

December 1, 2020