Re: [MacPerl] Filemaker Pro DB

[Richard Michaud <rmichaud@relaypoint.net>]

Forgive my ignorance, but hasn't anyone attempted to port DBI to the Mac?
Someone could then write a DBD for Filemaker...no?

I guess this would be the hardest to do, but the most familiar interface to
databases.   I just did a Windows Perl project that uses DBD/DBI between
Oracle and Access and it works like a charm!

Regards,

Rick Michaud

> From: Axel Rose <rose@sj.com>
> Date: Wed, 13 Sep 2000 10:38:11 +0200
> To: Chris Nandor <pudge@pobox.com>
> Cc: martijn <martijn@vtip.nl>, <macperl@macperl.org>
> Subject: Re: [MacPerl] Filemaker Pro DB
> 
> Um 17:42 Uhr -0400 12.09.2000, schrieb Chris Nandor:
>> At 23:19 +0200 2000.09.12, Axel Rose wrote:
>>> OTH you may have to struggle with AppleScript or AppleEvents.
>>> It's hard, I know, but is supported and quite fast.
>> 
>> Well, Mac::Glue isn't hard (for the most part).
>> ...
>> 
>> my $finder = new Mac::Glue 'Finder';
>> my $fm = new Mac::Glue 'FileMaker Pro';
>> 
>> $finder->open($finder->obj(file => $file));
>> my $db = $fm->obj(database => 1);
>> my @fields = $fm->get( $fm->prop(name => fields => $db) );
>> my @data = $fm->get( $fm->obj(records => $db) );
>> for my $record (@data) {
>> print join(", ", @$record), "\n";
>> }
> 
> Only speaking for myself:
> It's hard for me. I have to find out which object methods there
> are (obj, get, prop), when to use them and which various parameters
> (name=>fields=>$db, records=>$db, ...) they require.
> This process takes some time even after reading the good documentation.
> Learning get's even harder if you have e.g. a Cumulus database where
> you must experiment.
> 
> Database access from MacPerl would be very handy for CGIs. OTOH MacPerl
> CGIs aren't robust enough for use in a production environment.
> Furthermore they are too slowly if you haven't got a speedup by
> a persistent interpreter process, SpeedyCGI for instance.
> 
> Another question which comes to my mind (offtopic):
> Has anyone on the list successfully used Mac based Java servlets to
> access say FileMaker Pro? WebStar as well as QPQ support Java servlets.
> 
>> I am about ready to release Mac::Glue 1.0.0
> 
> Great news!
> I like the new scheme putting modules on sourceforge.net.
> 
> 
> Have a nice day
> 
> 
> Axel
> 
> 
> # ===== 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