Provide PostgreSQL-based job queues with exactly-once delivery for Node.js applications.
npx skills add https://github.com/toddlevy/tl-agent-skills --skill tl-pg-boss
Please help me install this Agent Skill. Skill: tl-pg-boss Source: https://github.com/toddlevy/tl-agent-skills/tree/main/skills/tl-pg-boss Command: npx skills add https://github.com/toddlevy/tl-agent-skills --skill tl-pg-boss
PostgreSQL-backed job queue for Node.js with exactly-once delivery, cron scheduling, and transactional safety, enabling reliable background processing within PostgreSQL-centric stacks.
Install pg-boss, initialize a queue, and start a worker to begin processing jobs.
High-intent search queries and answers about installing and using this skill.
A PostgreSQL job queue provides reliable background processing for Node.js by using SKIP LOCKED to ensure exactly-once delivery, preventing duplicate job execution across concurrent workers.
SKIP LOCKED enables exactly-once delivery by allowing concurrent worker queries to skip rows already locked by other workers, ensuring only a single worker fetches and processes each specific job.
Yes, you can schedule delayed and cron-based jobs directly in PostgreSQL, utilizing built-in queue management patterns for retries, dead-lettering failed tasks, and configuring retention options.
The best way to enqueue database jobs transactionally with Fastify is using API methods that insert jobs within the same database transaction, ensuring jobs are only queued if the primary operation succeeds.
You should use a PostgreSQL-backed queue when your stack is PostgreSQL-centric and requires deterministic execution, leveraging existing database transactions rather than introducing a separate dedicated message broker infrastructure.
leonj1Connect to Amazon RDS PostgreSQL databases and execute SQL queries.
JaveedIshaqImplement background job processing with BullMQ, Inngest, and Trigger.dev queues.
phuetzInstrument applications with Prometheus metrics and visualize them in Grafana dashboards.
vuralserhat86Implements asynchronous communication patterns using Kafka, RabbitMQ, NATS, Redis Streams, Celery, BullMQ, Temporal, and more.
