Re^2: Cygwin vs. Active State Perl Install

Most of our batches read and/or update Oracle data warehouse tables (this is an insurance company), and produce reports for the accountants, policy producers, executives, etc.. For example, one batch produces a list of clients to whom lapse notices need to be sent; another produces billing statements.

Comment on Re^2: Cygwin vs. Active State Perl Install

Replies are listed 'Best First'.
Re^3: Cygwin vs. Active State Perl Install by Asim (Hermit) on Apr 24, 2006 at 22:21 UTC
Ah, OK. I've never worked w/Oracle via Perl, however it's one of the strongly-supported DBs, usually via the DBD::Oracle module and it's "descendants". A quick check with my local Activestate install (w/the latest version) vs. the CPAN Search Site shows the ActiveState PPM versions of Oracle modules are up-to-date, so you should be great there! If I might offer two pieces of advice? Once you feel solid with basic Perl, I'd recommend starting with Programming the Perl DBI -- I wish I still had my copy! After that, and if you're looking to build a really strong toolset, Perl has developed some powerful tools for making code-based database queries really simple. I'd recommend learning a tool like Class::DBI or DBIx::Class; it's heavy at the beginning for a beginner, but you'll eventually be able to write very simple code in a "robust" fashion to do your queries. I hope that helps you guys out! Good luck! ----Asim, known to some as Woodrow.	[reply]
Re^3: Cygwin vs. Active State Perl Install by poqui (Deacon) on Apr 25, 2006 at 18:35 UTC
We use Oracle here and I am one a very few perlers at my company; but I used Active State and very successfully, so much so that I convinced my Sysadmin to install the oracle DBD and DBI on our sun box. Cygwin on the other hand is much more difficult to get working, and I never did manage to get the DBI on it.	[reply]