Insert Jobs From SQL? #1006

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',
 '{}',
 25
);
SELECT pg_notify(current_schema() || '.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!

We added some formal docs on this here:

https://riverqueue.com/docs/sql