SQL-style analysis in Shortcuts

[jsloat]

@andrew.j.pfeiffer

Scriptable

Unlike Pythonista, Scriptable does have Shortcuts support, although I’m not well-versed in Javascript. For example:

1. Is it possible to load data in CSV format as a two-dimensional array using Javascript in Scriptable?
2. Is it possible to use packages such as JQuery in Scriptable to query data using SQL-like language?

1. Once the file is read in Scriptable you could then display it in a table within Scriptable, or render it as HTML in a WebView, there are a few options, but yes definitely possible.
2. I’ve seen some examples of people using 3rd-party libraries in Scriptable (e.g. here: Use moment.js in Scriptable), but it’s not exactly supported…you’d basically need to get the whole source code for the library and add it to Scriptable. I haven’t really seen jQuery used in this way though.