Workflows are coming to Supabase

Summary

Supabase is developing Workflows, an Elixir-based orchestration engine designed to coordinate complex serverless tasks and event-driven logic. Standard serverless and database-triggered functions often struggle with delayed execution and queuing without external cron processes. To solve this with native Postgres integration, the new engine adopts the open-source Amazon States Language specification to orchestrate functions across platforms including AWS, GCP, Azure, OpenFaaS, and Postgres itself. Execution states, jobs, queues, and logs are deeply integrated with Postgres using the Oban job processing library, though transient in-memory workers are also supported. The engine responds directly to HTTP calls or database change events delivered through Supabase Realtime.

Takeaways

1. 1

   Supabase Workflows uses the open-source Amazon States Language to define state transitions and coordinate functions across external providers and Postgres without running code itself.

2. 2

   Workflows support both default persistent mode, which relies on Postgres and Oban to survive server restarts, and transient mode for high-frequency in-memory execution.

3. 3

   Workflows can be triggered by direct HTTP calls or database events like inserts, allowing state constructs like Map and Choice to process batch event payloads.