Category: SQL++ / N1QL Query

Storing, Indexing and Searching files with Couchbase and Spring Boot

Storing, Indexing and Searching files with Couchbase and Spring Boot

I have been wanting to showcase most of the new Couchbase’s search features available in 4.5 in one simple project. And there have been some interest recently about storing files or binaries in Couchbase. From a general, generic perspective, databases...

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...

Prepare for This!

Prepare for This!

Get Prepared…. One of the more impressive aspects of using N1QL is the ability to use prepared statements. What are prepared statements? Why use them? What’s the big deal? Consider the following example from the travel-sample bucket and dataset that are bundled...

February 4, 2016
Locating cbq

Locating cbq

cbq is the command-line REPL environment for N1QL and, since version 4.0, it comes along with Couchbase Server. It's a great tool to not only learn N1QL but also to try out and optimise queries before using them in your...

Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 4: Image Uploads with Multer and base64 encoding

Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 4: Image Uploads with Multer and base64 encoding

Part 4: Picture Upload So far, Part 0 and Part 1 cover the data model and user document used in the application followed by Part 2 where we verify accounts through email using Nodemailer and Sendgrid. We then had part...

January 8, 2016
Workaround for N1QL* Queries in the .NET SDK

Workaround for N1QL* Queries in the .NET SDK

This blog was originally posted on David Ostrovsky's personal blog. To see to original blog post, click here.  TL;DR: SELECT myBucket.* FROM myBucket A change in the way N1QL returns results for star queries in Couchbase Server 4.1 seems to have...

N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server

N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server

SQL has been around for a loooooong time. It is very intuitive and efficient way to process structured data and has been the choice for databases for many years. With the world of BIG DATA however, data has velocity, variety...

Hands-on with N1QL in London!

Hands-on with N1QL in London!

We're kicking off the 2016 Couchbase meet-up calendar in London with a hands-on N1QL workshop! Come and join us on January 20th at the Couchbase London office, in Shoreditch, to learn: the fundamentals of N1QL: what you can do and why how N1QL...