Re: [MacPerl] SQL DB

[helene.a@mail.belgavillage.be]

Thanks Brian for all this explanation!
In fact, my wish is to pruchase and install the WWWThreads package 
http://www.wwwthreads.com/   an outstanding board! There's a need of 
a sql backend and that's why I am interested in interfacing MacPerl 
or Perl (on webten) webten, to MySQL.
Thanks to your explanation I am going to see better what's really 
feasable or not on the MacOS platform.

Regards
Helene


>
>>Does anybody succeded in connecting any PERL script to MySQL or another
>>SQL DB?
>
>Yes.
>
>For starters:
>
>http://www.inlink.com/~perlguy/sql/
>
>"Perl has the ability to work directly with just about every, if not
>every, SQL database. Native Perl drivers have been developed for most
>databases, but if you can't find a driver, Perl also has an ODBC driver
>so it can talk to the database if it conforms to the ODBC standard."
>
>http://www.macsql.com/
>
>For information on SQL for the Mac.  Butler SQL has been mentioned in the
>past. However, when Pervasive Sofware bought out Everyware (You'd think I
>make these names up!) the kept Tango, but dumped Butler SQL, and have yet
>to port their own product, PervasiveSQL to the Mac.
>
>I'd say take something like Valentia, which is a fully scriptable
>ODBC/DBMS dataserver, and a copy of Chris Nandor's Mac::Glue, and go for
>it:
>
>Valentia:
>
>http://www.paradigmasoft.com/valentina/valentina.html
>
>Valentia is $50US, but you can pay for it through Kagi as though it was
>sharware (with a key, the downlodable demo becomes the real program).
>
>Mac::Glue
>
>http://pudge.net/macperl/Mac-Glue.html
>
>Also there's a glue file (created by Paul Shaap) on the Valentia site:
>
>http://www.paradigmasoft.com/download.html
>
>That's not a completely free solution, but then technically, neither is
>mySQL (there are situations in which the mySQL folks want payment). 
>Still, Valentia is WICKED fast.  In addition, Valentia is not limited to
>textual data.  You could server Quicktime Movies from it!  Not sure you
>want to do that from MacPerl, however.
>
>Here's an article written last June, at MacCentral, by David L. Hart
>
>http://www.maccentral.com/news/9906/10.hart.shtml
>
>Includes a links to "A free set of Perl scripts for a simple, flat-file
>database, originally written by Brent Michalski and ported to MacPerl..."
>by the author (alas, the link is dead).  Try:
>
>http://hart-mac.sdsc.edu/Cookbook/ch13/13.4.2/index.html
>
>Okay, so that last one is not SQL related.  Sometimes all you need is a
>flat-file database.
>
>HTH
>
>--B
>
>Brian McNett, Webmaster
>*************************************************************
>Mycoinfo. The world's first mycology e-journal.
>http://www.mycoinfo.com/
>*************************************************************
>
>
># ===== Want to unsubscribe from this list?
># ===== Send mail with body "unsubscribe" to macperl-request@macperl.org


# ===== Want to unsubscribe from this list?
# ===== Send mail with body "unsubscribe" to macperl-request@macperl.org