Category: SQL++ / N1QL Query

Couchbase with Windows and .NET – Part 2
Couchbase with Windows and .NET – Part 2

Couchbase with Windows and .NET – Part 2 – Lingo This blog post is part 2 of a series. Part 1 covered how to install and setup Couchbase on Windows. In part 1 – Setup, I showed the very basics...

How to: Create a copy of your bucket with a single statement with Couchbase Server
How to: Create a copy of your bucket with a single statement with Couchbase Server

Batch data manipulation can be super handy for all sorts of operations. Good news is, DML (data manipulation language) in N1QL provides full support for, not just singleton operations, but for powerful bulk/batch data transformation. Here are a few powerful...

Detecting Expirations Before They Happen with Couchbase Server & N1QL
Detecting Expirations Before They Happen with Couchbase Server & N1QL

There are many use cases where auto expiry of documents work perfectly. Maintaining session state, shopping carts, price quotes for travel and more. In all these cases, applications using Couchbase Server, set the expiry time to seconds, minutes or hours...

Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 5: Graphing User Data
Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 5: Graphing User Data

Part 5: Graphing Necessary Materials: Node.js Express Chart.js Node Modules Used: tc-angular-chartjs body-parser moment.js Summary: To maintain a social network, and improve the experience for an end-user, it’s important to keep track of information about these users and their usage...

Native Data Visualization and Reporting with Cloud9Charts and Couchbase with N1QL
Native Data Visualization and Reporting with Cloud9Charts and Couchbase with N1QL

Native Couchbase N1QL Business Intelligence & Reporting This is a guest blog post by Jay Gopalakrishnan, founder of Cloud9 Charts, a Business Intelligence platform for multi-structured data with native NoSQL integrations. N1QL provides unprecedented query capabilities on Couchbase with sort,...

Storing, Indexing and Searching files with Couchbase and Spring Boot
Storing, Indexing and Searching files with Couchbase and Spring Boot

Learn the Spring Boot app that let the user upload files, store them in a binary store, let you search files based on the metadata and text.

Create a Zeppelin Interpreter for Couchbase
Create a Zeppelin Interpreter for Couchbase

I have started playing with Zeppelin recently. It's a great web-based notebook that enables real-time analytics. It supports a variety of backends through the concept of interpreters. Zeppelin Interpreter is the plug-in which enable zeppelin user to use a specific...

Visual Studio Code, the Integrated SQL Editor and N1QL Query Execution
Visual Studio Code, the Integrated SQL Editor and N1QL Query Execution

Couchbase Server 4.5 and GO_CBQ With Couchbase Server 4.5, we are providing a new enhanced commandline query execution tool called “go_cbq”. The new binary comes with capabilities for scripting support, connection management and more. I have been using go_cbq for...

PowerBI & Couchbase Server 4 – Reporting over JSON Data with native connectivity through N1QL REST API
PowerBI & Couchbase Server 4 – Reporting over JSON Data with native connectivity through N1QL REST API

PowerBI and Native JSON Processing PowerBI is one of the great new reporting environments you can use to visualize data. One great advantage of PowerBI is its native JSON support and built-in programmable transformation engine. Power-BI can simply directly talk...

Excel and Couchbase Server v4 with N1QL – No ODBC Required!
Excel and Couchbase Server v4 with N1QL – No ODBC Required!

Microsoft Office 2016 with Excel and Native JSON Processing Microsoft Office and Excel is the de-facto reporting environment for many of us. One great advantage of Excel is its native JSON support and built-in programmable transformation engine. Excel can simply...

Load Nested Models With Ottoman When A Parent Model Is Found In Node.js
Load Nested Models With Ottoman When A Parent Model Is Found In Node.js

Previously I wrote about easily developing Node.js and Couchbase apps using Ottoman for ODM. That post was just a taste of what Ottoman can do and how you can compare it to the things Mongoose can do with MongoDB. This...

Sub-documents: find and change only what you need
Sub-documents: find and change only what you need

What separates a document store from a key-value store? A document database can query and manipulate the contents of what it stores, whereas the value remains an opaque mystery to the key-value store. With Couchbase Server 4.5, we’ve introduced our...