Tag: JSON

Data Structures & Queries with Couchbase N1QL (SQL for JSON)
Data Structures & Queries with Couchbase N1QL (SQL for JSON)

Access JSON NoSQL data with Couchbase data structures: maps, lists, counters, queues using N1QL/SQL queries, indexes and efficient SDK calls.

NoSQL Is Dead, Long Live NoSQL
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 see the collaborative research from UCSD and...

Halloween Problem: Solution in N1QL.
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,...

Text Analysis within a Full-Text Search Engine
Text Analysis within a Full-Text Search Engine

Couchbase’s Full-Text Search (FTS) Engine is powered by Bleve, and this article will showcase text analysis within this engine.

Arrays in JSON: Modeling, Querying and Indexing Performance
Arrays in JSON: Modeling, Querying and Indexing Performance

Find out how Couchbase 6.6 removes limitations on JSON arrays by using a built-in inverted index to be used to index and query arrays in N1QL.

Comparing MongoDB MQL with N1QL features in Couchbase 6.5
Comparing MongoDB MQL with N1QL features in Couchbase 6.5

MongoDB 4.4 added a number of features for the MQL language. We compare them with new features in Couchbase 6.5 including N1QL query and analytic services.

FIRST CLASS SQL for FULL-TEXT SEARCH
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...

Analyze This: MongoDB & Couchbase Analytics.
Analyze This: MongoDB & Couchbase Analytics.

The purpose of computing is insight, not numbers.  — Richard Hamming The spiral of running the business, analyzing what to change & what to change to, and then changing the business is an eternal one. Do the right analysis, your...

FHIR Data Model with Couchbase N1QL
FHIR Data Model with Couchbase N1QL

This post focuses on the FHIR specification as defined by HL7 FHIR. Learn how the Couchbase database can be used to implement FHIR compliant applications.

Couchbase Intro for MongoDB Developers and NoSQL Experts
Couchbase Intro for MongoDB Developers and NoSQL Experts

Many start with MongoDB to learn NoSQL and flexible JSON schema, many choose Couchbase for performance, scale, and SQL. Learn the differences in this post.

Flexible Query & Indexing for Flexible JSON Model.
Flexible Query & Indexing for Flexible JSON Model.

Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...

A Comparison of 3 NoSQL Query Languages Across 7 Metrics
A Comparison of 3 NoSQL Query Languages Across 7 Metrics

See how Couchbase N1QL, MongoDB query, and MySQL/SQL compare across 7 key metrics here. We summarize the findings of Altoros' report on resilient IT.