Re: options for launching sql script asynchronously from web app
| От | Nikolas Everett |
|---|---|
| Тема | Re: options for launching sql script asynchronously from web app |
| Дата | |
| Msg-id | d4e11e980811071749g78b47a2bh7f98a4605791090b@mail.gmail.com обсуждение исходный текст |
| Ответ на | options for launching sql script asynchronously from web app (Ivan Sergio Borgonovo <mail@webthatworks.it>) |
| Ответы |
Re: options for launching sql script asynchronously from web app
|
| Список | 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
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 по дате отправления: