Indexing Best Practices

Prelude: Asynchronous Indexing: Global Secondary Indexes in Couchbase can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index inserts/updates/deletes happen asynchronously and index workloads are isolated from...

SQL for JSON Query

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, now in Developer Preview brings a plethora of new features and enhancements. We discussed one such enhancement, namely the BLIP replication protocol between Couchbase Lite 2.0 and Sync Gateway (v1.5 and above) in an earlier...

Create the Right Index, Get the Right Performance.

Introduction There are three things important in database systems: performance, performance, performance.  For NoSQL database systems, there are three important things: performance at scale, performance at scale, performance at scale. Understanding the index options, creating the right index, with the...

/ November 12, 2017
Couchbase Shared Database Access

Access to Shared Database Bucket from Web and Mobile Clients in Couchbase Mobile (Updated)

With the release of Couchbase Mobile 1.5 and Couchbase Server 5.0,mobile ,web and desktop apps can seamlessly access documents in the same Couchbase Server bucket. This implies that a document created on the server via the Couchbase SDK will be...

Couchbase tooling

Tooling Improvements in Couchbase 5.0 (Update)

Tooling improvements have come to Couchbase Server 5.0. Note: this is an updated repost of Tooling Improvements in Couchbase 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization –...

Monitoring and profiling

Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)

Profiling and monitoring for N1QL are a big part of the Couchbase Server 5.0 release (now available for download). Note: this is an updated repost of Profiling and Monitoring in Couchbase Server 5.0 Preview (Update). Query Workbench Once again, I’ll...

Tour of Couchbase Console

Couchbase Console (video tour) – Update

Couchbase Console has a refreshed UI in Couchbase Server 5.0. Couchbase Server 5.0 is now available for download. But back in January, we were releasing developer builds to get early feedback. Note: this blog post is an updated repost of...

Optimizing Database Pagination using Couchbase N1QL.

Background: How does Google do it? When you google something or anything, it gives you back top relevant results, tells you an approximate number of documents for your topic — all under a second.   Here are some high-level pointers: https://www.google.com/search/howsearchworks/algorithms/...

/ November 2, 2017

N1QL Enhancements in Couchbase Server 5.0

N1QL enhancements have come to Couchbase. N1QL is one of the flagship features of Couchbase Server. The release of Couchbase Server 5.0 further bolsters N1QL with a range of enhancements. Many of these enhancements have been covered in previous blog...

Query Natural Language with Couchbase Server’s Powerful Full Text Search

How many times have you written a SQL query that used a LIKE operator and some wildcards to find text in a string? What kind of performance did you get when you ran that against millions of records? It was...