Re: [MacPerl] SQL DB

[Brian McNett <webmaster@mycoinfo.com>]

 <helene.a@mail.belgavillage.be> wrote:

>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