Tag: SQL

Joining JSON: Comparing Couchbase N1QL & MongoDB

As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs to be done and the database...

/ July 11, 2018

A Guide to N1QL features in Couchbase 5.5: Special Edition

N1QL was first released with Couchbase 4.0 in the fall of 2015.  After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...

/ May 10, 2018

Divide and Conquer: Couchbase GSI Index partitioning.

In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes.  Couchbase Global Secondary Index (GSI) abstracts the indexing operations and runs as a distinct service within...

/ April 11, 2018

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Couchbase N1QL is a modern query processing engine designed to provide SQL for JSON on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL supports enhanced SQL...

/ April 3, 2018
Question marks, querying from https://pixabay.com/en/question-mark-important-sign-1872665/

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

/ March 8, 2018
join on array

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

/ February 10, 2018

Couchbase for Oracle developers — Part 3 : Database Objects

Here’s the home page for the series: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ 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...

/ January 27, 2018