search

timgit / pg-boss

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

pg-boss vs graphile-worker? #227

Closed stephane-klein closed 3 years ago

stephane-klein commented 3 years ago

Hi,

I have just seen pg-boss project from Postgres Weekly email.

I'm a graphile / worker user and I wonder what are difference between pg-boss and graphile-worker.

This two projects achieve the same goals?

Same question on graphile-worker issues

Best regards, Stéphane

timgit commented 3 years ago

Hey Stephane. I haven't used graphile worker. I probably would have if it been around 5 years ago when I needed it, however. :) At a high level, these projects look the same and will accomplish the same goals.

Of course, I would argue how superior pg-boss is from an architectural perspective (:wink:) , but I imagine the graphile worker dudes would do the same for theirs. The best suggestion I can offer is to try both and learn about these architectural differences.

To provide a bit more info, one way that I often find myself describing pg-boss is similar to how AWS SQS works. It's the client's responsibility to pull work from a queue, either on-demand or an interval. This is basically how pg-boss works with its subscribe and fetch apis.