How pgmq/pgmq works
PGMQ is a PostgreSQL-backed message queue exposed as SQL functions and a Rust client library. The main workflow is producer sends a message to a queue; a consumer reads it under a visibility timeout, then deletes or archives it. The SQL API also documents FIFO/grouped queues and topic routing; Rust offers multiple database-client adapters and installation/migration helpers. The SQL implementation was not sampled, so SQL capability links rely on README evidence; Rust links use the shown excerpts or SOURCE INDEX references.
Main entry points: pgmq.sql SQL Queue API · queue/mod.rs Queue Interface · install/mod.rs Install Orchestrator · sqlx/mod.rs SQLx Adapter
Components 22
PostgreSQL Queue
- SQL Queue API
pgmq-extension/sql/pgmq.sql - Queue Tables
pgmq-extension/sql/pgmq.sql - Archive Tables
pgmq-extension/sql/pgmq.sql - FIFO Groups
docs/fifo-queues.md - Topic Routing
docs/topics.md
Rust Client
- Queue Interface
pgmq-rs/src/queue/mod.rs - SQLx Extension Client
pgmq-rs/src/pg_ext/mod.rs - SQLx Adapter
pgmq-rs/src/queue/sqlx/mod.rs - Diesel Adapter
pgmq-rs/src/queue/diesel/mod.rs - Postgres Adapters
pgmq-rs/src/queue/rust_postgres/mod.rs - Queue SQL
pgmq-rs/src/queue/sql.rs - Diesel Queries
pgmq-rs/src/queue/diesel/query.rs
Installation
- Install Orchestrator
pgmq-rs/src/install/mod.rs - Migration Scripts
pgmq-rs/src/install/script.rs - Applied Migrations
pgmq-rs/src/install/applied.rs - Version Parsing
pgmq-rs/src/install/version.rs
Shared Types
- Message Models
pgmq-rs/src/types/mod.rs - Queue Name Validation
pgmq-rs/src/types/queue_name.rs - Timeout Types
pgmq-rs/src/types/duration.rs
Other components
- Producer
- Consumer
- PostgreSQL
Connections 25
- Producer → SQL Queue API: sends messages
README.md - SQL Queue API → Queue Tables: stores messages
README.md - Consumer → SQL Queue API: reads messages
README.md - SQL Queue API → Queue Tables: reads messages
README.md - SQL Queue API → Queue Tables: deletes messages
README.md - SQL Queue API → Archive Tables: archives messages
README.md - SQL Queue API → FIFO Groups: supports ordering
README.md - SQL Queue API → Topic Routing: routes topics
README.md - Queue Interface → SQLx Adapter: implements interface
pgmq-rs/src/queue/mod.rs - Queue Interface → Diesel Adapter: implements interface
pgmq-rs/src/queue/mod.rs - Queue Interface → Postgres Adapters: implements interface
pgmq-rs/src/queue/mod.rs - SQLx Extension Client → SQLx Adapter: delegates queries
pgmq-rs/src/pg_ext/mod.rs - SQLx Adapter → Queue SQL: uses statements
pgmq-rs/src/queue/sqlx/mod.rs - Diesel Adapter → Diesel Queries: builds queries
pgmq-rs/src/queue/diesel/mod.rs - Diesel Queries → Queue SQL: uses statements
pgmq-rs/src/queue/diesel/query.rs - Postgres Adapters → Queue SQL: uses statements
pgmq-rs/src/queue/rust_postgres/mod.rs - Queue Interface → Message Models: returns messages
pgmq-rs/src/queue/mod.rs - Queue Interface → Queue Name Validation: validates names
pgmq-rs/src/queue/macros.rs - Queue Interface → Timeout Types: uses timeouts
- Install Orchestrator → Applied Migrations: loads applied state
pgmq-rs/src/install/mod.rs - Install Orchestrator → Migration Scripts: runs migrations
pgmq-rs/src/install/mod.rs - Migration Scripts → Applied Migrations: records versions
pgmq-rs/src/install/script.rs - Install Orchestrator → Version Parsing: orders versions
pgmq-rs/src/install/mod.rs - SQL Queue API → PostgreSQL: runs on
README.md - Install Orchestrator → PostgreSQL: installs extension
pgmq-rs/src/install/mod.rs