Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: talking to external MySQL servers

Hi,
Taking a different tack I do this by putting a Web Service wrapper round the MySQL database (having previously come up against the same client install issue). There is Web Service client functionality in Applescript which is basic but workable and easy to code.
The slightly harder part is the Web Service front end, I use WebObjects' Direct-to-Web function which is a bit of a learning curve but once you've mastered the basics it is pretty simple (even for an amateur like me). The nice part is that you get to use the WO Enterprise Objects Modeler which is a good place to deal with business logic. The problem is that I am unclear about the future of Direct-to-Web Services development in Leopard and beyond.
That's just a suggestion, you may be able to find a Web Services implementation in a development platform you are comfortable with, it is certainly a neat way to solve the problem at the client end.
Regards,
Gordon.


Gordon Maynard
mobile: 07 970 638 415
email: email@hidden
AIM: maynardaim
Jabber: email@hidden

On 14 Jun 2007, at 13:03, Håvard Graudo wrote:

Thank you,

This is doable locally, but AFAIK it require a separate installation of mysql. That counts to 40 MB, with (at least) two different PPC/intel binaries. This makes distribution of scripts cubersome.

I was hoping for something small enough to include in the script bundle or installed by 10.4 default.

Håvard



Den 14. jun. 2007 kl. 12.50 skrev Rainer Lau:

I use somethings like this

do shell script "mysql -h 192.168.0.28 -u user -ppassword -D mdjbuchhaltung -e 'INSERT INTO kostenstellen VALUES( " & mdj_buha & "," & mdj_jahr & "," & mdj_kuerzel & "," & mdj_kst & "," & mdj_projname & ", \"\", \"\", \"\", \"\", \"\", \"\", \"\");'"


--

Rainer



Am 14.06.2007 um 08:14 schrieb Håvard Graudo:

Are there any good tools that will let my scripts run simple SQL-queries to external mySQL databases?

It should preferably be free (or cheap), small and in the form of an OSAX, a faceless background app, or a command line app.
Small enough to be embedded in a script bundle if necessary.

I am still using MySQL Bridge for this. (it is perfect, but old and discontinued - but still works for me)
(http://lestang.org/osax/mysql/  note: it has neither been updated nor tested for years)

At some point I would need a replacement. Any advice?

Håvard

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/applescript-users/email@hidden
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
References: 
 >talking to external MySQL servers (From: Håvard Graudo <email@hidden>)
 >Re: talking to external MySQL servers (From: Rainer Lau <email@hidden>)
 >Re: talking to external MySQL servers (From: Håvard Graudo <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.