Re: options for launching sql script asynchronously from web app

Authenticate in web app and drop a script in a directory and run them with
cron maybe?
Authenticate in web app and drop a row in a table and let a long running
process suck the row out and kick something off in a thread pool?

I've seen both. You've got to monitor both somehow. The second one is much
more work but lets you do more with the output and gives you a nice thread
pool. There might be a simple bash-ie way to make a thread pool, but I
don't know it.

--Nik

On Fri, Nov 7, 2008 at 8:06 PM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)it>wrote:

> I'd like to launch some sql script asynchronously from a web app and
> have some kind of feedback later.
>
> Some form of authentication would be a plus.
>
> Is there anything ready?
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>