Tag: query
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...
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...
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...
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...
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 –...
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,...
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 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,...
What’s New and Improved in Couchbase Server 6.6
Couchbase Server 6.6 is now generally available with exciting new enhancements that augment our Analytics, Query, Search, and Eventing Services as well as our backup, recovery and tooling capabilities. These enhancements improve developer productivity, simplify cloud deployments, and enable operational...
FTS and N1QL: Improving Performance when Querying Multiple Arrays
Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays. In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...