Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Monday February 11, 2002
10:45 AM

dbi-proxy is cool

[ #2774 ]
Since we can never rely on sys-admins for anything around here, it becomes a pain to get them to install anything. I wouldn't even bother trying to get them to install the Oracle client software, so I decided to give DBI::Proxy a try.

After a couple minor glitches with the tnsnames.ora and sqlnet.ora file, I got it running. Pick a port number, start the proxy server. Then, connect from the client machine using that port as a connection, and perform queries at will. No Oracle client software required!

That is so damned cool! I feel like Calvin after he's been given an allowance...

WEALTH...POWER...BWA, HA, HA!

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I gave up asking my sysadmin to install perl modules so I install them myself in a "non-standard" dir and just do a use lib at the beginning of my progs. Not that there is anything wrong with my sysadmin, it's just the whole performance you have to go through to get anything done (i.e create a trouble ticket etc...) is such a pain.

    I like instant gratification :)
    • Yeah, for dev.perl.org [macperl.org] I took to installing all my opwn perl modules for the web services, and access them also via shell services (using PERL5LIB or whatever), and set up CPAN::Config to install things in the right directories, etc. It makes it much easier.
      • We did manage to get a separate, generic user account on most of the machines we needed (in some cases direct login, in some cases sudo).

        Given that, we decided to take it a step further and install our own local version of Perl, not just the modules, on each of the machines. This saved us the hassle of begging for an upgrade if we wanted it, and we don't have to deal with any of the 'use lib' business - it's all under our generic user's home directory.

        It's a little more work on our end to make sure all