Category: SQL++ / N1QL Query
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...
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...
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,...
Comparing Postgres JSONB With NoSQL
Learn the different use cases for when to use Postgres 11 with JSONB and when to use a NoSQL database such as Couchbase. Start learning with Couchbase today.
Analytics – Love the Doc Model You’re With
N1QL for Analytics allows for real-time analytics on data without altering the data model. Unnest and join multiple arrays and join with scalar fields.
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...
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...
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....
Android App Using the Query API & Couchbase Lite Database
This tutorial walks you through working with N1QL JSON NoSQL queries on a prebuilt Couchbase Lite database within a simple Android app.
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...
Building a Chatbot with Couchbase, Amazon Lex, and Node.js
Creating a chatbot that can take some of the workload off your human employees by leveraging Amazon Lex for deep learning and conversational interfaces, Couchbase NoSQL as the database, and Node.js for interacting with the database.
The Unreasonable Effectiveness of SQL in NoSQL Databases
Compare and contrast SQL language support in Cassandra, CosmosDB, Couchbase, and MongoDB via their respective implementations.
Top Posts
- Data Modeling Explained: Conceptual, Physical, Logical
- Data Analysis Methods: Qualitative vs. Quantitative Techniques
- What are Embedding Models? An Overview
- Application Development Life Cycle (Phases and Management Models)
- What Is Data Analysis? Types, Methods, and Tools for Research
- What are Vector Embeddings?
- Smarter Search With Graph Queries on Document Data
- High Availability Architecture: Requirements & Best Practice...
- Capella AI Services: Build Enterprise-Grade Agents
