top | item 36188691

(no title)

scarface74 | 2 years ago

I’ve run into all sorts of database locking issues and concurrency issues when using a database as a queue. I saw that mistake made a long time ago and I would never do it myself.

discuss

order

wolfgang42|2 years ago

Database engines are getting features like SELECT FOR UPDATE SKIP LOCKED, so what were once serious blockers on this idea may no longer be as much of a problem.

wombatpm|2 years ago

Is that necessary if you can just have your processes handle locking themselves?

scarface74|2 years ago

And if you skip records that you are depending on for your poor man’s queue, aren’t you just hiding bugs?