Re: Database events
Re: Database events
- Subject: Re: Database events
- From: has <email@hidden>
- Date: Thu, 08 Jan 2015 10:39:32 +0000
Axel Luttgens wrote:
> Le 7 janv. 2015 à 16:31, Fred Diepeveen a écrit :
>
>> I'm creating a database that replaces a (fare too) large Excel
spreadsheet. It is slowing down and can handle only one active process
without generating mismatches between sheets.
>>
>> For this I'm learning how the commands in applescript Database
Events work. I got stuck up using this command:
>
>
> Database Events is a bit surprising, yet works rather well and even
proves quite powerful (strictly limited to a single table in a DB
parlance, yet with potentially variable records).
Database Events is not a relational database application [1]. It's a
persistent key-value data store. Or, in nerd parlance, a "NoSQL
database". (The NoSQL movement also has a tradition of badly chosen
names.) It does not have tables, or any other features you would find in
a relational database application (DB schema, query language, stored
procedures, relational integrity, multi-client support, etc.). It's also
right at the shallow end of the NoSQL pool, and really just a toy. If
Excel isn't sufficient for the OP's requirements then Database Events
sure as hell isn't fit for the job.
OS X includes a copy of the free, open-source Postgres relational
database application <http://www.postgresql.org/>, and there are various
free and commercial GUI applications for managing databases, designing
schema, etc. I've used it myself, and it's an excellent piece of kit.
There's a bit of a learning curve to it, but that's to be expected, and
there are tons of Postgres users, documentation, and other resources to
help you get up to speed. If Excel isn't cutting the mustard then the
long-term rewards of teaching yourself some SQL and Postgres essentials
will be totally worth the up-front investment.
If you want to use Postgres directly from AppleScript, the easiest (and
cheapest) way would be to use a third-party ObjC framework like
postgresql-kit, which you can call into via AppleScriptObjC [2]. I've
done that sort of thing in the past, and it's not hard to roll a simple
AS wrapper for connecting to and querying a RDBMS. (OTOH, it'd would be
a total non-brainer if AppleScript's library ecosystem wasn't DOA, since
pre-written libraries for such common tasks would *already* be
available.[3])
Bruce Robertson wrote:
> Life is too short. Get a copy of FileMaker and make all this MUCH
easier and more versatile.
Worst relational database ever. (Seriously, it's a joke; way worse even
than Access.) Even its AppleScript interface is a pile of crap. The only
good thing one can say about FMP is that it includes a relatively nice
GUI form builder, though that's only useful if your database is intended
for standalone use, as opposed to using it from other apps - and since
the OP is asking here I'm assuming their interest is in the latter.
Postgres absolutely mops the floor with it, is already included in OS X,
and is completely free to boot.
HTH
has
[1] Folks sometimes get confused because they hear that DBE uses SQLite
as its backing store. But that's just an internal implementation detail.
[2] Shane Stanley's your go-to guy for any ASOC questions.
[3] "Paging Mr Page..."
_______________________________________________
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