persistent connections for qmail file programs

2000-01-06 Thread Peter Gradwell

Hi ya,

If I have a perl script, in a .qmail- file, which connects to a mysql 
database, has anyone considered how to make the mysql connection persistent.

Would it be at all possible to have persistence in the program run by a 
.qmail file?

or am i totally mad?

peter

--
peter at gradwell dot com; online @ http://www.gradwell.com/



Re: persistent connections for qmail file programs

2000-01-06 Thread Patrick Berry

on 1/6/00 2:25 PM, Peter Gradwell had the thought:

> Hi ya,
> 
> If I have a perl script, in a .qmail- file, which connects to a mysql
> database, has anyone considered how to make the mysql connection persistent.
> 
> Would it be at all possible to have persistence in the program run by a
> ..qmail file?

This is the "long way" as I don't really know the "short war".  You could
set up Apache+mod_perl+my_sql and have the dot-qmail file send stuff to a
cgi.  I'm not to sure about any other ways.

> or am i totally mad?

Pat

-- 
Freestyle Interactive | http://www.freestyleinteractive.com | 415.778.0610



Re: persistent connections for qmail file programs

2000-01-06 Thread Sam

Peter Gradwell writes:

> Hi ya,
> 
> If I have a perl script, in a .qmail- file, which connects to a mysql 
> database, has anyone considered how to make the mysql connection persistent.
> 
> Would it be at all possible to have persistence in the program run by a 
> .qmail file?
> 
> or am i totally mad?

Sure.  Anything is possible.  Run your Perl script permanently in the
background, and have a small Perl stub executed from .qmail that connects
to the background daemon via a socket or a pipe, and does what it has to
do.


-- 
Sam