Category: N1QL / Query

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

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://blog.couchbase.com/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.

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
Great Smoky Mountains National Park

Geospatial Search, How Do I Use Thee? Let Me Count the Ways.

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

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

N1QL Transactions : An Elastic and Scalable Distributed Transactions

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

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

Authentication Using Server-Side X.509 Certificates With N1QL

Authentication and authorization to the query service in couchbase works in multiple ways – Passing credentials through a rest request – curl http://localhost:8093/query/service?pretty=true -d “statement=select * from system:keyspaces” -u Admin:pwd Passing credentials using the creds named parameter and/or query parameter...

/September 10, 2020

Health Checking a Couchbase Cluster

Most databases are configured and sized correctly based on the information available at the time of their initial launch, but they tend to become unhealthy or undersized due to organic growth of their datasets and/or changes in their workload profiles....

Flex Indexing vs Global Secondary Indexes

FTS Flex Index vs GSI Indexes in Couchbase Server 6.6

In this article, we will touch on some practical examples starting with N1QL queries using GSI Indexes and simulate a dataset that over time grows not just with document size, but the actual document structure growing as well. Couchbase Server makes flexible...

/August 12, 2020