Re: Database from AppleScript
Re: Database from AppleScript
- Subject: Re: Database from AppleScript
- From: has <email@hidden>
- Date: Wed, 16 Jan 2008 17:03:55 +0000
On 16 Jan 2008, at 16:07, T&B wrote:
Hi Has,
Database Events is a simple object database. It's not a relational
database and not intended as a replacement for one. That it happens
to be built on SQLite is merely an implementation detail.
True. It's just unfortunate and misleading that Apple originally
promoted it as a way to "access SQL databases using AppleScript" or
similar
Yeah, the suggestion that DE could access SQLite databases was very
unfortunate.
It would be great to see Apple include a real SQLite scripting
addition,
File alongside all the other things that Apple don't provide as
standard. :p
IMO though, it isn't really an issue as relational databases are a bit
outside the stock AppleScript installation's remit/most
AppleScripters' skill sets. AppleScripters who do use them are likely
to be doing so on a professional basis, so shouldn't have any problem
with purchasing one more commercial third-party solution to go with
all their others.
since SQLite databases are so common now in Mac apps (eg Mail,
Address Book, iCal, Bento, Firefox).
Poking around in applications' private data stores isn't really
something you should be doing, mind you.
there's also a couple of application-based options, e.g. Valentina.
I haven't used Valentia, though am aware of it. I think it uses its
own proprietary database format and requires accessing through the
GUI, so kind of the same boat as FileMaker. I may be wrong.
Not used it either, so you may be right. There are other options as
well though if you want to Google for sql+applescript. For example, I
know that MacSQL can interface with existing SQL databases as I tested
it on PostgreSQL when reviewing Hanaan's book last year, and while its
scripting interface is a little quirky it seems to do the job.
Can't tell you if any of the application-based solutions can run
facelessly though, which I think is the features you [quite
reasonably] want.
although they're pretty common for other languages such as Python,
Ruby, etc.
I've not (yet) tried Python and Ruby.
Worth a look. Only thing they lack compared to AppleScript is good OSA
component support, which is needed for stuff like Mail rules and
folder actions.
One further possibility if you want a free, faceless AppleScript
solution would be to take an existing Python SQL module and use
aemreceive (included in Python appscript 0.18.0) to wrap it as a
scriptable FBA. Not one I've tried myself, although I've used
aemreceive to wrap other Python functionality with some success (e.g.
TextCommands, ParserTools).
has
--
http://appscript.sourceforge.net
http://rb-appscript.rubyforge.org
_______________________________________________
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