Database / Supabase basics Interview Questions
What happens when a Postgres trigger fires on a table linked to Edge Function webhooks?
A database webhook is really just a trigger wired to fire on INSERT, UPDATE, or DELETE for a specific table; when the triggering statement commits, Postgres sends an HTTP POST containing the changed row's data (and, for updates, the previous values) to a configured URL, commonly an Edge Function endpoint.
The Edge Function then runs independently of the original database transaction — it receives the payload, executes its own logic (like charging a card or sending a notification email), and its outcome doesn't roll back the original insert even if the function itself fails. Because of that, the pattern is best suited to side effects that are acceptable to retry or handle asynchronously, and teams often add their own retry or dead-letter handling in the function rather than assuming delivery is guaranteed.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
