Maybe the number of responses on this thread come from people who have this itch to scratch.
Huh? I've only been seeing what got cross-posted on this to module-authors until today, but I just subscribed to dbi-usres
n
I have heard Tim Bunce (DBI, DBD::Oracle etc) and Jonathan Leffler (DBD::Informix) raise 'Beware, thing are much more complex than you think' warnings.
Yeah.
I (DBD::Ingres) have'nt pitched in as Jonathan voiced my concerns quite precisely, saying: Beware - DBMS are more different than anyone would like. That's why DBI has the scheme it does have - it is flexible but not easily codified.
Even if its not easy a solution for migrating DSN creation out of code and into a config file would be very worthwhile.
Ingres, like Informix and (I think) Oracle, does'nt have the concept of 'host' or 'port', using other ways of adressing remote databases.
Given that for most folks the support is needed for the FOSS databases ignoring the strange proprietary ways would be better than not having DSN's externalized.
It seems to me that you are trying to force an extension onto the DBI based on what a small number of RDBMSs accept.
When that small number just happens to be "all the FOSS databases" its a large enough small number.
The people who want this seem to use only a few DBDs - perhaps it could be added to those?
Maybe.
Personally I'd like to see a solution based on AppConfig. We have our database configs in AppConfig. The config files look something like:
[global] connpriority=dot,skippy,marita dbd=mysql tablespace=finilever user=blah pass=blah
[dot] host=dot.fini.net
[skippy] host=skippy.fini.net user=override pass=override
[marita] host=marita.fini.net dbd=pg
I don't care about Oracle or any of the rest. Making this work with PG and MySQL will solve 90% of the world's problems. I don't see why it couldn't be extended to include whatever parameters where necessary for any of the proprietary databases, but if not could somebody explain how?
-- </chris>
"Fans of Mozilla's free, open-source Firefox browser make the ardent Apple faithful look like a bunch of slackers." - Rebecca Lieb at clickz.com
