Category: N1QL / Query
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...
Isha Kandaswamy 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...
Matthew Groves 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....
Isha Kandaswamy May 13, 2021
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...
sam.redman April 28, 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
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...
Matthew Groves March 2, 2021
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?...
Kamini Jagtiani February 24, 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
A JSON Data Modeling Guide
When starting to learn about document databases, it’s nice to have a grip on JSON data modeling best practices. This will help you navigate the space and topics easier having an expanded vocabulary on the subject. Experience with a traditional...
Eric Bishard January 20, 2021
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...
Chang Liu January 19, 2021
Simplify Couchbase Analytics: User-Defined Functions (UDFs)
Introduction One of our exciting new features in Couchbase Server 7.0 Beta is support for User-Defined Functions (UDFs) in the Analytics Service. UDFs are reusable and parameterizable N1QL queries that can be used to modularize queries and increase code reuse....
Idris Motiwala January 4, 2021
N1QL User Defined Functions
Introduction Couchbase Server 6.5 introduced User Defined Functions as a Developer Preview feature. N1QL is primarily a declarative language – where you ask what to get, and the language works out for you the actual method. While declarative languages have...
Marco Greco, Principal Software Engineer, Couchbase December 14, 2020