Home / Companies / Couchbase / Blog / Post Details
Content Deep Dive

Improved Debuggability for SQL++ User-Defined Functions

Blog post from Couchbase

Post Details
Company
Date Published
Author
Dhanya Gowrish, Software Engineer
Word Count
3,057
Company Posts That Month
13
Language
English
Hacker News Points
-
Post removed?
No
Summary

Couchbase 7.6 introduces two new features that improve debuggability and visibility into User-Defined Function (UDF) execution: Profiling for SQL++ statements executed in JavaScript UDFs, and EXPLAIN FUNCTION to access query plans of SQL++ statements within UDFs. The profiling feature collects detailed execution tree information with timing and metrics for each step of the statement's execution. EXPLAIN FUNCTION allows users to analyze the query plan of a specific SQL++ statement within a UDF without having to individually run an EXPLAIN on each statement. This new feature is particularly useful for debugging complex queries involving nested UDFs or aliased N1QL functions.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.