A bit of philophy about Database events
A bit of philophy about Database events
- Subject: A bit of philophy about Database events
- From: Vittorio <email@hidden>
- Date: Tue, 16 Mar 2010 14:08:07 +0100
I've been working for decades with many SQL-compliant relational databases (MySQL, SQLite, PostgreSQL, to cite a few ) transferring the neat and easy syntax of SQL commands to query the DBs by means of languages as Perl, (Visual) Basic, Pascal.
Now, being an unexperienced novice with Applescript, I'm studying it reading Applescript 1-2-3 and I'm puzzled by some definitions of database and database items in "Database events".
I'm accustomed to consider a database as a collection of tables, a table as a collection of records and records as a collection of fields containing your data. Above all it is always possible to reduce the amount of stored data setting relation up among tables by connecting specific fields.
Now it looks to me that in Applescript a database is only a simple table that you can query but in any case a table. And this even though behind the scene (e.g. in a terminal window issue "sqlite3 dbname") it fragments fields and records into relational tables, indexes them, and connect them.
In a nutshell, for the final user Applescript's database events works like an Excel database.
Am I correct?
Ciao from Rome
Vittorio
_______________________________________________
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