pgmq

Message queue on Postgres.

Visit website ↗

Profile updated

Console’s review

· Reviewed by David Mytton

What we like

No background worker needed - it’s a Postgres extension that bundles functions. Supports exactly once delivery. API compatibility with AWS SQS. Each queue is its own table. Messages can be archived for long term retention. Supports partitioned queues.

Tradeoffs

Be sure to understand the visibility timeout to ensure exactly once delivery operates as expected. Only has official clients for Rust & Python.

Is pgmq a fit?

Based on Console’s review published on 2024-06-06.

Who it’s for

Developers using Postgres and needing a message queue with API compatibility with AWS SQS

Why consider it

It supports exactly once delivery

Keep in mind

It requires understanding of visibility timeout for exactly once delivery

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects Console’s assessment at publication on 2024-06-06. Features and limitations may have changed since the review date. Read our selection criteria and learn about Console.

Key facts

What it is

Postgres-based message queue.

Source ↗Checked

Company or maintainer

The pgmq project; repository now maintained under pgmq/pgmq.

Source ↗Checked

Source and licensing

Free and open source, PostgreSQL licence.

Source ↗Checked

Tech stack

SDK support
  • Python
  • Rust
Integrates with
  • Docker
  • PostgreSQL

Checked

Source and notes

Message queue runs on PostgreSQL, distributes Docker images, and links first-party Rust/Python clients.

View research source ↗

Coverage may be incomplete. “Written in” describes implementation, not supported project languages.

Pricing

Free and open source (PostgreSQL licence). No paid hosted plan was verified from the cited repository; self-hosting infrastructure costs are separate.

Pricing source ↗Checked

Also consider

Related interviews

Discover your next favorite tool

Independent devtool reviews and the latest betas, in your inbox every Thursday. Free.