With cron you could make your script "grab clients" every minute. If
you need even smaller increments between checks then the thing to do
would be to write a long running program.
Jason
Lev Lvovsky <lists1@sonous.com> writes:
> this is for a billing system, at this point it's a toss-up b/w the
> following:
>
> 1. a script grabs clients which need billing on a nightly basis
> 2. a script grabs clients which need billing for a particular time
> interval (every hour, ever two hours etc...).
>
> what methods are used for making this close to real-time - constant
> polling?
>
> thanks!
> -lev
>
> On 2 Jul 2002, Jason Earl wrote:
>
> >
> > If it only needs to be /fairly/ realtime, then you could use cron to
> > fire a script every minute. Otherwise you could write an external
> > long-running program that listens for notifies.
> >
> > Jason
> >
> > Lev Lvovsky <lists1@sonous.com> writes:
> >
> > > is it possible to create a trigger when the system time has reached the
> > > date of a particular record? I know this is possible with an external
> > > script, but I'm not quite sure how to go about making it fairly
> > > real-time...
> > >
> > > thanks!
> > > -lev
> > >
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> >
>
> --
> personal site :: www.sonous.com
> rave site :: raves.sonous.com
> I'm a DJ! site :: djkgb.sonous.com
>
>
> "...is the best show on television. Its cooler than the other side of the
> pillow." -Kevin King