Re: Database events
Re: Database events
- Subject: Re: Database events
- From: Alex Zavatone <email@hidden>
- Date: Thu, 08 Jan 2015 12:20:22 -0500
Care to explain just exactly what your reply of "Sad nonsense" means with regards to this thread?
Which part of the discussion is sad nonsense in your opinion and why?
Sent from my iPad. Please pardon typos.
On Jan 8, 2015, at 11:37 AM, Bruce Robertson <email@hidden> wrote:
> Sad nonsense.
>
> On Jan 8, 2015, at 2:39 AM, has <email@hidden> wrote:
>
>> 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
>
>
> _______________________________________________
> 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
_______________________________________________
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