Search Postgresql Archives

user get notification when postgresql database updated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux