Category: SQL++ / N1QL Query
-
How to Harness Real-Time Data Analytics Using Operational Data
Today’s organizations generate data at massive scales and volumes. Applications running on servers in the cloud, data centers and edge devices all produce more data, from more data sources, than ever before. With this…
-
Using libcouchbase / C SDK to run transactions with Couchbase 7.0
Couchbase Server 7.0 now supports N1QL transactions. Let’s try writing a C program that performs a set of transactions on a single node. Step 1: We first decide how to call the program. The…
-
SQL and NoSQL comparison: ASP.NET application
This SQL and NoSQL comparison is the next step after converting your SQL Server database to Couchbase. In the previous post, I copied AdventureWorks from SQL Server to Couchbase. In this post, I’m going…
-
SQL to NoSQL: Automated Migration
SQL to NoSQL migration seems like a contradiction, but thanks to advances and innovations in Couchbase Server’s NoSQL database, it’s becoming easier. In this post, I’ll introduce you to a tool called SqlServerToCouchbase, an…
-
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…
-
NoSQL Is Dead, Long Live NoSQL
Dynamo accelerated the NoSQL revolution that’s driving the database industry. Recently, Amazon announced PartiQL – A SQL-Compatible Query Language for their flagship NoSQL database Amazon DynamoDB. This has brought the NoSQL “re:evolution” full circle. It’s wonderful to…
-
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…
-
FHIR Data Model with Couchbase N1QL
Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation…
-
Couchbase Intro for MongoDB Developers and NoSQL Experts
Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from…
-
Manage Time-To-Live (TTL) Documents with Couchbase N1QL
There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is…
-
A Comparison of 3 NoSQL Query Languages Across 7 Metrics
Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: Some also find the confusion with the NoSQL name. The abbreviation stands for…
-
Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you…