A lightweight message queue built on PostgreSQL, offering SQS-like functionality with transactional guarantees.
pgmq is a lightweight message queue that runs directly on PostgreSQL, providing reliable message queuing with transactional semantics. It offers an alternative to cloud-based queues like AWS SQS by leveraging PostgreSQL's durability and consistency guarantees.
Developers and teams already using PostgreSQL who need a simple, reliable message queue without adding separate infrastructure, such as those building applications requiring asynchronous task processing or event-driven architectures within a PostgreSQL environment.
Developers choose pgmq because it eliminates the need for separate messaging infrastructure by leveraging PostgreSQL's built-in reliability, replication, and transactional guarantees, offering a familiar SQS-like API with minimal dependencies.
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Messages are sent and received within PostgreSQL transactions, ensuring atomic operations and data consistency, as highlighted in the Key Features.
Provides an interface similar to AWS SQS with simple operations, reducing the learning curve for developers already accustomed to cloud queues.
Leverages PostgreSQL's built-in durability, replication, and backup capabilities, eliminating the need for separate messaging infrastructure.
Minimal dependencies and easy setup allow quick deployment within existing PostgreSQL environments, as noted in the Lightweight Design feature.
Supports visibility timeouts to prevent duplicate message processing, essential for reliable distributed systems, as mentioned in the Key Features.
Lacks features like message routing, prioritization, or comprehensive monitoring tools compared to full-fledged message brokers such as RabbitMQ.
Using PostgreSQL for queuing can introduce latency and resource contention under high load, as it's not optimized solely for messaging workloads.
Requires PostgreSQL installation and management, which may not suit teams preferring database-agnostic or lightweight alternatives.
pgmq is an open-source alternative to the following products:
RSMQ (Redis Simple Message Queue) is a lightweight message queue system built on Redis, providing simple queuing functionality for distributed applications.
Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems, and serverless applications.