PGMQ is a lightweight message queue similar to AWS SQS and RSMQ, running on Postgres. It offers guaranteed “exactly once” delivery of messages within a visibility timeout. Surprisingly, no background worker or external dependencies are needed; everything runs on Postgres functions. Unique features include messages staying in the queue until explicitly removed, the ability to archive messages instead of deleting them, and support for Postgres 12-16. Installation is simplified with a Tembo docker image, and client libraries are available for Rust, Python, Go, Elixir, Java, JavaScript, and more. The visibility timeout feature ensures messages are processed efficiently. Installation and configuration details are also provided.
https://github.com/tembo-io/pgmq