Automate with PostgreSQL Triggers & Supabase 🤖

For the introductory video on PostgreSQL functions, check out 👉 https://www.youtube.com/watch?v=MJZCCpCYEqk

Functions in Postgres allow us to encapsulate some logic in our database, but we don't want to have to call these functions manually, whenever data in our database changes. In order to automate this, we can use Postgres Triggers.

Triggers in PostgreSQL allow us to subscribe to particular events that occur in the database - insert, update or delete - and call a Postgres function whenever they occur. This allows us to automate some of those manual processes - such as creating a row in our profiles table for each user who signs in.

In this video, Jon Meyers (https://twitter.com/jonmeyers_io) explains how we can model our database schema by creating a profiles table to hold additional data about our user. We can then create a trigger that listens for insert events on the auth.users table and automatically creates a profile for them.

This is part of a series of videos about functions in PostgreSQL, check out the rest of the playlist to learn more: https://www.youtube.com/playlist?list=PL5S4mPUpp4OtkMYxAxNpEuuDQuI2pWF3-

👮‍♀️ Learn about Row Level Security: https://www.youtube.com/watch?v=Ow_Uzedfohk

💰 Get really good at Supabase and build a SaaS product (free course): https://egghead.io/courses/build-a-saas-product-with-next-js-supabase-and-stripe-61f2bc20

---
Learn more about Supabase 👇

🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🐙 Github: https://github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: https://twitter.com/supabase/

Jon Meyers 👇
🕸 Website: https://jonmeyers.io/
🎥 YouTube Channel: https://www.youtube.com/c/jonmeyers
🐦 Twitter: https://twitter.com/jonmeyers_io

---