SKIP LOCKED lets you write queues. It’s also available in MySQL and SQL Server. ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

andrewstuart on June 25, 2023 | parent | context | favorite | on: What is SKIP LOCKED for in PostgreSQL?

SKIP LOCKED lets you write queues.

It’s also available in MySQL and SQL Server.

I wrote a “simpler than SQS” http based queue in Python using SKIP LOCKED.

https://github.com/starqueue/starqueue

Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact