Tag: SQL

New Querying Features in Couchbase Server 5.5

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

March 9, 2018
Announcing Couchbase Server 5.5 – Developer Build

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
Introducing JOIN Queries in Couchbase Mobile

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

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

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

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

January 27, 2018
Couchbase for Oracle Developers – Part 2 : Architecture

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

January 22, 2018
Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Mobile 2.0, introduces powerful Full Text Search (FTS) capabilities on 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,...

Database Pagination: Using OFFSET and Keyset in N1QL

Database Pagination: Using OFFSET and Keyset in N1QL

Read the pagination background in my previous article: https://www.couchbase.com/blog/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand.  Using OFFSET and LIMIT is the easy way to write...

January 11, 2018
How to Query Array Collections in Couchbase Lite

How to Query Array Collections in Couchbase Lite

One of the major features introduced in Couchbase Lite 2.0, is the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL, you will feel right at home with...

Comparing Couchbase Views with Couchbase N1QL & Indexing.

Comparing Couchbase Views with Couchbase N1QL & Indexing.

As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more.  It’s logical to ask the comparative question between them.  Here is a table comparing both.  This is...

December 4, 2017
Introducing the Query Interface in Couchbase Mobile 2.0

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, brings a plethora of new features and enhancements. We discussed one such enhancement, namely the new replication protocol between in an earlier blog post on Replication 2.0. In this blog post, we will introduce you...