Tag: N1QL
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 –...
Matthew Groves
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,...
Keshav Murthy
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...
Binh Le
October 29, 2020
![Couchbase Views and Better Alternatives [Part 1 of 2]](https://www.couchbase.com/blog/wp-content/uploads/2022/11/couchbase-nosql-dbaas-800x280.png)
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...
Nirvair Singh, Solutions Architect, Couchbase
October 19, 2020
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...
Keshav Murthy
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,...
Binh Le
October 6, 2020
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...
Binh Le
August 12, 2020
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...
Till Westmann
August 12, 2020
External Datasets: Accessing AWS S3 in Couchbase Analytics
Introduction to external datasets Couchbase is very excited to announce its new “External Datasets” Analytics Services feature in the latest Couchbase Server 6.6 release. External datasets empower customers to access externally stored data in real-time from Amazon Web Services (AWS)...
Idris Motiwala
August 12, 2020
Arrays in JSON: Modeling, Querying and Indexing Performance
Array is THE difference between the relational model and the JSON model. — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements, number of elements, size of the elements, and the depth of the elements. This...
Keshav Murthy
August 4, 2020
Comparing MongoDB MQL with N1QL features in Couchbase 6.5
This is a short note reviewing the MongoDB MQL language features highlighted in the release blog: MongoDB 4.4: User-Driven Engineering. Ready for You. MongoDB 4.4 release has added a number of features for the MQL language. Couchbase released 6.5 earlier...
Keshav Murthy
July 31, 2020
Migrating Data from MongoDB to Couchbase, Part 2
Prolog The previous article provided details on how to migrate a MongoDB data set to Couchbase Server. This article shows you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show how...
Douglas Bonser, Principal Solution Engineer, Couchbase
July 30, 2020