AppleScript Help - Need Simple Database

I would use a sqlite database. I would have id's associated with your different 'states' (i.e. person 1 is home, ent center is on, etc) and then associate the time stamps to those ids and filter them. You can use 'do shell script' to run all sqlite3 queries thru the shell.

 

Applescript has decent XML and plist managing ability. You should be able to use XMLs and plists to store your data, and call it when needed. I have not used Applescript with XMLs much, but I know it's pretty capable.

Another option is using properties. Not sure if you know about them or not, but you can use them to store variables persistently, till re-saving the script. For example:

Code:

property x : 0

x will always equal zero now each time the script runs, however, if I do something like:

Code:

property x : 0
set x to 5

Now the x property's data changes to 5, and is saved to disk. Not sure if I'm being clear enough, but this is generally how I manage data I want to be persistent.

So in your case you could type:

Code:

property EntertainmentSystemON : false

Now if your code changes this to true, next time you run the script, it'll remember the value. The issue with properties is, like I said, it'll forget the values once you re-save the script, so if you want completely persistent data, use XMLs or plists. XMLs and plists also allow you to create entire databases, so that's probably what you're looking for. Plists are a kind of XML, so you should be fine with either.