search

timgit / pg-boss

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

Can we say this amazing project is somehow similar to... #86

Closed frederikhors closed 6 years ago

frederikhors commented 6 years ago

Can we say this amazing project is somehow similar to this: https://github.com/chanks/que ?

timgit commented 6 years ago

Yes, these projects are similar. :grinning:

frederikhors commented 6 years ago

@timgit is there something you can say about this? https://github.com/chanks/que/issues/228#issuecomment-420699547

This is the author of https://github.com/chanks/que talking about your project, but we have not clear ideas about:

Can you enlighten us about it?

timgit commented 6 years ago

Yes, fundamentally, both of our projects are queues built on top of postgresql. I built pg-boss with a hard requirement of 9.5 and up in order to use SKIP LOCKED exclusively. All SQL used can be found in the plans.js file. I don't use LISTEN or NOTIFY. This is entirely polling and/or fetch based.

You can read about some of the reasoning behind this feature and advisory locks in https://blog.2ndquadrant.com/what-is-select-skip-locked-for-in-postgresql-9-5/

frederikhors commented 6 years ago

@chanks, is this answer about SKIP LOCKED enough to understand the differences with your project?

Thasnk @timgit.

chanks commented 6 years ago

Yep, sounds different! Thanks, @timgit.