PostgreSQL event triggers with Node.js(Listen / Notify)

preview_player
Показать описание
There are many cases where you need trigger an event in application if there is modification in database table. Usually application runs db queries to perform CRUD operation, here flow is `Application --- triggers --- DB`.
Imagine if your DB triggers an application event if there is change in DB table.

DB data value change --- triggers --- application event.
Рекомендации по теме
Комментарии
Автор

does it work for only INSERT in the table?

RavindraSingh
Автор

many thanks for the video, would it be possible to also share the trigger and node js code in a repo?

aksharjamgaonkar
Автор

Hi, Prashant, can you share the code or any link to github repository of the code

deekshithmadhunala
Автор

Didn't work for me with the CAST. Removing it did the trick.

koby
Автор

what does the dbRouter do? Don't understand that part of the code

RRits
Автор

That's so awesome.
Thanks your example.

m-falcon
Автор

thank you a lot for this video, it is very useful for beginners, love from Vietnam <3

phuocsanghuynh