Enqueue a workflow directly from Postgres

[craig-at-metashield-io]

At the moment, we can enqueue workflows using DBOSClient's enqueue method. It would be very useful to have a database function in the dbos schema which allowed us to enqueue a workflow task directly from SQL.

This could be called, for instance, by a row-insert/update trigger that could enqueue a task for further processing.

it would be wonderful!

thanks for the fantastic framework, btw.

[kraftp]

Thanks, this is something we're thinking about! The biggest issue is serialization, as the workflow task's inputs would have to be serialized in Postgres to a form the DBOS workers can understand.

[apoliakov]

Hey @craig-at-metashield-io ! We noticed you filed a lot of really good DBOS issues. Thank you for your contributions.

We'd love to chat with you and learn more about how you use DBOS and what else you might need. Also happy to answer any questions. Feel free to grab a time anytime: https://calendly.com/alex-poliakov-dbos/30min

Or email "alex.poliakov [at] dbos [dot] dev" if you can't find a time.