On Wed, 1 Dec 2004 18:39:00 +0000, Tim Bunce wrote:

H Tim

>�need a better understanding of the underlying issues. More real-
>�world examples would help.

Here's a real world example of how I do things, although I am in no way 
convinced that such a module as we are discussing is needed...

The problem:
I run identical code on my local PC and on my web host's PC interstate.

The solution:
To simplify connexion matters, I just change one parameter to the constructor, 
from
Class -> new(site => 'local') to Class -> new(site => 'remote'), and use that 
to index
into a hash to get the connexion parameters. So, with $$self{'_site'} populated 
via new()
and $$self{'_dsn'} stored within the class, like:
                _dsn =>
                {
                        local   => ['dbi:mysql:db_name1:127.0.0.1', 
'username1', 'password1'],
                        remote  => 
['dbi:mysql:db_name2:dbhost.quadrahosting.com.au', 'username2', 'password2'],
                },
        _site => '', # Must be one of local | remote. Validated in new().
        _other_stuff...
I can now connect with something like DBI -> 
connect(@{$$self{'_dsn'}{$$self{'_site'} } }, %attr);

Simple!

PS
I've found quadrahosting very cooperative. They are a US company with an 
Australian office, and vastly cheaper that their Australian competitors (but 
let's not start a discussion about that in this thread, please).
See the mod_perl web site for hosting companies:
http://perl.apache.org/help/isps.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 2/12/2004
http://savage.net.au/index.html

Reply via email to