yes you can add jobs with sql in a transaction, e.g.
SELECT graphile_worker.add_job( 'send_email', json_build_object( 'to', 'someone@example.com', 'subject', 'graphile-worker test' ) );
(can also use the PERFORM statement instead of SELECT)
79 karma · joined October 9, 2014
SELECT graphile_worker.add_job( 'send_email', json_build_object( 'to', 'someone@example.com', 'subject', 'graphile-worker test' ) );
(can also use the PERFORM statement instead of SELECT)
https://chrisgliddon.com/the-tragic-story-of-vernon-and-oswa...
I built a multiplayer version as a weekend project, would love to know what you think!