Category: N1QL / Query

5 Use Cases for Real-Time Prediction Serving Systems with Couchbase [Part 1 of 2]

5 Use Cases for Real-Time Prediction Serving Systems with Couchbase [Part 1 of 2]

Every machine learning use case has different performance needs, and when it comes to ML-powered enterprise prediction serving systems, it’s no different. A machine learning (ML) model takes an input (e.g., an image) and makes a prediction about it (e.g.,...

An Introduction to Couchbase Cloud: Migration Made Easy

An Introduction to Couchbase Cloud: Migration Made Easy

It’s not a straightforward question to answer: How do I move my on-premises, virtualised or public cloud solution over to a shiny new fully managed cloud infrastructure – with as little disruption as possible? Migration concerns are high on the...

How to Harness Real-Time Data Analytics Using Operational Data

How to Harness Real-Time Data Analytics Using Operational Data

Today’s organizations generate data at massive scales and volumes. Applications running on servers in the cloud, data centers and edge devices all produce more data, from more data sources, than ever before. With this growth, enterprises constantly grapple with efficiently...

July 1, 2021
J is for June, July & Java Developers

J is for June, July & Java Developers

As Java developers begin planning their June and July vacations, we felt it would be appropriate to celebrate our own commitment to a four-letter word that starts with J: Java. At Couchbase, this June and July are dedicated to Java...

Using libcouchbase / C SDK to run transactions with Couchbase 7.0

Couchbase Server 7.0 now supports N1QL transactions. Let’s try writing a C program that performs a set of transactions on a single node. Step 1: We first decide how to call the program. The inputs will be the URL to...

June 7, 2021

SQL and NoSQL comparison: ASP.NET application

This SQL and NoSQL comparison is the next step after converting your SQL Server database to Couchbase. In the previous post, I copied AdventureWorks from SQL Server to Couchbase. In this post, I’m going to show an ASP.NET Core application...

May 27, 2021

Alternate Address & Port Support for Couchbase/N1QL Clusters

In order to connect to Couchbase deployments on cloud (AWS, Azure or GCP) or Kubernetes, we support multi-addresses in the form of alternate addresses. External applications use this facility to communicate with the cluster, but not directly to the nodes....

May 13, 2021
Craft the Right Query, Get the Right Performance

Craft the Right Query, Get the Right Performance

There is a great blog on getting the best performance out of our Indexing service: “Create the Right Index, Get the Right Performance.”, both that blog and its advice have stood the test of time. So why not have a...

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
SQL to NoSQL: Automated Migration

SQL to NoSQL: Automated Migration

SQL to NoSQL seems like a contradiction, but thanks to advances and innovations in Couchbase Server’s NoSQL database, it’s becoming easier. In this post, I’ll introduce you to a tool called SqlServerToCouchbase, an open-source attempt at an automated tool to...

March 2, 2021
Use cases and Best Practices for Distributed Transactions through N1QL

Use cases and Best Practices for Distributed Transactions through N1QL

Does Couchbase support transactions? Yes! With 6.5, we introduced the ACID transaction support in Couchbase through the SDKs. The 1st question we got at the time from the customers that heard about it was: Is transaction support available through N1QL?...

February 24, 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