Repository navigation
Insert Jobs From SQL? #1005
Description
Activity
Good point, it's pretty plausible to insert jobs via any SQL with something like this:
INSERT INTO river_job ( kind, args, max_attempts ) values ( 'fake_job', '{}', 10 ); SELECT pg_notify('river_insert', '{"queue":"default"}');
That's the core set of fields without defaults on the columns, but you can of course do additional customization on properties like
priority,queue,metadata,tags, etc.Note though that the unique logic is quite complicated, so unique jobs won't be usable without a fairly well-vetted client library.
This is helpful thank you!
Reacted by Brandur- locked and limited conversation to collaborators
on Aug 11, 2025
Is there way to insert jobs with raw SQL from any language? The docs only mention the Python and Ruby libraries. It would be awesome to let any service in any language insert jobs with SQL and then let the Go engine work them.