Re: A bit of philophy about Database events
Re: A bit of philophy about Database events
- Subject: Re: A bit of philophy about Database events
- From: Jeff Jungblut <email@hidden>
- Date: Tue, 16 Mar 2010 12:19:03 -0700
- Thread-topic: A bit of philophy about Database events
on 3/16/10 7:27 AM, Vittorio at email@hidden wrote:
> Thanks, Bill and thanks to you and Sal for your manual on Applescript.
> Anyway, for the time being I'm resorting to MySQL3.app and its well done
> applescript support.
I haven't heard of MySQL3.app, do you mean MacSQL? I used to use MacSQL
2.6.3 from 2003-06, but would not recommend it, or MacSQL Framework.
For the apps I develop for work, I use call xmlrpc to send queries to a PHP
script (hosted by a remote web/database server) and get data back as an
AppleScript list of lists. Works great from simple scripts to AppleScript
Studio apps that can show query results in table views. You can run web
sharing with php locally and install mysql locally too, if you only need
local storage.
> To stick to my original question ....
> Is there any plausible reason why SQL support (e.g., thru ODBC which is an
> instrument of MAC OSX too) hasn't been implemented in Applescript, as it was
> in the main computer languages?
No idea why. MacSQL Framework seemed like a great idea and common sense said
the OS ought to have something like it built in, but the implementation had
its weird quirks and limitations. That, and responses to support requests
were usually "fax me an NDA [another one] and try the beta version" or no
response at all.
> And, as a workaround, is it possible in applescript to call programs written
> in other languages such as Perl?
You can use 'do shell script' execute a shell script and get a result back.
--
Jeff Jungblut
email@hidden
Senior Graphic Designer & Web Developer
Uptown Publications
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden