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...
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 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...
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....
Tutorial : Using the Query API with a Prebuilt Couchbase Lite Database in an Android App
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...
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
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....