Tag: query
A Tool to Ease Your Transition From Oracle PL/SQL to Couchbase JavaScript UDF
What is PL/SQL? PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. It includes procedural language elements such as conditions and loops, and can handle exceptions (run-time errors). PL/SQL is native to Oracle databases, and...
Introducing Charts for Query & Analytics
Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...
The life of a Full Text Search query
This technical article showcases the life of a Full Text Search query through a distributed Couchbase system as it originates from a client to until a response is received. Before diving into the server world, a little about the client...
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...
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...
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 –...
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,...
Couchbase Views and Better Alternatives [Part 1 of 2]
Introduction This blog is meant for users who are familiar with the basics of Couchbase Server and Views. Novice users should start here to gain basic understanding of Couchbase Server and then continue here to get acquainted with Views. Views...
N1QL Turns Five
As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...
What’s New and Improved in Couchbase Server 6.6
Couchbase Server 6.6 is now generally available with exciting new enhancements that augment our Analytics, Query, Search, and Eventing Services as well as our backup, recovery and tooling capabilities. These enhancements improve developer productivity, simplify cloud deployments, and enable operational...
Remote Links: Analyze Trends with Couchbase Analytics
Introduction to remote links Couchbase is excited to announce its new Remote Links Analytics Service feature in the latest Couchbase Server 6.6 release. Remote links enable real-time operational analytics to obtain and analyze data from multiple Couchbase data clusters and...