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