Category: SQL++ / N1QL Query
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,...
Authentication Using Server-Side X.509 Certificates And N1QL
Authentication and authorization to the N1QL query service in Couchbase works in multiple ways – Passing credentials through a rest request – curl http://localhost:8093/query/service?pretty=true -d “statement=select * from system:keyspaces” -u Admin:pwd Passing credentials using the creds named parameter and/or query...
Health Checking a Couchbase Cluster
Most databases are configured and sized correctly based on the information available at the time of their initial launch, but they tend to become unhealthy or undersized due to organic growth of their datasets and/or changes in their workload profiles....
FTS Flex Index vs GSI Indexes in Couchbase Server 6.6
In this article, we will touch on some practical examples starting with N1QL queries using GSI Indexes and simulate a dataset that over time grows not just with document size, but the actual document structure growing as well. Couchbase Server makes flexible...
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...
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...
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)...
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...
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...
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...
FIRST CLASS SQL for FULL-TEXT SEARCH
Over time, the database industry has realized full-text search and SQL are two sides of the same coin. Text search needs further query processing, query processing needs text search to efficiently filter for text patterns. The SQL databases have added...
Fully Configured Couchbase on Red Hat OpenShift in 5 Minutes
I recently did a presentation at Red Hat Users Group – North Texas on Couchbase NoSQL Operator on OpenShift. Thank you to the Red Hat Dallas team for extending the invitation for a joint session – Sam Nicholls, John Gammon, and Nick Wallace. In the...