3 ms·
I’d love to see one for Elixir built around the Postgres pgmq and pg_crom extensions similar to what pgflow is doing: https://www.pgflow.dev/ https://www.pgflow
by cpursley 1y ago
I’d love to see one for Elixir built around the Postgres pgmq and pg_crom extensions similar to what pgflow is doing: https://www.pgflow.dev/ https://www.pgflow.dev/
- rhgraysonii 1y agoThat would be super cool. Pretty much everything Supabase is up to is awesome.
- cpursley 1y agoYeah, their realtime thing is powered by Elixir (listens to Postgres WAL).
- jumski 1y agopgflow can be used with any language/runtime, I just started with TypeScript and Supabase, as that's what I'm using. The worker is stateless and "dumb" by design (currently it runs on serverless functions) - it just calls SQL functions: "poll_for_tasks" to get some tasks from the queue and then either "complete_task" or "fail_task" after executing user code - that's it, nothing more, so it should be relatively easy to adopt it to other runtimes. I have written a small architecture primer on pgflow if anyone is interested in its simple but flexible design https://www.pgflow.dev/concepts/how-pgflow-works/ https://www.pgflow.dev/concepts/how-pgflow-works/