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 –...

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,...

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,...

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...

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...

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,...

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...

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....

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...