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@webthatworks.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general