Category: SQL++ / N1QL Query
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, Solutions Engineer
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 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...
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
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
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 –...
Matthew Groves
November 11, 2020
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,...
Peter Reale
November 4, 2020
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,...
Keshav Murthy
November 3, 2020
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...
Brian Kane, Solutions Engineer, Couchbase
October 30, 2020
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...
Binh Le
October 29, 2020
![Couchbase Views and Better Alternatives [Part 1 of 2]](https://www.couchbase.com/blog/wp-content/uploads/2022/11/couchbase-nosql-dbaas-800x280.png)
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...
Nirvair Singh, Solutions Architect, Couchbase
October 19, 2020