zlacker

>>bo0tzz+(OP)
For several projects I’ve opted for the even dumber approach, that works out of the box with every ORM/Query DSL framework in every language: using a normal table with SELECT FOR UPDATE SKIP LOCKED

https://www.pgcasts.com/episodes/the-skip-locked-feature-in-...

It’s not “web scale” but it easily extends to several thousand background jobs in my experience

>>aduffy+82
As I understand, with SKIP LOCKED rows would no longer be processed in-order?

>>orange+r8
Depends on how many consumers you have. If you need order guarantees, then something like the outbox pattern is probably a better fit.

>>klysm+Ai
Nothing about the outbox pattern guarantees ordering.