Tag: nosql

Couchbase Mobile Sync

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

Tips and Tricks for upgrading from Python 2 to Python 3

Introduction There is a good chance that you might still be working on the Python 2 product or test code. If yes, then you might also be keep seeing the below deprecation message as a reminder while working with python...

Less is More: Why Cost Based Optimizer?

Less is more.  — Ludwig Mies van der Rohe This 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...

/ September 7, 2019

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-5dd375ccea858569026028/] [crayon-5dd375ccea85d729562886/] — In the spirit of Alexander Pope and Sir John Squire.

/ August 31, 2019

Window functions in Couchbase Analytics

Co-author:  Till Westmann,  Senior Director, Engineering The beta 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...

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

/ August 7, 2019

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

/ June 8, 2019
licensed via Creative Commons from https://www.maxpixel.net/Smoke-White-Background-Hand-Lamp-Magic-3110679

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

/ May 5, 2019