Binh Le | Couchbase Blog

Author

All posts by Binh Le

Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Clould Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.

Traverse Hierarchy with SQL++ User-defined functions (UDFs)

Traverse Hierarchy with SQL++ User-defined functions (UDFs)

User-defined functions (UDFs) are a feature that exist in most RDBMS. Whether it is Oracle PL/SQL (Procedural Language for SQL), SQL Server T-SQL (Transact-SQL), PL/pgSQL (Procedural Language/PostgreSQL), or other variants, all these languages have the general characteristics of providing a...

May 26, 2022
Introducing Charts for Query & Analytics

Introducing Charts for Query & Analytics

Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...

December 9, 2021
5 Steps to Streamline Your N1QL Queries & Migrate to Collections

5 Steps to Streamline Your N1QL Queries & Migrate to Collections

If you’re looking to migrate your data from a relational database to NoSQL, then now’s a better time than ever. The recent release of Couchbase 7.0 introduced Scopes and Collections – a new way to organize your JSON data. More...

August 16, 2021
Here’s How the Index Service Got Upgraded for Couchbase 7.0

Here’s How the Index Service Got Upgraded for Couchbase 7.0

Index builds and updates just got a big performance upgrade with the introduction of Scopes and Collections in Couchbase 7. The Couchbase Server 7.0 release introduces the separation of Bucket data into logical Scopes and Collections on top of the...

August 12, 2021
Boost Query Efficiency with Cost-Based Optimization in Couchbase

Boost Query Efficiency with Cost-Based Optimization in Couchbase

Database users of every kind have come to expect cost-based optimization for their queries. It’s a standard feature of all traditional relational databases (RDBMS), but there hasn’t yet been a cost-based optimizer (CBO) for NoSQL document databases. That is, until...

August 10, 2021
The N1QL Query Language Now Supports Distributed ACID Transactions

The N1QL Query Language Now Supports Distributed ACID Transactions

Multi-document, distributed ACID transactions are now available in Couchbase as part of the N1QL query language. Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to the Couchbase N1QL Query Service...

August 2, 2021
Couchbase’s Cost-Based Optimizer for JSON is patent pending

Couchbase’s Cost-Based Optimizer for JSON is patent pending

With NoSQL databases proving their worth over the legacy SQL approach, the next question is inevitably “how do we optimize our processes as much as possible?” Many databases have used static Rule-Based Optimization (RBO) to optimize workloads – but this...

October 29, 2020
N1QL Turns Five

N1QL Turns Five

As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...

October 6, 2020
Announcing Flex Index With Couchbase

Announcing Flex Index With Couchbase

Flex Index Explained What is a Flex Index? One of the key tasks of a database engine is how to efficiently manage the search and retrieval of the data therein. The efficiency and balance between resource consumption and performance are...

August 12, 2020

Implement FHIR REST server with Couchbase

This is a follow up to my previous post that covered the topic of FHIR Data Model with Couchbase N1QL. In this blog, I will discuss the topic of how to implement the FHIR Search REST API Server over the...

June 8, 2020
FHIR Data Model with Couchbase N1QL

FHIR Data Model with Couchbase N1QL

Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...

April 25, 2020
Manage Time-To-Live (TTL) Documents with Couchbase N1QL

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

There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is very common. NoSQL databases were designed...

April 14, 2020