| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
| Cc: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>, PHP_DB <php-db(at)lists(dot)php(dot)net>, PHP_General <php-general(at)lists(dot)php(dot)net>, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>, PGSQL-GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] a script that queries database periodically |
| Date: | 2000-11-27 21:56:59 |
| Message-ID: | 3A22D8AB.47A873F2@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
"Poul L. Christiansen" wrote:
> > I was thinking of writing up a PHP script and put into crontab, which is
> > somehow easier than a shell script, but PHP is an apache module, so I
> > cannot execute PHP under crontab (it has to be executed in a browser
> > right?). I guess a shell script is necessary. So, is it possible to
> > call 'psql' and returning its query result and I can use sendmail to
> > email the result? Any other idea?
PHP does not have a scheduling facility? AOLserver (the web/application
server that powers AOL) has had such facility (and many many others for
db-backed websites) since 1995. ns_schedule_proc.
http://www.aolserver.com
-Roberto
--
Computer Science Utah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Partyka Robert | 2000-11-27 22:24:46 | one ask |
| Previous Message | Poul L. Christiansen | 2000-11-27 21:44:39 | Re: [SQL] a script that queries database periodically |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-11-27 22:24:55 | Re: [SQL] a script that queries database periodically |
| Previous Message | Poul L. Christiansen | 2000-11-27 21:44:39 | Re: [SQL] a script that queries database periodically |