Create PostgreSQL Functions with Supabase

In this video, Jon Meyers explains how Postgres Functions can help make our application code more maintainable, by abstracting away complex logic into SQL functions.

This can also improve the performance of data fetching, as we can use the database to transform the data into the shape required by the client, rather than sending unnecessary bits across the Internet, and having an API transform and throw away the excess.

We will be putting together a series of videos showing the power of PostgreSQL functions. Make sure you hit that subscribe button to get notified as soon as they are released!

Today, Jon from Supabase is showing us how to leverage PostgreSQL functions to give your application a boost in maintainability and performance.

What you'll learn:

✅ Essentials of PostgreSQL Functions: We'll break down the basic fundamentals of PostgreSQL functions and how they encapsulate complex SQL logic. They basically make your codebase MUCH cleaner and more manageable. (Which is always a good thing).

✅ Enhancing Code Maintainability: See how abstracting complex operations into functions within your database reduces redundancy and simplifies updates across your application.

✅ Boosting Data Fetching Performance: We'll show you how executing data transformations directly in the database can MAJORLY speed up your application by minimizing unnecessary data transfer and processing.

✅ Practical Examples and Implementation: Jon will give you some practical examples that demonstrate creating and using PostgreSQL functions within a Supabase project, so your data integrity is solid.

✅ Advanced Techniques: For the advanced users out there we'll show you how create complex functions that interact with multiple database tables and dynamically handle data based on input parameters.

By the end of this tutorial, you'll know how to implement PostgreSQL functions effectively, making your applications more efficient and your code easier to manage.

Expand Your Dev Skills With Supabase: Stay tuned for related videos, including invoking PostgreSQL functions from client-side JavaScript and automating function execution with PostgreSQL triggers.

💻 Videos to watch next:

👇 Learn more about Supabase 👇

📱 Connect with Us:

ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #RealtimeApps #DeveloperTools

[cesarsfalcao]

First time using PostgreSQL with Supabase with just Excel as prior knowledge, and the AI assistant helped me create the queries and even actions from me! I'm loving it!

[sunstryder]

Fantastic tutorial, didn't expect to be cracking up looking at table rows lool

[ofeenee]

You should do more and more videos of supabase. I enjoy and learn so much of everything you demo. Thank you very much. Really.

[SoniaAcosta-ytqr]

Love that you explained while other videos ive seen show how to set a function up they didnt explain what it actually does or mean. Thank you!

[dramos]

I had no idea postgres could do all of this, awesome video, thank you !

[rydmike]

Great video! Clear and to the point, keep ‘em coming! 👍💙

[shaunregenbaum]

I was looking for something like this just a couple weeks ago! Thanks for the video, would love an even more in depth follow up.

[mysterytriangle]

that was fun informative and right to the point, thanks Jon for your efforts.

[rembautimes]

This video is really good, and I wrote my first plpgl function this afternoon albeit in pgadmin. Helps explain stuff I couldn’t grasp

[Shortly]

Reaaaally great tutorial. Thank you very much!

[salihcagdasderya]

really amazing video you should link this to the docs :)

[drancerd]

It's awesome and powerful! i need a full curse about EdgeFunctions, plpgsql and triggers.

[sonofbuddhaTR]

Colleagues thought I was scrolling memes at work lmao

[ZyncInteractive]

Great tutorial, thanks so much for this. Can you please update the description as you said about calling the functions from javascript?

[hago]

Great tutorials! How would I return the output of a join between two tables?

[albertodeagostini]

This looks super useful combined with triggers and client sdk

[mrrolandlawrence]

amazing stuff. as mostly a dba i really groan when logic is not done in the backend. im guessing that functions are the preferred way of integrating PLPGSQL rather than stored procedures?

[dylanknight]

Is there a way to share the SQL editor queries across a team of people?

[puvididdle]

times have changed, shots fired at rappers by a database tutorial

[zebnastien]

Hi, is there a way to sync Database Functions to files in a local git project so we can seamlessly use our favorite IDE? Let's say having a command for Supabase CLI to retreive functions?