How to Use NOTIFY/LISTEN for Asynchronous Messaging in PostgreSQL (Producer and Consumer)
Buy me a coffee if this is useful 😀
https://www.buymeacoffee.com/rowadz
Asynchronous messages in PostgreSQL with NOTIFY/LISTEN || producer and consumer
In this video, I'm introducing the "NOTIFY" and "LISTEN " commands from PostgreSQL, showing some use cases and keynotes about using this, also comparing this with RabbitMQ.
more videos like this (🥼 Rowadz Lab 🥼):
• 🥼 Rowadz Lab 🥼
🔱 Graphs & trees 🔱
• 🔱 Graphs & trees 🔱
Links from the video:
➼ notify
https://www.postgresql.org/docs/curre...
➼ pg-listen
https://github.com/andywer/pg-listen
➼ PostgreSQL LISTEN/NOTIFY by Dimitri Fontaine
https://tapoueh.org/blog/2018/07/post...
➼ What is SKIP LOCKED for in PostgreSQL 9.5?
https://www.enterprisedb.com/blog/wha...
➼ Postgres Listen/Notify As Message Queue
https://dba.stackexchange.com/questio...
➼ pgsql-listen-exchange
https://github.com/gmr/pgsql-listen-e...
➼ Listening to generic JSON notifications from PostgreSQL in Go
https://coussej.github.io/2015/09/15/...
00:00 Intro to the notify and listen commands
01:42 Two differences from RabbitMQ
03:25 Cache - a use case from an article
04:55 Duplicate payloads in the same transactions
08:16 Notify and SQL transactions
09:06 The order of notifications and duplicated payloads
09:50 How to handle the notification looping back to the sender
12:51 Historical data - a use case with code example from an article
13:58 How big is the notification queue and about the queue cleanup
15:30 Summary
17:30 Some useful links
Watch video How to Use NOTIFY/LISTEN for Asynchronous Messaging in PostgreSQL (Producer and Consumer) online without registration, duration hours minute second in high quality. This video was added by user Rowadz 19 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,427 once and liked it 306 people.