Pull the LCBO REST API into a ~200MB sqlite database. Originally intended to be used to figure out the least expensive volume of ethanol at a specific location, but can be used to explore other interesting correlations.
- Linux, MacOS, or WSL under Windows.
- nix
Open a shell with the dependencies.
$ nix-shellScrape api.lcbo.com into a sqlite database, as defined in .env.
$ bin/fetch all # Takes about 1hr
$ bin/tune-dbOptionally, explore the data with metabase
$ metabase- Most represented country, alcohol, etc by total volume, price adjusted, etc.
- Wine vs Beer popularity
- Geographic distributions