Tag: nosql
Best Practices and Patterns with Couchbase Mobile – Part 2
Couchbase Mobile enables a wide range of offline-first use cases of varying degrees of scale and complexity. In an earlier post, I discussed common patterns while using Couchbase Lite as embedded NoSQL data store within your apps. Those patterns focused...
The Top 10 Enterprise Use Cases for NoSQL
NoSQL databases — also known as document databases — have become standard in enterprises around the globe. Who uses NoSQL? Hundreds of Global 2000 companies, including the major public cloud providers. Over the last 10 years, the number of NoSQL...
How to Update Python 2 to Python 3 & The Differences Between Them
Introduction The last major Python upgrade — to version 3 — arrived in Dec. 2008, nearly 12 years ago. And yet there is a good chance that you are still working on the Python 2 product or test code. If...
Less Is More: Why Use a Cost-Based Optimizer?
Less is more. — Ludwig Mies van der Rohe There is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for...
Analytics Explain Plan – Part 1
Co-author: Till Westmann, Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...
It’s SQL. Again.
[crayon-672cd01333cbe288376602/] [crayon-672cd01333cc1210970993/] — In the spirit of Alexander Pope and Sir John Squire.
Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in the...
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)
Authors & Engineering Team: Bingjie Miao, Keshav Murthy, Marco Greco, Prathibha Bisarahalli. Couchbase, Inc. A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON database. It provides distributed data processing,...
N1QL (Query) Basic Order of Execution.
Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...
NDP Episode #27: Jason Gilmore on DreamFactory
DreamFactory is the focus of the latest episode of The NoSQL Database Podcast. Jason Gilmore joins as the special guest to talk about using DreamFactory to generate and manage APIs over (among other things) databases. The previous episode of the...
Approaches to Query Optimization in NoSQL
A man returned home after walking around the globe for eleven years. Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...