Re: options for launching sql script asynchronously from web app - Mailing list pgsql-general

From Asko Oja
Subject Re: options for launching sql script asynchronously from web app
Date
Msg-id ecd779860811080136j1aebbd27l2f46dfcedee07803@mail.gmail.com
Whole thread Raw
In response to Re: options for launching sql script asynchronously from web app  ("Nikolas Everett" <nik9000@gmail.com>)
Responses Re: options for launching sql script asynchronously from web app  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
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@gmail.com> 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@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


pgsql-general by date:

Previous
From: Gerhard Heift
Date:
Subject: Get interval in months
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: options for launching sql script asynchronously from web app