in reply to Re: Re: Re: Re: DBX offers simplified access to the DBI
in thread DBX offers simplified access to the DBI

I don't see how this is any different from the DBI. With the DBI, you change part of the connection string.

Yes, and you can change the connect string without modifying the program, by pulling the connect string out of a configuration file, an environment variable, etc. That is, you can switch databases without having to reach into your code to change a statement.

  • Comment on Re: Re: Re: Re: Re: DBX offers simplified access to the DBI

Replies are listed 'Best First'.
Re^n: DBX offers simplified access to the DBI
by ChemBoy (Priest) on Feb 19, 2003 at 05:58 UTC
    That is, you can switch databases without having to reach into your code to change a statement.

    I think batkins was getting at the same point that I'm about to make, but I'm not entirely sure, and I think there's some terminological disagreement, to boot. So to amplify a bit, what he's (probably) terming a symbolic reference, I think I'd call dynamic method selection, and it does, in fact, answer your concern (though it also occasionally gives me the heebie-jeebies). Since method lookup (and loading) are done at 'run-time' (an admittedly blurry distinction) you can do something like the following:

    use XML::Simple ':strict'; # since example code doesn't have # backward-compatibility issues use DBX; use strict; # of course! use warnings; my $config = XMLin "config.xml"; # XML left as an exercise to the re +ader my $driver = $config->{driver}; my $connstr = $config->{connection_string}; my $SQL = $config->{query}; my $conn = DBX->$driver($connstr, "", ""); my $rs = $conn->query($SQL); while($rs) { print $rs->field("client") . "\n"; $rs->field("client", "test"); $rs->move_next; }

    This does not, of course, prove that you can do anything with DBX that you can't do with DBI--to do that, I'd have to know something about DBX, and have used DBI more than twice. But it's all I have to offer, so I hope it sheds a little light. :-)



    If God had meant us to fly, he would *never* have given us the railroads.
        --Michael Flanders

      So to amplify a bit, what he's (probably) terming a symbolic reference, I think I'd call dynamic method selection, and it does, in fact, answer your concern.

      Actually, that would raise a separate concern. Now, to protect myself against bogus stuff coming out of a config file, I have to wrap code in an eval block. And even then I'm not guaranteed that what comes out of the config file won't be the name of some method in DBX that I don't want to call.

        Actually, the DBX package doesn't contain any methods. So you can ONLY use it to initiate a connection.
Re: Re: Re: Re: Re: Re: DBX offers simplified access to the DBI
by batkins (Chaplain) on Feb 19, 2003 at 05:07 UTC
    OK, I can sort of see what you're saying. You could still use a symbolic reference with the DBX, though, if you really insist on changing database drivers based on a configuration file.