• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Database from AppleScript
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database from AppleScript


  • Subject: Re: Database from AppleScript
  • From: "Gary (Lists)" <email@hidden>
  • Date: Wed, 16 Jan 2008 23:05:47 -0500
  • Thread-topic: Database from AppleScript

"David Crowe" wrote:

> Kevin;
>
> Can't FMP interface quite nicely with SQL databases now, especially
> in version 9 (which I've only read about, I'm still on 8).

Yes, it can.  There are a number of 'bridge' tools out there for that
purpose.  In fact, for quite a few years there has been a FM database that
holds the bridge scripts, and one just implements that in their own database
set.

A quick google will yield useful results.

> Are there SQL databases that have as efficient a development
> environment as FMP, especially on the development of a nice user
> interface?

That's the best thing going for FM, I think.  I just wish more folks had the
software.  For my own usage, I often use FM to make interfaces for my own
AppleScripts, because it's much faster than Smile or other AS interface
builders.

Even if I don't need more than the single record to use as an interface,
it's just really fast to build an AS application that is driven my FM.

I don't know of anything that is equivalent for SQL, but I will predict that
the tighter integration of SQLite since mid-era OS X versions will yield
some such tools.

There are, of course, very excellent applications to interact with an
existing SQL installation, which I find very useful for Apache + SQL web
site testing locally.

For example, I use:

    MySQL Administrator
    MySQL Query Browser
    Your SQL

These are not UI's for a database, but a UI to interact with the SQL files
themselves: creating a new DB, examining tables, setting permissions, etc.
These are basically like the standard PHP-based SQL manager "phpMyAdmin",
which is pretty ubiquitous on web hosts.

The above tools are much faster, as they are desktop applications.

--
Gary


 _______________________________________________
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

References: 
 >re: Database from AppleScript (From: David Crowe <email@hidden>)

  • Prev by Date: Re: Get only the name of the file, instead of the whole path!
  • Next by Date: Re: Obfuscations and little white lies
  • Previous by thread: re: Database from AppleScript
  • Next by thread: Obfuscations and little white lies
  • Index(es):
    • Date
    • Thread