Update usage instructions on showcase page

[anuveyatsu]

Usage instructions from various softwares are now seems not working due to massive changes in the backend. We want to update them so users can still follow those instructions.

Acceptance criteria

• All instructions on showcase page are upto date and working

Tasks

• Update R instructions
• Updates Pandas instructions
• Update Python instructions
• Update SQL instructions
  • copy the code from current instruction (from datahu.io showcase page) and update so that it works on your local machine
• Update JS instructions according to data.js library

Analysis

R/Pandas/Python/SQL:

Check if we're using correct path when reading a datapackage, e.g., for R:

datapackage <- datapkg_read("https://pkgstore.datahub.io/f512ef8d39ada702fde60efe1ca59c17/farm-survey/latest")

and update the dataset path with actual working one.

Javascript:

Options:

1. Update instrucitons with usage of data.js library instead of datapackage-js
2. We're using datapackage-js lib of version 0.8.1. We need to update instructions with usage of v1.

[Mikanebu]

There are 2 libraries for R None of them are useful:

• https://github.com/ropenscilabs/datapkg is outdated - CAN NOT USE
• Second library - https://github.com/okgreece/datapackage-r - No Instructions provided for users.

Possible solutions:

• Ask okgreece folks to provide instructions and update our instructions appropriately
• Read code and understand how it works and provide instructions for ourselves
• Forget about R and do not display it on showcase page

Ans: For now let's ask for instructions

• Python example is updated with new version [email protected] and working
• Panadas is working without modifications
• Javascript is working fine
• Sqlite needs refac toring as they use Package.save for similar operation
• we do not support a PHP

[anuveyatsu]

UPDATE:

• SQL instructions are broken
• we now also have Ruby and PHP instructions:
  • Ruby is tested but PHP is not
  • we need to add them into the site once both are tested

[rufuspollock]

@Mikanebu @anuveyatsu can you guys get this complete - or leave out the SQL instructions for now (and open a special issue just for that).

[anuveyatsu]

FIXED

• updated R, Python, Pandas, JS instructions
• we've removed SQL instructions as it is not working atm - Fix and add SQL instructions #124
• added new instructions re Ruby
• didn't add PHP instructions as upstream library is out of date