Re: options for launching sql script asynchronously from web app

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(at)gmail(dot)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(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
>>
>
>