Re: user get notification when postgresql database updated

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Albert <oo_O2_oo(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: user get notification when postgresql database updated
Date: 2012-03-30 08:51:14
Message-ID: 5A29D956-B402-4871-BE48-87417AB0BCC9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. You will 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hendrik Visage 2012-03-30 12:13:45 Adding new and changed data
Previous Message Alban Hertroys 2012-03-30 08:45:40 Re: default value returned from sql stmt