Re: Querying an SQL database
Re: Querying an SQL database
- Subject: Re: Querying an SQL database
- From: webguide <email@hidden>
- Date: Thu, 24 Apr 2003 09:40:23 +1000
G'day Steve
>
Are there any tools or tricks available that I can use to get
>
AppleScript (or AS Studio) to query a mySQL database running on an OS X
>
Server from OS X Client machine?
I have a few Applescripts here that run queries against a MySQL db. I do it
by telling the Terminal to run the query. There's probably more direct ways
but this was the first thing I tried and it worked so I never bothered
trying to alter it. Co-incidentally, we use it for moving data from FMP to
MySQL for web serving.
>
I am currently working for a company that uses FileMaker for everything
>
except accounting and making the tea. FileMaker isn't the problem; the
>
problem comes from the volume of data and the fact that a lot of the
>
data is replicated - if it's changed in one place it has to be manually
>
changed in all the other places. I thought a nice, relational mySQL
>
database with an ASS front end would do the trick but I am unable to
>
find a way to connect the two.
Unless you have a good reason for wanting to change it to MySQL I can't see
why you'd write completely new databases and a new front end in ASS.
Wouldn't the best thing be to fix the problems with the FMP files? Sounds
like they're poorly designed and need normalising.
There is a new product out that is supposed to assist migrating FMP->MySQL
but I haven't used it and have no idea if it is any good. It's here
http://www.dotcomsolutionsinc.net/products/fmpro_migrator/index.html
But I still believe you should be fixing the FMP rather than trying to
rewrite it.
Oh, another option would be Servoy (www.servoy.com) which is somewhat
similar to FMP but uses SQL databases as a backend and javascript as its
scripting language
Cheers
Kim
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.