Tag: UDF
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...
Improved Debuggability for SQL++ User-Defined Functions
User-defined functions (UDFs) are a very useful feature supported in SQL++. Couchbase 7.6 introduces improvements that allow for more debuggability and visibility into UDF execution. This blog will explore two new features in Couchbase 7.6 in the world of UDFs. Profiling...
Recursive Query Processing in SQL++ (N1QL)
It is extremely likely that you have come across issues with hierarchical lookups or graph traversal in your application as a developer who handles real-world use cases. And, for obvious reasons, you prefer solving them at the database layer and...
From N1QL to JavaScript and Back – Part 7: Hierarchical JavaScript Storage
In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data, handling errors, prepared statements and other advanced topics. The final topic to cover is a newly added feature to 7.1 that enables JavaScript library storage options....
From N1QL to JavaScript and Back – Part 6: Advanced Topics
In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data, handling errors, and using prepared statements. We have a few more advanced topics to cover before we move onto manipulating JavaScript libraries, such as calling other...
From N1QL to JavaScript and Back – Part 5: Prepared statements
In previous blogs, we covered executing N1QL (SQL++) from JavaScript functions, processing documents through iterators, manipulating data. and handling errors. We now move to executing dynamic statements. Prepared statements JavaScript functions can prepare and execute prepared statements, much like any request...
From N1QL to JavaScript and back – Part 4: Error Handling
In previous blogs, we have covered executing N1QL from JavaScript functions, processing documents through iterators, and manipulating data. We now move onto handling errors from N1QL statements. Error handling When an error of any nature is encountered, the jsevaluator by...
From N1QL to JavaScript and Back – Part 3: Iterating over Documents and DML
This earlier blog goes through the basics of executing N1QL statements inside JavaScript functions. We now move onto… Iterators/Processing values So far we have purposely avoided statements that return data, and returning data from the function. This is where we...
From N1QL to JavaScript and Back – Part 2: Basic Usage
The previous blog introduced to you new features in JavaScript user-defined functions. We are now going to explore them in more detail. We start with a basic mechanism to execute N1QL statements inside JavaScript code. N1QL in JavaScript There are...
From N1QL to Javascript and Back – Part 1: Introduction
Among the many great features introduced in Couchbase Server 7.0, one has the potential for a greater impact in later releases: N1QL User Defined Functions. A quick glance at the past N1QL is a declarative language, meaning that requests merely...
Traverse Hierarchy with SQL++ User-defined functions (UDFs)
User-defined functions (UDFs) are a feature that exist in most RDBMS. Whether it is Oracle PL/SQL (Procedural Language for SQL), SQL Server T-SQL (Transact-SQL), PL/pgSQL (Procedural Language/PostgreSQL), or other variants, all these languages have the general characteristics of providing a...
What’s New In Couchbase Server 7.1
Can a Database Fight Inflation? Introducing Couchbase Server 7.1 This year, I’ve asked myself, how can a database help fight inflation? The answer is to make efficiency improvements in the database that outpace inflation. For as long as I’ve worked...