This repository is a collection of custom commands that I found useful for working with OWID data. It is mostly written for myself and other OWID staff members but since much of our tools are open, they should be useable by members of the public to a significant degree.
To use these tools you need a recent version of Nushell installed (version 0.86 or higher at the time of writing this). Then load the scripts in the owid subfolder of this repo as an overlay like this:
use /path/to/owid-nushell/owid
or as an overlay (to easily get rid of it via "overlay hide")
overlay use --prefix /path/to/owid-nushell/owid
The commands all have tab complection and help texts, so just type owid and hit to see what the available commands are or browse the source.
If you use the overlay use version, then all the commands are in scope as an overlay - you can then hide all owid commands again with overlay hide.
If you want to save yourself some typing then the aliases might be useful. To use them do the following:
source /path/to/owid-nushell/aliases.nu
The you can access all commands by mnemonics that use the first letter per level, e.g. owid api metadata becomes oam
Using this requires the mysqlsh tool installed. Get in on the mac with brew install mysql-shell. Then add/edit a file in ~/.my.cnf to put in the credential options (use owid mysql profiles list). You can add as many [client-] sections as you like to quickly switch between multiple mysql servers. For production, please make sure to use a read only account :)
[client]
user = grapher
password = grapher
host = localhost
port = 3307
database = grapher
[client-prod-ro]
user = ***
password = ***
host = owid-live-db
port = 3306
database = live_grapher
[client-local]
user = grapher
password = grapher
host = localhost
port = 3307
database = grapher