![]() I do not use SQLite enough to be an expert at all. DB Browser for SQLite and TablePlus are other free (at least at the start) applications. SetApp comes with SQLPro for SQLite which I have used and seems fine. ![]() If I wanted to use SQLite, how do I get that set up on the Mac? What program do i run? How do I automatically add data and then query the results? ![]() I'm indifferent between Numbers, Excel and Google Sheets.ĭo you have a sense of which would do what I needed best? Does anyone have a view as to what the most painless path to take? Other than spreadsheets, I don't have any experience with these other languages or platforms. A spreadsheet (Numbers or Excel) or other Mac app.A scripting language (JavaScript, Python, etc.).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: Of Field A for records where Field B = X and Date is between Y and Z As far as I can tell neither Applescript nor KM make it easy to query those records without a lot of repeat loops.Įssentially all I want is a statement like this: I can collect the data as I need as CSV or JSON files and load it into lists of records (with dictionaries). I know AppleScript and Keyboard Maestro, and I can use them to do almost everything I want. I want to generate a dashboard and trigger some actions based on the data. 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.
0 Comments
Leave a Reply. |