Remix.run Logo
jumski 4 days ago

I'm building pgflow, a Postgres-native workflow orchestration engine that keeps the entire DAG's state and orchestration logic inside the database, while a dedicated task queue worker (Edge Worker) handles execution.

This split minimizes external dependencies and makes it easy to manage complex pipelines without leaving PostgreSQL.

I started pgflow because I wanted a fully integrated, Supabase-based system (no separate servers!) for reliable, parallel workflows which keep state in postgres so I can trigger flows from triggers and stream their progress via Supabase Realtime.

Started protytyping it in early November, released serverless task queue worker in January and I'm currently polishing the flow orchestrator pieces, releasing an alpha version in upcoming weeks.

If you're curious:

- More on Twitter/X: @pgflow_dev (https://x.com/pgflow_dev)

- Edge Worker docs (will get flow orchestration docs included soon): https://pgflow.dev

Reddit updates:

- https://www.reddit.com/r/Supabase/comments/1jfrky2/huge_mile...

- https://www.reddit.com/r/Supabase/comments/1ij9jcl/introduci...

Happy to discuss or collaborate if anyone's interested!