Category: SQL++ / N1QL Query

What is SQL? Navigating Databases for DBAs and Developers
What is SQL? Navigating Databases for DBAs and Developers

SQL is pervasive in data solutions today. What does SQL mean? What kinds of programming applications use it? ✓ This post answers those questions and more.

SQL to NoSQL: Automated Migration
SQL to NoSQL: Automated Migration

SQL to NoSQL migration can be at least partially automated. This article helps you find out about the new conversion features available in Couchbase Server 7.

Use cases and Best Practices for Distributed Transactions through N1QL
Use cases and Best Practices for Distributed Transactions through N1QL

Typical use cases and Best Practices for using the newly introduced distributed transactions through N1QL in Couhbase!What to do and what to avoid doing!?

Enable AI-driven Insights Using Couchbase: A Practical Framework
Enable AI-driven Insights Using Couchbase: A Practical Framework

Chris Galy, Chief People Officer at Couchbase, explained in an article you can find with a quick Google search that our mission is about channeling our passion to solve hard problems so our customers can innovate and change the world....

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.

Index Advisor Supports Self-Verification and Index Pushdowns
Index Advisor Supports Self-Verification and Index Pushdowns

N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.

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...

Query Admission Control in Couchbase Analytics
Query Admission Control in Couchbase Analytics

Couchbase Analytics is optimized to perform ad-hoc analytical queries, which typically process more data than one can fit in memory. It employs a massively parallel processing (MPP) engine that attempts to fully utilize the available processing power in any given...

Introducing Couchbase 7 Beta, Mapping RDBMS to NoSQL
Introducing Couchbase 7 Beta, Mapping RDBMS to NoSQL

Couchbase Server 7 Beta is available in both Enterprise & Community Editions. Download today to try out RDBMS-friendly Scopes and Collections, and more!

DataGrip Setup for Couchbase
DataGrip Setup for Couchbase

What is DataGrip? This blog post introduces JetBrains DataGrip and shows you how to get started using its NoSQL capabilities with Couchbase support.

Taming the Gerrymander with Geospatial Search
Taming the Gerrymander with Geospatial Search

Combining Couchbase geospatial search with N1QL queries will allow you to conquer complex geographical boundaries.

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,...