Michael Stonebraker, the Postgres inventor and Turing Award winner, is now leading the three-year DBOS project with Stanford and MIT. The team has developed a Durable Workflow engine using Postgres that stands out for its lightweight and fast design. DBOS offers a unique approach by storing workflow state in your own Postgres database, ensuring exactly-once execution and idempotency. The system stores function outputs in Postgres, allowing for easy recovery in case of interruptions. DBOS boasts faster performance compared to other workflow engines like AWS Step Functions. Overall, DBOS leverages the power of Postgres to simplify and enhance workflow automation.
https://supabase.com/blog/durable-workflows-in-postgres-dbos