Category: SQL++ / N1QL Query
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 20, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 11, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 11, 2016
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...
Nic Raboy, Developer Advocate, Couchbase
February 25, 2016
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...
Matthew Revell, Lead Developer Advocate, EMEA, Couchbase
February 24, 2016
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...
Todd Greenstein
February 4, 2016
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...
Matthew Revell, Lead Developer Advocate, EMEA, Couchbase
January 26, 2016
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...
Pranav Mayuram
January 8, 2016
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...
David Ostrovsky, Senior Solutions Architect, Couchbase
January 7, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
January 5, 2016
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...
Matthew Revell, Lead Developer Advocate, EMEA, Couchbase
January 4, 2016
N1QL Samples
Learn N1QL by sample N1QL is the document query language used to query data in Couchbase Server (CB). N1QL will be an integrated part of CB 4, until then there is a preview version available. SQL for JSON Documents N1QL...
Martin Esmann, Developer Advocate, Couchbase
December 17, 2015