This is a general AppleScript question, not specifically SD.
I have a huge file that I work with on a weekly basis that has every movie that’s airing on TV for an entire week.
We currently breakout sublists based on information contained in the date for each movie (year it was released; critic’s ratings, 1 thru 4 stars; a list of channels).
We also do a simple lookup to breakout any movie that was a top ten box office hit the year it was released.
Now we want to add another lookup to breakout any movie that won an academy award or Emmy for best picture; actor/actress; director.
It’s a good size database that includes the winners. (About 100 years for Oscars; 50 years or so for emmys). I can easily get the data, but I’m wondering what’s the most efficient and portable way to manage the lookup.
(For box office hits the list is stored in a text file)
I use Database Events with appleScript for some things and I’m wondering if that might be a better, faster way. Basically I have to lookup each title based on the title and year and if it’s in the list of winners, extract which category and and the names of who won.
Also, twice a year I need to be able to fairly easily update the database with a new list of winners.
Is there a big difference between Data Base Events and SQL Lite Libraries? Is one better, faster, more scriptable than the other?