Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things


by belg4mit (Prior)
on Jun 12, 2002 at 23:50 UTC ( #174068=note: print w/replies, xml ) Need Help??

in reply to EZDBI

Thanks Juerd. I asked Juerd to take a second look at the module as he had been one of the most vocal critics. Many of the criticisms prompted me to add several the features I have. I asked if he might review the module while re-viewing the module, as I hoped it would gain additional exposure, code review, and prodding :-D

A few clarifications...

As far as ? this is all handled in the private _substitute function. It does a bit more than just expand ??L, but yes the wording of the documentation does "take credit" for the actual placeholder substitution done by DBI. I believe the intent here was to not provide the user with more information than they needed to know, I will look into rewording it to keep the details hidden but not take undue credit.

You don't actually *have* to use Use to handle multiple databases, you can actually just write the appropriate SQL e.g. Select('From BAR.barfle') even though you are "Connected" to FOO. This is just a convenience function in this case, and should probably be clarified. It is actually more pertinent to connecting to multiple RDBMS, say on hosts fred and barney. At which point I think there will be lots of context switching no matter what interface you use.

There is a currently undocumented "feature"/side-effect that I have been wondering if I should in fact document. It is the fact that the object returned by Connect and passed to Use is in fact the DBI object. I am not sure if this could be useful information...

UPDATE: I have addressed your documentation concerns, as well as fixed a compile-time error under 5.005 reported by gav^ and just uploaded the result as 0.11 Until it reaches your local CPAN mirror it is available at

perl -pew "s/\b;([mnst])/'$1/g"

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://174068]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (2)
As of 2017-07-21 01:02 GMT
Find Nodes?
    Voting Booth?
    I came, I saw, I ...

    Results (316 votes). Check out past polls.