PostgreSQL Support

[Vad1mo]

I am aware that PostgreSQL is now a Message Queue per se; however, it can be utilized as such. Many developers realize that it suffices for the majority of tasks, and it comes with zero added costs if a PostgreSQL db is present.

It would be nice if faststream supported that too.

• https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology/
• https://www.prequel.co/blog/sql-maxis-why-we-ditched-rabbitmq-and-replaced-it-with-a-postgres-queue
• https://dagster.io/blog/skip-kafka-use-postgres-message-queue

btw.

• You can do exactly this with MySQL and SQL server too because they both support SKIP LOCKED.

[davorrunje]

Thank you for the suggestion :)

Could you please open an issue for this? We will support additional protocols by the popular demand.

[davorrunje]

Issue opened: #799