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!
▶ More about Postgres Functions: https://supabase.com/blog/2021/07/30/...
Official docs: https://www.postgresql.org/docs/curre...
▶ Supabase Edge Functions: https://supabase.com/blog/2022/03/31/...
Follow Jon on Twitter: ( / jonmeyers_io )
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:
▶ Watch all Supabase & Postgres videos: • Learn Postgres
▶ Support unstructured data in Postgres with JSON columns: • How to store and query JSON data in Postgres
▶ How to build a Saas and make money in 2024: • Fastest way to build a SaaS in 2024 - Next...
👇 Learn more about Supabase 👇
🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: / supabase
▶ Instagram (follow for memes): / supabasecom
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