Results for: java script udf
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....
Marco Greco, Software Architect, Couchbase
November 3, 2022
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...
Marco Greco, Software Architect, Couchbase
October 4, 2022
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...
Marco Greco, Software Architect, Couchbase
September 21, 2022
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...
Marco Greco, Software Architect, Couchbase
August 4, 2022
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...
Marco Greco, Software Architect, Couchbase
July 26, 2022
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...
Marco Greco, Software Architect, Couchbase
July 13, 2022
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...
Binh Le
May 26, 2022
Creating Python and JavaScript User Defined Functions For Geospatial Queries
SQL++ queries can access data stored in your Couchbase cluster in a variety of ways. There are situations where having the business logic as part of your data queries can also be beneficial. SQL++ supports this with User Defined Functions...
Nithish Raghunandanan
April 20, 2022
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...
Dhanya Gowrish, Software Engineer
April 5, 2024
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...
Gaurav Jayaraj - Intern, Couchbase R&D
June 23, 2023
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...
Jeff Morris, VP Product Marketing
May 10, 2022
New RBAC Roles in Couchbase 7.0
Couchbase Server version 7.0 introduces some important changes as part of the role-based access control (RBAC) authorization system. Couchbase Server has allowed fine-grained access controls to the platform with RBAC for administrators since version 4.5 and all users since version...
Ian McCloy, Director Product Management
January 13, 2022