Thread: Equivalent of Oracle Advanced Queue in Postgres

Equivalent of Oracle Advanced Queue in Postgres

From
Umesh Kumar Yadav
Date:

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

Re: Equivalent of Oracle Advanced Queue in Postgres

From
Gabriel Guillem Barceló Soteras
Date:

Hi, you could architect your own solution with raw tables, triggers, polling, etc. Or you could have a minimal working proof of concept with LISTEN/NOTIFY statements. For exemple: https://www.baeldung.com/spring-postgresql-message-broker

 

Still, I think this would be a very simple solution for production use. You would achieve better results with a dettached style with RabbitMQ or something like this.

 

 

From: Umesh Kumar Yadav <umeshroks1208@gmail.com>
Date: Wednesday, 6 March 2024 at 10:22
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Equivalent of Oracle Advanced Queue in Postgres

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

Re: Equivalent of Oracle Advanced Queue in Postgres

From
Holger Jakobs
Date:
Am 06.03.24 um 10:22 schrieb Umesh Kumar Yadav:

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

Please throw the keywords PostgreSQL and queue into your favourite search engine


-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment

Re: Equivalent of Oracle Advanced Queue in Postgres

From
Peter Gram
Date:
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



On Wed, 6 Mar 2024 at 10:22, Umesh Kumar Yadav <umeshroks1208@gmail.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