Re: [MacPerl] Are there any SQL DBI's for Mac & NT?

[Tom Cloney <muse@viadoc.com>]

>mark wrote:
>>I believe there is Oracle for the Mac.  I also think there
>>is an SQL.pm on CPAN.

Yes, there is full ORACLE for the Mac. Version 7 has been available for
some time. Yes, it is expensive. There is a generic ORACLE/Perl interface
called oraperl floating around somewhere on the net. The basic database
isn't too pricey, but the doo-dads you'll probably want to add on to create
a full development environment will eventually set you back around $4-5k.
On the other hand, it _is_ a very fast, robust, industrial-strength
database with a learning curve that makes 4D look like FileMaker. Another
interesting SQL alternative for the Mac is ButlerSQL.  Peter Chen
(petechen@math.rutgers.edu) developed a ButlerSQL interface called Butperl
back in 96.

If you don't need binary speed, a crude, but effective interface can be
created by using AppleEvents to send SQL commands from MacPerl to SQL*DBA
or SQL*Plus (text-oriented ORACLE front ends). I've done the same thing
from Tcl.


>I don't really care about having a SQL front-end on the Mac; I just want
>to be able to create and access "straight" SQL files through Perl.  I'm
>starting to sense that there is no way to do this.  Anyone know if this is
>correct?

What do you mean by "accessing" SQL files? SQL is plain ASCII source code
containing database commands. The data itself lives in files whose format
is proprietary by nature. Perl is perfectly suited to generating and
parsing SQL files in all sorts of ways.

-Tom

________________
Tom Cloney
Under-Assistant West Coast Promotion Man
Viadoc
muse@viadoc.com  muse@csn.org Phone/Fax (508) 385-8840
World Wide Web -- http://www.viadoc.com/muse/public_html/tchome.html

Boom jacka lacka lacka, boom jacka lacka lacka...
+===============



***** Want to unsubscribe from this list?
***** Send mail with body "unsubscribe" to mac-perl-request@iis.ee.ethz.ch