Tag: couchbase

Primary Uses for Couchbase Primary Index.

A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a...

/ August 22, 2019

Migrating Data from MongoDB to Couchbase

Migrating Data from MongoDB to Couchbase This article will guide you through a one-time migration of data from MongoDB to Couchbase. You will learn how to import data exported from MongoDB and do some basic transformation on those documents. All...

Synchronized Drawing Apps with Couchbase Mobile

Couchbase Mobile contains a robust and powerful embedded NoSQL database, called Couchbase Lite, that can be used within your iOS, Android, and Xamarin apps. The Couchbase Mobile stack also contains Sync Gateway. Sync Gateway enables secure data synchronization across Couchbase...

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

The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.

The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more.  These requirements evolve slowly. They remain even when you choose a NoSQL database....

/ May 26, 2019

Search and Rescue: 7 Reasons for N1QL (SQL) developers to use Search

People don’t want a four key index.  They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...

/ April 22, 2019

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

/ April 2, 2019

N1QL: To Query or To Analyze?

Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. Couchbase’s Query and Analytics Services both support N1QL (SQL for JSON).  A common question is: “Which service should run my...

/ January 24, 2019