News for hackers. Stuff that matters.
Re:Build durable workflows with Postgres by cpursley on Friday August 08, 2025 @03:46PM (#44840923)
I've been using https://www.pgflow.dev for workflows which is built on pgmq and am really impressed so far. Most of the logic is in the database so I'm considering building an Elixir adapter DSL.
Re:Build durable workflows with Postgres by ishita_julep on Friday August 08, 2025 @03:59PM (#44841045)
what are you using the DSL for?
Re:Build durable workflows with Postgres by cpursley on Friday August 08, 2025 @04:52PM (#44841579)
It’s used to generate the database migration that defines the flows. More syntax sugar than anything.
Re:Build durable workflows with Postgres by mmcclure on Friday August 08, 2025 @06:37PM (#44842400)
Just curious, if you’re already in Elixir and using Postgres, why not use Oban[1]? It’s my absolute favorite background job library, and the thing I often miss most when working in other ecosystems.

[1] https://github.com/oban-bg/oban

Re:Build durable workflows with Postgres by sbrother on Friday August 08, 2025 @11:54PM (#44843913)
Oban is so good! My startup has an extensive graph of background jobs all managed by Oban, and it's just rock solid, simple to use and gets out of the way.
Re:Build durable workflows with Postgres by cpursley on Saturday August 09, 2025 @07:11AM (#44845589)
Oban is awesome, but I really like the ideas around pgmq and most of the logic living in the database. And the idea of "flows" design from pgflow for multi-step processes (which Elixir is naturally a great match for)