Category: N1QL / Query

On Par with Window Functions.

  Use golf analogy when explaining to executives. Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency...

/ November 22, 2018

It’s the workload, stupid!

As an application architect, eventually, you’d to choose the database or database service to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly divided into OLTP and...

/ November 14, 2018
Announcing Couchbase 6.0

Announcing Couchbase Server 6.0 with Analytics

We are proud to announce that Couchbase Server 6.0 is now available, with the central theme of helping reduce the time to insight from enterprise applications. As part of this release, Couchbase Analytics service is now officially available. After two...

Using N1QL with Couchbase Eventing Functions.

Now, this is not the end. It is not even the beginning of the end. But it is, perhaps, the end of the beginning. — Winston Churchill Updating data is usually not the end, but usually a progress of a...

/ October 20, 2018
linq hotel - https://commons.wikimedia.org/wiki/File:Linq_hotel.jpg by Jeremy Thompson licensed through Creative Commons

NDP Episode #24: Brant Burnett on Linq

Linq is the focus of the latest episode of The NoSQL Database Podcast. Brant Burnett joins as the special guest to talk about all things Linq and Linq with NoSQL. I’m also joined by special co-host Jeff Morris, an engineer...

YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this paradigm perfectly. But when it comes...

/ October 6, 2018

YCSB-JSON: Benchmarking JSON databases by extending YCSB

Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”.  Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an open way so they can compare...

/ September 10, 2018
6.0 beta couchbase analytics

Announcing Couchbase Server 6.0 Beta

The innovation engine at Couchbase is in full swing and we’ve made significant updates in the 6.0 beta to the Analytics, Eventing, and Full-Text Search services. Couchbase Analytics Service is now officially in beta – it’s been 2 years since...

Analytics Example

The Couchbase Data Platform in Action: Analytics

Contents What is CBAS and how does it compare to “standard” Couchbase? Example Data and Configuration Code and Queries Web Client Web Server and Queries Querying with SQL++ Query Optimization Query Results and REST Response Conclusion Postscript With the release...

Testing ANSI JOINs

Overview The main purpose of this article is to show how Couchbase ANSI JOINs are tested. In Couchbase version 5.5, you can now execute joins using the ANSI standard syntax. This addition to joins makes them much more flexible, but...

/ August 16, 2018