SQL++ / N1QL Query Archives

Using NoSQL for Geospatial Search Without a Spatial Database

Couchbase provides a variety of ways to perform geospatial search in your application. We'll review a use case for location data and demo the capabilities.

SQL++ / N1QL Query

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

Couchbase Server

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

Couchbase Analytics

Couchbase & Splunk: A Real-Time AI-Driven Analytics Platform

Get started in Continuous Intelligence with Couchbase Analytics and Splunk's machine learning toolkit for powerful realtime dashboard monitoring

SQL++ / N1QL Query

N1QL Transactions : Elastic, Scalable, and Distributed

N1QL transactions are multi-document, multi-bucket, multi-scope, multi collection, and multi-DML-statement. Read on to learn more!

SQL++ / N1QL 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,...

SQL++ / N1QL Query

Authentication Using Server-Side X.509 Certificates And N1QL

Learn how to setup X509 certificates on Couchbase Server and use them with the N1QL query and CBQ shell for authentication and authorization.

Best Practices and Tutorials

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

SQL++ / N1QL Query

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