search

timgit / pg-boss

Queueing jobs in Postgres from Node.js like a boss
MIT License
2.15k stars 160 forks source link

pgboss in Rust ecosystem #503

Open rustworthy opened 1 month ago

rustworthy commented 1 month ago

Hello Tim,

Thanks again for this beautiful piece of software. I was enjoying using it at a Node.js project and wished there had been a crate with at least a pgboss client - to consume job and report on the processing results, so that I did not need to rewrite functionality I had in Rust. I then realized that the application can be much broader and can cover those cases where people do not even have any services powered by Node.js runtime.

There is now a crate that I will be developing and I'll try to keep up to date with the reference implementation with regards to data definition. I've already faced some caveats there, but so far nothing that prevents the crate from being compatible with Node.js ecosystem.

I am following the development of the pg-boss package with interest and great pleasure and can see v11 is coming which is exciting.

Regards Pavel

timgit commented 1 month ago

Is your intention to use Node.js to install and maintain the schema, or just copy the schema entirely?

timgit commented 1 month ago

v11 looks like it will have a significant number of schema changes, but I am still going to make an attempt at a migration script.

rustworthy commented 1 month ago

Is your intention to use Node.js to install and maintain the schema, or just copy the schema entirely?

The schema can be installed from the within the Rust app, when initiating the Client. I am only publishing release candidates awaiting v11 so that I can apply the latest ddl. But I think at some point I will need to add migration scripts as well.

I am also adding the schema_name.create_job function that can receive json opts that are unpacked internally and used to create a job.