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://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/. This series is written in...
Keshav Murthy
January 22, 2018
Introducing Full Text Search (FTS) in Couchbase Mobile 2.0
Couchbase Mobile 2.0, introduces powerful Full Text Search (FTS) capabilities 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 are familiar with SQL,...
Priya Rajagopal, Senior Director, Product Management
January 17, 2018
Database Pagination: Using OFFSET and Keyset in N1QL
Read the pagination background in my previous article: https://www.couchbase.com/blog/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...
Keshav Murthy
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...
Keshav Murthy
December 4, 2017
Database Indexing Best Practices
Prelude: What is Database Indexing? Asynchronous Indexing: Global Secondary Indexes in databases — Couchbase, for example — can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index-specific...
Venkat Subramanian, Product Manager
November 16, 2017
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...
Keshav Murthy
November 12, 2017
Tooling Improvements in Couchbase Server 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 –...
Matthew Groves
November 8, 2017
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...
Matthew Groves
November 7, 2017
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/...
Keshav Murthy
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...
Matthew Groves
October 31, 2017
N1QL: A Practical Guide. Second Edition
Two years and two weeks ago, on a crisp fall day at Wall Street in New York, we launched N1QL in Couchbase 4.0. Even before the launch, we had customers using pre-release N1QL because it solved the critical business problem:...
Keshav Murthy
October 26, 2017
Using Role-Based Access Control in N1QL
In Couchbase 4.5, data was secured bucket by bucket. Each bucket had a password, and in order to access a bucket through a N1QL query, the user had to include the bucket password with the query. Passwordless buckets were possible,...
Johan Larson
October 23, 2017