Hands-on with UDFs (User Defined Functions) in CockroachDB v23.2

Description

UDFs got a big update in CockroachDB 23.2. We added the ability to perform mutations (INSERT, UPDATE, UPSERT, and DELETE), express functions in PL/pgSQL (code blocks, run loops, and create conditional functions using IF statements). To see what this functionality looks like in the real world, Cockroach Labs Technical Evangelist Rob Reid put together a short demo. Hands-on with UDFs (User Defined Functions) in CockroachDB v23.2 00:00 UDF improvements in CockroachDB 23.2 00:24 How to find your CockroachDB version and create a table 00:55 How to add functions in CockroachDB 01:35 How to create a delete function 02:14 Testing our functions 03:42 How we're making UDFs better in CockroachDB Further reading: - What's new in CockroachDB: https://cockroa.ch/3QCi4QV - What are user-defined functions (UDFs) in SQL, and why should you care? https://cockroa.ch/4b8oejX - Distributed UDFs: How we're building database functions from the ground up: https://cockroa.ch/4bpHXv7 #databaseconcepts #cockroachdb #postgresql #udf