Category: SQL++ / N1QL Query
What is SQL? Navigating Databases for DBAs and Developers
This article briefly introduces the essentials of SQL – its meaning, definition, and application to different database technologies. We introduce many different types of systems that use SQL – from databases to event stream processing. What is SQL? Define: SQL...
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 open-source attempt at an automated tool...
Use cases and Best Practices for Distributed Transactions through N1QL
Does Couchbase support transactions? Yes! With 6.5, we introduced the ACID transaction support in Couchbase through the SDKs. The 1st question we got at the time from the customers that heard about it was: Is transaction support available through N1QL?...
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)
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 JSON. Developers can focus on managing...
Index Advisor Supports Self-Verification and Index Pushdowns
Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...
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
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
Couchbase Server 7 Beta Couchbase Server 7 Beta is a very exciting release. It is available, free in both Enterprise and Community Editions. We encourage our entire community to download and try this groundbreaking release that features scopes and collections...
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 editor – Opening transposed tables –...
Taming the Gerrymander with Geospatial Search
The Basics Before you read any further, please take a few minutes and read the excellent post on geospatial search in Couchbase, as published by my friend and colleague Brian Kane: https://www.couchbase.com/blog/geospatial-search-how-do-i-use-thee-let-me-count-the-ways/ Go ahead; I’ll wait. Now that you’re back,...
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,...