Re: options for launching sql script asynchronously from web app

["Asko Oja" <ascoja@xxxxxxxxx>]

Whenever asynchronous execution or batch processing is needed PgQ in SkyTools should be one option to be evaluated. It has PhP interfaces as well as tens of useful Python scripts.

On Sat, Nov 8, 2008 at 3:49 AM, Nikolas Everett <nik9000@xxxxxxxxx> wrote:

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