CockroachDB Videos
← Back to all videos

Demo: basics of user-defined functions (UDFs) in CockroachDB

2022-12-06

Uncategorized

Description

In this demo of user-defined functions (UDFs) you'll learn what they are and how they work in CockroachDB. An important distinction here is that CockroachDB is building "distributed" user-defined functions from the ground up so that the UDFs you're familiar with will work as expected in a distributed environment. To learn more about distributed UDFs check out the blog: https://www.cockroachlabs.com/blog/distributed-functions-udfs-cockroachdb/ The Github page for the function written by Saqib Ali that's featured in this video can be found here: https://github.com/saqib-ali/humanize_time_span/blob/main/humanize_time_span.sql 0:00 Intro 0:08 What are UDFs? 0:26 Breaking down a simple UDF in CockroachDB 1:48 Real-world CockroachDB UDF example 2:18 Introducing distributed functions #CockroachDB #distributedsql For more information on this and other new features in CockroachDB 22.2: https://www.cockroachlabs.com/22-2-launch/