Tag: N1QL

N1QL

Index Advisor Service for Couchbase N1QL(Feb refresh)

This is our Feb drop for Index Advisor service after fixing some of the bugs that were found. We plan to keep improvising the Index Advisor service(What is it?). The fixes in Index Advisor that you would normally see in...

/ February 12, 2020

Couchbase 6.5 – RMS for Indexing Service

Couchbase 6.5 release includes an extensive list of Enterprise Grade Database Query capability that allows customers to expand the adoption of NoSQL database into traditional database applications. The release has added transactional capability, Analytical Window functions, user defined JS functions,...

/ January 20, 2020

Simple dataviz with N1QL and Google Sheets.

Do whatever it takes to present the data to aid analysis and thinking.  — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...

/ January 7, 2020

Index Advisor Service for Couchbase N1QL(SQL for JSON)

We are excited to announce the release of : Couchbase Index Advisor Service http://index-advisor.couchbase.com Yet Another service? Why? We released N1QL(SQL for JSON) a few years ago- so that you could use SQL to retrieve and manipulate JSON data. But...

/ December 26, 2019

Testing N1QL workloads with Apache JMeter

One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...

Introducing FTS with N1QL

Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...

Deep Dive: Window functions in Couchbase Analytics

Couchbase Server 6.5 brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and provide...

Infosys Completes “OpenHack” Solution Development Program with Couchbase

Couchbase is expanding its partnerships with industry-leading global systems integrators and regional solution providers.  Through these partnerships, Couchbase’s unique capabilities can be delivered to our global footprint of enterprise customers. We collaborate closely with our Strategic Alliance partner Infosys to...

Less is More: Why Cost Based Optimizer?

Less is more.  — Ludwig Mies van der Rohe This is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for...

/ September 7, 2019

Analytics Explain Plan – Part 1

Co-author:  Till Westmann,  Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...