Re: Perl and Oracle

From: <xhoster_at_gmail.com>
Date: 10 Apr 2006 17:00:01 GMT
Message-ID: <20060410131134.001$i8@newsreader.com>

Mladen Gogala <gogala_at_sbcglobal.net> wrote:

> You must be aware, however, that Perl DBI driver to work with Oracle is
> extremely bad software which doesn't support things like the array
> interface or direct loads.

Actually, it is very good software which doesn't support things like the array interface or direct loads.

> I asked the author and the only answer was
> that he's not paid for that.

Which is true. Feel free to code those features up and contribute it to the open source community. I'd appreciate it, but I will continue to use DBD::Oracle whether you do that or not.

> Perl cannot be used to load large files into
> the database or download large query results to the file system.

Strangely enough, I've used it for both of those things. Loading files with Perl isn't as fast as doing it with sqlldr, but then again why would you expect it to be? If you want to use sqlldr, use sqlldr. You can even use both, having the ctl point to a fifo for the input data and having Perl write to that fifo.

> DBD::Oracle is a mere toy which works best with tables like SCOTT.EMP. It
> was once stated here that Tim Bunce, the author of Perl is more inclined
> to develop things for open source databases lie Postgres or MySQL then to
> fix the driver for Oracle. I happen to believe that is the case, despite
> the vigorous denial.

What was vigourously denied? Tim Bunce being the author of Perl? Or something else?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB

Received on Mon Apr 10 2006 - 12:00:01 CDT