I am using javaScript app and PostgreSQL database. I have car_alert as a
table contains id (FK of cars table) and userid (FK of users table)
each car has a status ( status column in cars table ).
car_alert is updating and having new records (car id and userid ) every time
user choose car to be alerted about.
my database information is updating every 10 min and the user should get
notification message every time status for its car is changed. ( of course
every user has choosed his interested cars and inserted them to the
car_alert table by car id ) .
what is the best method to do that ?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/user-get-notification-when-postgresql-database-updated-tp5600187p5600187.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.