Tag: N1QL

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

/ November 17, 2020
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

DataGrip Setup for Couchbase

DataGrip from JetBrains has added NoSQL Couchbase support. It was first made available in their 2020.3 EAP (Early Access Preview) DataGrip 2020.3 EAP is Open! – Couchbase support – Grants – More powerful value editor – Opening transposed tables –...

/ November 11, 2020

Halloween Problem: Solution in N1QL.

Learning SQL is easy; Implementing SQL, not so much. Halloween has come and gone. But, the tricks of the Halloween problem is here to stay! This has to be solved by databases every day.  SQL made the relational database easy,...

/ November 3, 2020

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

Couchbase Views and better alternatives part 1 of 2

Introduction This blog is meant for users who are familiar with the basics of Couchbase Server and Views. Novice users should start here to gain basic understanding of Couchbase Server and then continue here to get acquainted with Views. Views...

N1QL Transactions : Elastic, Scalable, and Distributed

SQL is the only 22nd-century language available for developers today. ABSTRACT In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics.  SQL as a query...

/ October 14, 2020

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
Flex Index is Amazing

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
A graphic showing remote cluster nodes for the Couchbase analytics service

Remote Links – Analyze Trends With Couchbase Analytics

Introduction to remote links Couchbase is excited to announce its new Remote Links Analytics Service feature in the latest Couchbase Server 6.6 release. Remote links enable real-time operational analytics to obtain and analyze data from multiple Couchbase data clusters and...

/ August 12, 2020