3 ms·

All these job queue implementations do the same thing right, SELECT ... FOR UPDATE SKIP LOCKED? Why does every programming language need its own variant?

• rockwotj 3y ago
  To work with each language's drivers
  • RedShift1 3y ago
    But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?
    • ddorian43 3y ago
      You just do the update with skip locked and finish the job until time runs out or update the job "liveness". (can be autocommit on & off)