Re: [GENERAL] options for launching sql script asynchronously from web app

2008-11-08 Thread TJ O'Donnell
The only way to launch an ~asynchronous~ request from a web app is using XMLHTTPRequest. That would be answered by a web server of some sort. The server can launch any app you want - to run a sql script, say. Authentication can be done with passwords, as usual. Security may be an issue - you sh

Re: [GENERAL] options for launching sql script asynchronously from web app

2008-11-08 Thread Asko Oja
On Sat, Nov 8, 2008 at 12:40 PM, Ivan Sergio Borgonovo <[EMAIL PROTECTED] > wrote: > On Sat, 8 Nov 2008 11:36:06 +0200 > "Asko Oja" <[EMAIL PROTECTED]> wrote: > > > Whenever asynchronous execution or batch processing is needed PgQ > > in SkyTools should be one option to be evaluated. It has PhP >

Re: [GENERAL] options for launching sql script asynchronously from web app

2008-11-08 Thread Ivan Sergio Borgonovo
On Sat, 8 Nov 2008 11:36:06 +0200 "Asko Oja" <[EMAIL PROTECTED]> wrote: > 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. Nice to know and really nice tool but i

Re: [GENERAL] options for launching sql script asynchronously from web app

2008-11-08 Thread Asko Oja
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 <[EMAIL PROTECTED]> wrote: > Authenticate in web app and drop a scrip

Re: [GENERAL] options for launching sql script asynchronously from web app

2008-11-07 Thread Nikolas Everett
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

[GENERAL] options for launching sql script asynchronously from web app

2008-11-07 Thread Ivan Sergio Borgonovo
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.or