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

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