Tag: N1QL

Woman riding a horse in a barrel race as a metaphor for navigating SQL data challenges

What is SQL? Navigating Databases for DBAs and Developers

This article briefly introduces the essentials of SQL – its meaning, definition, and application to different database technologies. We introduce many different types of systems that use SQL – from databases to event stream processing. What is SQL?  Define: SQL...

April 7, 2021

Use cases and Best Practices for Distributed Transactions through N1QL

Does Couchbase support transactions? Yes! With 6.5, we introduced the ACID transaction support in Couchbase through the SDKs. The 1st question we got at the time from the customers that heard about it was: Is transaction support available through N1QL?...

February 24, 2021

Enable AI-driven insights using Couchbase: a practical framework

Chris Galy, Chief People Officer at Couchbase, explained in an article you can find with a quick Google search that our mission is about channeling our passion to solve hard problems so our customers can innovate and change the world....

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...

January 27, 2021

Index Advisor Supports Self-Verification and Index Pushdowns

Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...

January 19, 2021

N1QL User Defined Functions

Introduction Couchbase Server 6.5 introduced User Defined Functions as a Developer Preview feature. N1QL is primarily a declarative language – where you ask what to get, and the language works out for you the actual method. While declarative languages have...

New in Couchbase Server 7.0: N1QL per request memory quota

Introduction Unlike other services, the N1QL service so far hasn’t offered the ability to size its memory footprint. The principal reason for this disparity boils down to one simple fact: while the bulk of the memory consumption for services like...

Cost Based Optimization with Couchbase JSON database

Couchbase Query Cost Based Optimization (CBO) was released as a Developer Preview in Couchbase 6.5, and it is now ready for GA with Couchbase v7.0. While CBO is a ubiquitous feature with traditional RDBMS, and that users have come to...

November 30, 2020

Simplifying Query & Index with Collections

Couchbase Collections available with the upcoming version 7 brings Couchbase JSON database closer to that of other RDBMS. Collections will make it easier for customers who are looking to migrate their current RDBMS data model to Couchbase document model. This...

November 25, 2020
Collections RBAC Security

Introducing RBAC Security for Collections

Couchbase Server 7.0 introduces the Role Based Access Control (RBAC) for Collections and Scopes.

Introducing Couchbase 7 Beta, Mapping RDBMS to NoSQL

Couchbase Server 7 Beta Couchbase Server 7 Beta is a very exciting release. It is available, free in both Enterprise and Community Editions. We encourage our entire community to download and try this groundbreaking release that features scopes and collections...

Transactions-in-N1QL

Couchbase Transactions with N1QL

Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to Couchbase N1QL Query in the upcoming release 7. A quick recap –  Couchbase provides support for multi-document ACID transactions for its...

November 17, 2020