user get notification when postgresql database updated

From: Albert <oo_O2_oo(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: user get notification when postgresql database updated
Date: 2012-03-28 11:40:42
Message-ID: 1332934842556-5600187.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Molesworth 2012-03-28 12:14:05 Re: user get notification when postgresql database updated
Previous Message Albe Laurenz 2012-03-28 07:35:11 Re: Multiple Slave Failover with PITR