Category: SQL++ / N1QL Query
Advanced Filtering with XDCR 6.5
Customers use XDCR for various use cases from high availability to data locality to disaster recovery to cloud migration and hybrid cloud deployments. To meet these use cases, there are a number of circumstances where they would want to replicate...
Chaitra Ramarao, Sr. Product Manager, Couchbase Inc.
August 9, 2019
Index Advisor for N1QL Query Statement
Overview Index advisor is introduced in Couchbase server 6.5 as a developer preview feature. It targets at providing secondary index recommendation to help DBAs and developers optimize N1QL query performance. This version is rule-based, in which the index candidates will...
Chang Liu
August 9, 2019
Couchbase 6.5 – Scan Consistency in Analytics
Since the GA back in Nov 2018, Couchbase Analytics is being used in multiple verticals for rapid time to insight – ad-hoc analysis by a payment provider, shopping cart analysis by an e-tailer, next gen ticket booking engine by a...
Sachin Smotra, Director Product Management, Couchbase
August 9, 2019
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,...
Keshav Murthy
August 7, 2019
Comparing Postgres JSONB With NoSQL
The reality is that databases are converging, and in the last few years, it is becoming even more difficult to point what are the best scenarios for each datastore without a deep understanding of how things work under the hood. ...
Denis Rosa, Developer Advocate, Couchbase
August 6, 2019
How to use N1QL to migrate Oracle data into Couchbase
Getting the Couchbase server to run on your PC or Mac involves a few simple steps to download the software and spin up a cluster with all the Couchbase services that you need (https://docs.couchbase.com/server/6.0/getting-started/start-here.html). Sample buckets are available with the...
Binh Le
July 9, 2019
A Preview of Couchbase 6.5 N1QL Features
Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application...
Binh Le
June 22, 2019
Lentiq and Couchbase
Alex Sirbu R&D Team Lead at Lentiq, has seven years’ experience in architecting and building reliable distributed systems. Lentiq is a Kubernetes-based, multi-cloud data lake-as-a-service startup, meaning we manage other people’s data and workflows on a daily basis for a living....
Laura Czajkowski, Developer Community Manager, Couchbase
June 19, 2019
Android App Using the Query API & Couchbase Lite Database
Couchbase Lite 2.x is a powerful NoSQL embedded data store for iOS, Android and .Net Mobile Platforms. In an earlier tutorial, we explored the basics of Database and Document CRUD operations using Couchbase Lite within your Android apps. In addition...
Rob Hedgpeth, Senior Developer Advocate, Couchbase
June 18, 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...
Keshav Murthy
June 8, 2019
Building a Chatbot with Couchbase, Amazon Lex, and Node.js
Nic Raboy is an advocate of modern web and mobile development technologies. He has experience in Java, JavaScript, Golang, and a variety of frameworks such as Angular, NativeScript, and Apache Cordova. Nic writes about his development experiences related to making web and mobile...
The Unreasonable Effectiveness of SQL in NoSQL Databases
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. On...
Keshav Murthy
May 26, 2019