Re: DBIx::DBH - Perl extension for simplifying database connectio ns

From: Michael Peppler (mpeppler_at_peppler.org)
Date: 12/08/04 

To: dbi-users@perl.org
Date: Wed, 08 Dec 2004 08:09:36 +0100

On Wed, 2004-12-08 at 07:26, Jonathan Leffler wrote:

>
> Fundamentally, the DBI spec says: you connect to a database X by
> specifying 'dbi:X:whatever-X-chooses'. Trying to specify
> 'whatever-X-chooses' in some way that is independent of X is nonsense
> - and that's why the DBI spec does things the way it chooses to.

I'm with Jonathan on this one.

The DBI DSN spec is is what caused me to add all sorts of optional
connection string parameters that are very specific to Sybase. These
include things like setting the packet size, using SSL, setting the
charset, etc. that happen prior to the actual connection being open.

So even if you create a generic mechanism for building DSNs there will
be a lot of stuff that won't work, or will need a whole host of
exceptions and special handling.

Michael 

-- 
Michael Peppler  -  mpeppler@peppler.org  -  http://www.peppler.org/
Sybase DBA/Developer
Available for contract work - http://www.peppler.org/resume.html