Categoría: SQL++ / N1QL Query
-
How (and Why) to Use Couchbase as an XML Database
Couchbase and XML – no problem! I’ve heard it said dozens of times: “Hey, Couchbase is great but I use XML.” I recognize that countering with, “Couchbase can be your XML database” is pretty…
-
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…
-
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…
-
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…