Category: SQL++ / N1QL Query

SQL to NoSQL: Automated Migration

SQL to NoSQL: Automated Migration

SQL to NoSQL migration 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...

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
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
DataGrip Setup for Couchbase

DataGrip Setup for Couchbase

DataGrip from JetBrains has added NoSQL Couchbase support. It was first made available in their 2020.3 EAP (Early Access Preview) DataGrip 2020.3 EAP is Open! – Couchbase support – Grants – More powerful value editor – Opening transposed tables –...

November 11, 2020
Taming the Gerrymander with Geospatial Search

Taming the Gerrymander with Geospatial Search

The Basics Before you read any further, please take a few minutes and read the excellent post on geospatial search in Couchbase, as published by my friend and colleague Brian Kane: https://www.couchbase.com/blog/geospatial-search-how-do-i-use-thee-let-me-count-the-ways/ Go ahead; I’ll wait. Now that you’re back,...

November 4, 2020
Halloween Problem: Solution in N1QL.

Halloween Problem: Solution in N1QL.

Learning SQL is easy; Implementing SQL, not so much. Halloween has come and gone. But, the tricks of the Halloween problem is here to stay! This has to be solved by databases every day.  SQL made the relational database easy,...

November 3, 2020
Using NoSQL for Geospatial Search Without a Spatial Database

Using NoSQL for Geospatial Search Without a Spatial Database

Introduction Couchbase Full Text Search (FTS) is a great tool for indexing and querying geospatial data.  In this article, I’ll present a geospatial search use case and demonstrate the various ways that we can perform a search of location data...

Couchbase’s Cost-Based Optimizer for JSON is patent pending

Couchbase’s Cost-Based Optimizer for JSON is patent pending

With NoSQL databases proving their worth over the legacy SQL approach, the next question is inevitably “how do we optimize our processes as much as possible?” Many databases have used static Rule-Based Optimization (RBO) to optimize workloads – but this...

October 29, 2020
Couchbase Views and Better Alternatives [Part 1 of 2]

Couchbase Views and Better Alternatives [Part 1 of 2]

Introduction This blog is meant for users who are familiar with the basics of Couchbase Server and Views. Novice users should start here to gain basic understanding of Couchbase Server and then continue here to get acquainted with Views. Views...

N1QL Transactions : Elastic, Scalable, and Distributed

N1QL Transactions : Elastic, Scalable, and Distributed

SQL is the only 22nd-century language available for developers today. ABSTRACT In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics.  SQL as a query...

October 14, 2020
N1QL Turns Five

N1QL Turns Five

As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...

October 6, 2020