pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEquivalent of Oracle Advanced Queue in Postgres
4+ messages / 4 participants
[nested] [flat]
* Equivalent of Oracle Advanced Queue in Postgres
@ 2024-03-06 09:22 Umesh Kumar Yadav <umeshroks1208@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Umesh Kumar Yadav @ 2024-03-06 09:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Equivalent of Oracle Advanced Queue in Postgres
@ 2024-03-06 09:43 Gabriel Guillem Barceló Soteras <gbarcelo@parlamentib.es>
parent: Umesh Kumar Yadav <umeshroks1208@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Gabriel Guillem Barceló Soteras @ 2024-03-06 09:43 UTC (permalink / raw)
To: Umesh Kumar Yadav <umeshroks1208@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Equivalent of Oracle Advanced Queue in Postgres
@ 2024-03-06 09:44 Holger Jakobs <holger@jakobs.com>
parent: Umesh Kumar Yadav <umeshroks1208@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Holger Jakobs @ 2024-03-06 09:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../../4fbd9687-7e3e-188e-a030-47977e6e3563@jakobs.com/3-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Equivalent of Oracle Advanced Queue in Postgres
@ 2024-03-06 13:05 Peter Gram <peter.m.gram@gmail.com>
parent: Umesh Kumar Yadav <umeshroks1208@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Peter Gram @ 2024-03-06 13:05 UTC (permalink / raw)
To: Umesh Kumar Yadav <umeshroks1208@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.m.gram@gmail.com
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-03-06 13:05 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-06 09:22 Equivalent of Oracle Advanced Queue in Postgres Umesh Kumar Yadav <umeshroks1208@gmail.com>
2024-03-06 09:43 ` Gabriel Guillem Barceló Soteras <gbarcelo@parlamentib.es>
2024-03-06 09:44 ` Holger Jakobs <holger@jakobs.com>
2024-03-06 13:05 ` Peter Gram <peter.m.gram@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox