oceanpoy.blogg.se - Database for apple mac

#Database for apple mac free#
#Database for apple mac mac#

#Database for apple mac free#

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.

#Database for apple mac mac#

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.