Category: SQL++ / N1QL Query

Configuring Analytics in Couchbase Server 5.5
Couchbase Analytics Developer Preview 4 brought the ability to manage Analytics nodes from the Couchbase Server administration console. With the release of Couchbase Server 5.5, we’ve unified the installation experience as well. To illustrate the seamless installation, I’ll take you...

Using Couchbase Analytics for Complex and Efficient Queries in a Java Application
Note: This post has been updated to reflect the production version of the Couchbase Analytics Data Definition Language. Not too long ago I had written about using Couchbase’s new Analytics service, sometimes referred to as CBAS, within a Node.js application....

New Querying Features in Couchbase Server 5.5
New querying features figure prominently in the latest release of Couchbase Server 5.5. Check out the announcement and download the release for free right now. In this post, I want to highlight a few of the new features and show...

Announcing Couchbase Server 5.5 – Developer Build
Announcing Couchbase Server 5.5 Developer Build It is my pleasure to share this early preview of Couchbase Server 5.5 features – there are some very exciting improvements coming and this Developer Build (DB) highlights several of them. There are many...

ANSI JOIN Support in N1QL
Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key from one side of the join...

Working with JSON Arrays in N1QL
The N1QL query language has a rich set of facilities for working with JSON arrays. In this article, we’ll cover array constants, facilities for searching in arrays, ways to transform arrays, and some useful N1QL array functions. The format is...

Machine Learning with Couchbase and Nexosis
Machine Learning is a tool that is helping developers and data scientists to accomplish all sorts of tasks: Classification – organize and tag data Regression – find relationships between data points Forecasting – use current data to predict the future...

Introducing JOIN Queries in Couchbase Mobile
Couchbase Lite 2.0 supports the ability to perform JOINS across your JSON documents . This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL,...

Announcing Couchbase Mobile 2.0 Beta
I am happy to announce that Couchbase Mobile 2.0 beta is now available for download here. Couchbase Mobile 2.0 Couchbase Mobile 2.0 is a ground breaking release with really exciting new features Improved Couchbase Lite Simplified API with built in...

Using Google Artificial Intelligence Services in Couchbase N1QL
“If you’re not using deep learning, you should be.” – Jeff Dean, Google Fellow. Google has started out with a mission to empower everything and everyone with Artificial Intelligence (A.I.). It has open-sourced Tensorflow and supporting libraries to enable developers...

Couchbase for Oracle developers — Part 3 : Database Objects
Here’s the home page for the series: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ Oracle DBAs work with clusters, machines, storage systems, disks, etc. Oracle developers and their applications work with databases, tables, rows, columns, partitions, users, data types within the Oracle database system. Let’s compare and...

Couchbase for Oracle Developers – Part 2 : Architecture
Back in November, Raju Suravarjjala, (Sr. Director, Couchbase QE & Performance) and I presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/. This series is written in...