This is an Ecto/Oban question.

I have my database on Supabase. Does Oban work with Supabase?

I can connect to the database just like I would with any regular Postgres instance via database url.

In the Oban docs:

Usually, scheduled job management operates in global mode and notifies queues of available jobs via PubSub to minimize database load. However, when PubSub isn’t available, staging switches to a local mode where each queue polls independently.

Local mode is less efficient and will only happen if you’re running in an environment where neither Postgres nor PG notifications work. That situation should be rare and limited to the following conditions:

1. Running with a connection pooler, i.e., pg_bouncer, in transaction mode.
2. Running without clustering, i.e., without Distributed Erlang

If both of those criteria apply and PubSub notifications won’t work, then staging will switch to polling in local mode.

I guess what I’m asking is, does Supabase’s postgres have notifications for Oban to work? Has anyone used Supabase with Oban? Thank you!