Scheduling Edge Functions

The hosted Supabase Platform supports the pg_cron extension[0], a simple cron-based job scheduler for PostgreSQL that runs inside the database. In combination with the pg_net extension[1], this allows us to invoke functions periodically on a set schedule. Find the docs: https://supabase.com/docs/guides/functions/schedule-functions 🎙️ Presented by Thor Schaeff (@thorwebdev https://go.thor.bio/x) ## Chapters 00:00 Scheduling Functions Intro 00:28 Create a new Edge Function 01:09 Deploy Edge Function 01:47 Invoke Edge Function with SQL using Postgres pg_net extension 04:19 Schedule Edge Function with SQL using Postgres pg_cron extension 05:24 Figure out cron schedule with crontab.guru 07:19 Inspect the pg_cron schema in the Supabase Dashboard 08:34 Inspect Edge Function logs in the Supabase Dashboard 09:26 Unschedule a cron job ## About Edgy Edge Functions Edgy Edge Functions is a video series where we explore Supabase Edge Functions[2] and Deno[3] functionality and features. If there's something you'd like to learn about, please open an issue[4] and let me know on this Tweet thread[5]. Thanks for stopping by! Denosaur and I will see you soon \o/ [0] https://supabase.com/docs/guides/database/extensions/pgcron [1] https://supabase.com/docs/guides/database/extensions/pgnet [2] https://supabase.com/edge-functions [3] https://deno.land/ [4] https://github.com/thorwebdev/edgy-edge-functions/issues/new/choose [5] https://twitter.com/thorwebdev/status/1595719098863788032