graphile-worker

What problem does it solve?

This Skill addresses the need for efficient, high-performance job queuing directly within PostgreSQL, leveraging triggers and LISTEN/NOTIFY for near real-time job processing.

Core Features & Use Cases

• Trigger-based Job Creation: Automatically queue jobs when database events occur.
• Low-latency Job Pickup: Achieve millisecond job pickup using PostgreSQL's LISTEN/NOTIFY mechanism.
• Transactional Consistency: Ensure jobs are queued atomically with data changes.
• Cron Scheduling: Implement recurring tasks directly within the worker.
• Use Case: When a new user signs up, a database trigger can automatically queue a send_welcome_email job, which is picked up and processed within milliseconds.

Quick Start

Use the graphile-worker skill to set up a basic job queue with TypeScript tasks.