SKIP LOCKED vs. Redis: When Should You Use a Database Queue?

SKIP LOCKED is an option for SELECT ... FOR UPDATE . It tells the database: if another transaction has already locked a row, don’t wait for it. Skip that row and return the next one that is free. It sounds like a small detail, but it was…