SQL++ / N1QL Query Archives

Couchbase Data Platform Partner Training

Thanks to Binh Le, Jon Strabala & Keshav Murthy for contributing to this post. Introduction Couchbase provides a wide variety of self paced online courses as well as in-person (or virtual) training through both Couchbase’s training portal. Advent of open...

Tools & SDKs

Announcing Spring Data Couchbase 4.0

Spring Data Couchbase 4.0 a completely new perspective

SQL++ / N1QL Query

FHIR Data Model with Couchbase N1QL

This post focuses on the FHIR specification as defined by HL7 FHIR. Learn how the Couchbase database can be used to implement FHIR compliant applications.

Best Practices and Tutorials

Couchbase Intro for MongoDB Developers and NoSQL Experts

Many start with MongoDB to learn NoSQL and flexible JSON schema, many choose Couchbase for performance, scale, and SQL. Learn the differences in this post.

SQL++ / N1QL Query

Manage Time-To-Live (TTL) Documents with Couchbase N1QL

For Couchbase, the support of Time-to-Live TTL has always been available with Couchbase Key-Value Operations. Find out how to manage documents with N1QL.

SQL++ / N1QL Query

Flexible Query & Indexing for Flexible JSON Model.

Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...

SQL++ / N1QL Query

Index Advisor Service for N1QL (March refresh)

This is our March drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in Feb. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

Full-Text Search

FTS and N1QL: Better MongoDB in Operator Performance Querying Multiple Arrays

Learn the advantage of using FTS over GSI for array indexing with an example that requires querying multiple arrays with MongoDB in operator performance.

Data Modeling

Couchbase for Oracle Developers – Part 4 : Data types

Link to the series home page: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...