Re: [GENERAL] user get notification when postgresql database updated

2012-03-30 Thread Alban Hertroys
On 29 Mar 2012, at 11:43, Albert wrote: > it a browser based application. so would you advice me about the best way to > poll the database for notifications ? > > I've been read about DB triggers but still can't tell if it will help me. The HTTP protocol doesn't have a push mechanism, so you c

Re: [GENERAL] user get notification when postgresql database updated

2012-03-30 Thread Albert
another Q : my app should display notifications to each user depends on his selected cars. can i do that just using ajax and php ? -- View this message in context: http://postgresql.1045698.n5.nabble.com/user-get-notification-when-postgresql-database-updated-tp5600187p5606001.html Sent from the

Re: [GENERAL] user get notification when postgresql database updated

2012-03-29 Thread Albert
Thanks for your response! it a browser based application. so would you advice me about the best way to poll the database for notifications ? I've been read about DB triggers but still can't tell if it will help me. -- View this message in context: http://postgresql.1045698.n5.nabble.com/user-

Re: [GENERAL] user get notification when postgresql database updated

2012-03-28 Thread Tom Molesworth
On 28/03/12 12:40, Albert wrote: 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 ) e

[GENERAL] user get notification when postgresql database updated

2012-03-28 Thread Albert
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 al