Tag: N1QL

Couchbase for Oracle Developers – Part 2 : Architecture

Back in November, Raju Suravarjjala, (Sr. Director, Couchbase QE & Performance) and I  presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/  This series is written in...

/ January 22, 2018

Couchbase for Oracle Developers – Part 1 : Overview

Back in November, Raju Suravarjjala,(Sr. Director, Couchbase QE & Performance) and I  presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/  This series is written in collaboration...

/ January 17, 2018
Full Text Search

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Lite 2.0, now in Developer Preview introduces powerful Full Text Search (FTS) support on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you...

Database Pagination: Using OFFSET and Keyset in N1QL.

Read the pagination background in my previous article: https://blog.couchbase.com/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand.  Using OFFSET and LIMIT is the easy way to write...

/ January 11, 2018

Comparing Couchbase Views with Couchbase N1QL & Indexing.

As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more.  It’s logical to ask the comparative question between them.  Here is a table comparing both.  This is...

/ December 4, 2017

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

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

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