Tag: N1QL

Window functions in Couchbase Analytics

Co-author:  Till Westmann,  Senior Director, Engineering The beta bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in...

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

Analytics – Love the Doc Model You’re With

In business applications, the data is often modeled for a large number of concurrent low latency queries. If you want to gain insight by looking at trends, however, you end up wishing you had an entirely different data model. The...

/ July 26, 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...

/ July 9, 2019

A Preview of Couchbase 6.5 N1QL Features

Couchbase 6.5 release is going to be 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...

/ June 22, 2019
Lentiqx CB Blog Banner

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

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

/ June 8, 2019
AmazonxCB Blog Banner

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: A Comparative Study.

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

/ May 26, 2019