PostgreSQL-based job queue with priority scheduling, batch claiming, and progress tracking. Use when building job queues without external dependencies. Triggers on PostgreSQL job queue, background jobs, task queue, priority queue, SKIP LOCKED.
Initial release of postgres-job-queue, a PostgreSQL-based job queue with priority, batch claiming, and progress tracking. - Production-ready schema for jobs table, with fields for priority, progress, worker tracking, and retries. - Example SQL and Go code for batch claiming using SKIP LOCKED. - Includes job completion, failure, and stale job recovery routines in Go. - Clear decision tree for when to use PostgreSQL vs. other queues. - “NEVER Do” section for critical design guidelines and anti-patterns.