Postgres job queues in golang with FOR UPDATE SKIP LOCKED and advisory locks
How we share background jobs between several ECS tasks with only Postgres: a SKIP LOCKED batch claim with a retry window, and a transaction advisory lock that keeps a per-user weekly cap honest. With tests that show the naive versions failing.