Tag: nosql

NoSQL Document Database Replication – MongoDB vs. Couchbase

Replication has been a crucial part of Database Systems for decades for providing availability and disaster recovery. In recent times, with the evolution of distributed databases to address the need for highly available, scalable and globally distributed deployments operating across...

A spreadsheet comparing values of database query capabilities

SQL to NoSQL – 7 Metrics to Compare Query Language

Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query  to access the...

March 6, 2020
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...

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

Developers discuss how to upgrade python.

How to Update Python 2 to Python 3

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

A schematic walking map of the London Tube

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

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-609e66455c740955635268/] [crayon-609e66455c744387581384/] — 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 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,...

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

May 17, 2019