Re: Equivalent of Oracle Advanced Queue in Postgres

Hi Umesh

We have tested https://github.com/tembo-io/pgmq and that looks like a
product going in the right direction as a substitute for AQ on postgres.

Med venlig hilsen

Peter Gram
Sæbyholmsvej 18
2500 Valby

Mobile: (+45) 5374 7107
Email: peter(dot)m(dot)gram(at)gmail(dot)com

On Wed, 6 Mar 2024 at 10:22, Umesh Kumar Yadav <umeshroks1208(at)gmail(dot)com>
wrote:

> Dear PostgreSQL Community Forum Members,
>
> I hope this message finds you well. I am reaching out to inquire about the
> equivalent functionality of Oracle Advanced Queue in PostgreSQL.
>
> As we continue to explore and migrate our database solutions to
> PostgreSQL, we have encountered a need for a feature similar to Oracle
> Advanced Queue. In Oracle, Advanced Queue provides a messaging
> infrastructure that enables asynchronous communication between
> applications. It allows messages to be stored persistently in the database
> until they are consumed by subscribing applications.
>
> Could you please provide insights or recommendations on how we can achieve
> similar functionality in PostgreSQL? We are particularly interested in
> features or extensions within PostgreSQL that offer queuing capabilities,
> message persistence, and asynchronous communication between applications.
>
> Any guidance, best practices, or suggestions from the community would be
> greatly appreciated. Additionally, if there are any existing PostgreSQL
> extensions or modules that provide comparable functionality to Oracle
> Advanced Queue, we would love to learn more about them.
>
> Thank you in advance for your time and assistance. We look forward to
> hearing from the knowledgeable members of the PostgreSQL community.
>
> Best regards,
>
> Umesh Kumar Yadav
>