Re: user get notification when postgresql database updated - Mailing list pgsql-general

From Alban Hertroys
Subject Re: user get notification when postgresql database updated
Date
Msg-id 5A29D956-B402-4871-BE48-87417AB0BCC9@gmail.com
Whole thread Raw
In response to Re: user get notification when postgresql database updated  (Albert <oo_O2_oo@hotmail.com>)
List pgsql-general
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 can't notify your browser-based application from your server.
Youwill have to poll. 

Googling for "ajax push" turned up this explanation: http://www.subbu.org/blog/2006/04/dissecting-ajax-server-push

Alban Hertroys

--
The scale of a problem often equals the size of an ego.



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: default value returned from sql stmt
Next
From: Hendrik Visage
Date:
Subject: Adding new and changed data