I'm looking for advice on the best way to build a simple database out of information generated every day from about half a dozen iOS and MacOS apps, mainly about time use. I want to generate a dashboard and trigger some actions based on the data.
I know AppleScript and Keyboard Maestro, and I can use them to do almost everything I want. I can collect the data as I need as CSV or JSON files and load it into lists of records (with dictionaries). As far as I can tell neither Applescript nor KM make it easy to query those records without a lot of repeat loops.
Essentially all I want is a statement like this:
Set DashboardValue to [sum, average, min, max, or count]
of Field A for records where Field B = X and Date is between Y and Z
Is there an easy way to do that in AppleScript or KM? Or is there a tool I can learn just enough of to solve my problem:
- A webapp (Airtable, FireBase, etc.)
- A spreadsheet (Numbers or Excel) or other Mac app.
Other than spreadsheets, I don't have any experience with these other languages or platforms. All of these could solve my problem. Does anyone have a view as to what the most painless path to take?