Category: SQL++ / N1QL Query
Build Real-time Dashboards – Couchbase Analytics & Tableau
This blog covers how to set up a Couchbase Analytics cluster in under 5 clicks and create a real-time visualization dashboard with Tableau. Introduction Couchbase Server is a hybrid NoSQL database that supports operational and analytical workloads. Couchbase Analytics in...
N1QL Index Advisor: Improve Query Performance, Productivity
As application developers, your main focus is to design the most efficient queries for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...
Binh Le
May 9, 2019
Approaches to Query Optimization in NoSQL
A man returned home after walking around the globe for eleven years. Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...
Keshav Murthy
May 5, 2019
Search & Rescue: 7 Reasons N1QL Developers Use Search
People don’t want a four key index. They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...
Keshav Murthy
April 22, 2019
The Unreasonable Effectiveness of SQL
Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily. In the years since Don Chamberlin and Ramond...
Keshav Murthy
April 2, 2019
Couchbase in Telecom: MegaFon, Russia
Egor Kovalchuk is a deployment manager in MegaFon, one of the largest telecommunication companies in Russia. His career in telecom spans more than a decade. Egor’s team is in charge of developing, integrating, and monitoring multiple business systems and applications...
Oleg Kuzmin, Sr. Solutions Engineer, Couchbase
March 28, 2019
Couchbase’s N1QL Query Shatters the Limits of MongoDB™
As NoSQL adoption grows, developers and enterprises alike require a general purpose database to replatform their mission-critical applications and services. These databases are no longer used only by backend services that need sub-second access to the data, but also by...
Binh Le
March 25, 2019
Get a Bigger Picture with N1QL Window Functions and CTE
Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...
Binh Le
March 12, 2019
N1QL query with Self Referencing Hierarchy
A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...
Binh Le
February 17, 2019
Developing an Alexa Skill with Golang, AWS Lambda, and Couchbase NoSQL
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...
Laura Czajkowski, Developer Community Manager, Couchbase
January 29, 2019
N1QL: To Query or To Analyze?
Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...
Keshav Murthy
January 24, 2019
Developing AWS Lambda Functions with Golang and Couchbase NoSQL
In this tutorial, we're going to take a look at how to build a function on AWS Lambda that communicates with Couchbase using the Go programming language.
Laura Czajkowski, Developer Community Manager, Couchbase
January 23, 2019