Category: N1QL / Query
Collections – Simplify Analysis With Couchbase Analytics
Introduction Couchbase is excited to announce a new product feature of Collections as part of its beta release 7.0 and support for collections has been extended to Analytics Service as well. Collections and scopes are logical containers within a bucket....
Cost Based Optimization with Couchbase JSON database
Couchbase Query Cost Based Optimization (CBO) was released as a Developer Preview in Couchbase 6.5, and it is now ready for GA with Couchbase v7.0. While CBO is a ubiquitous feature with traditional RDBMS, and that users have come to...
Simplifying Query & Index with Collections
Couchbase Collections available with the upcoming version 7 brings Couchbase JSON database closer to that of other RDBMS. Collections will make it easier for customers who are looking to migrate their current RDBMS data model to Couchbase document model. This...
Couchbase Transactions with N1QL
Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to Couchbase N1QL Query in the upcoming release 7. A quick recap – Couchbase provides support for multi-document ACID transactions for its...
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,...
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
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 : 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...