Category: N1QL / Query
Announcing Couchbase Server 6.5 GA – What’s New and Improved
We are pleased to announce the release of Couchbase Server 6.5 GA with stellar features that lead the innovation in the NoSQL database market. We are excited to once again pioneer some of the most sought-after relational capabilities in the...
ANSI JOIN Enhancements and ANSI MERGE
Introduction N1QL support for ANSI JOIN was first introduced in version 5.5. Currently there is a restriction in ANSI JOIN (version 5.5 and 6.0) in that the right-hand side of an ANSI JOIN must be a keyspace. This restriction will...
Couchbase 6.5 – RMS for Indexing Service
Couchbase 6.5 release includes an extensive list of Enterprise Grade Database Query capability that allows customers to expand the adoption of NoSQL database into traditional database applications. The release has added transactional capability, Analytical Window functions, user defined JS functions,...
Simple dataviz with N1QL and Google Sheets.
Do whatever it takes to present the data to aid analysis and thinking. — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...
Index Advisor Service for Couchbase N1QL(SQL for JSON)
We are excited to announce the release of : Couchbase Index Advisor Service http://index-advisor.couchbase.com Yet Another service? Why? We released N1QL(SQL for JSON) a few years ago- so that you could use SQL to retrieve and manipulate JSON data. But...
Migrating Data from MongoDB to Couchbase, Part 2
Prolog The previous article provided details on how to migrate a data set from MongoDB to Couchbase. This article will show you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show...
Testing N1QL workloads with Apache JMeter
One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...
Introducing FTS with N1QL
Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...
Deep Dive: Window functions in Couchbase Analytics
Couchbase Server 6.5 brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and provide...
Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...