Inserts created via cron don't fire trigger

I'm running into an intermittent problem (the worst!). I have:

  • A cron job that adds rows to a queue table daily
  • A "database webhook" that listens for insert on that table, and sends an HTTP POST to a Lambda function
I used the Supabase UI to create that webhook, because I haven't figured out how to do so via a database migration. It works fine when adding a row manually to the table. It has worked at times, but then stopped working.

This is a project that I've been working on intermittently, and it currently uses a free Supabase project. Is it possible that Supabase is making the project dormant after a certain amount of inactivity? E.g., the webhook fired on 12/23 and on 12/29, but not since then.
Was this page helpful?