Tag: N1QL
It’s SQL. Again.
[crayon-662c40822fbbc877980748/] [crayon-662c40822fbc1413557477/] — In the spirit of Alexander Pope and Sir John Squire.
Keshav Murthy
August 31, 2019
Primary Uses for Couchbase Primary Index
A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a...
Keshav Murthy
August 22, 2019
Index Advisor For Query Workload
Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...
Chang Liu
August 15, 2019
Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The 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 the...
Sachin Smotra, Director Product Management, Couchbase
August 12, 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
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...
Peter Reale
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...
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...