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.
More Related questions...
