3 ms·
Reminds me of datasette, which does similar things for SQLite (and much more, too). Docs at https://docs.datasette.io/en/stable/json_api.html https://docs.data
by nattaylor 4y ago
Reminds me of datasette, which does similar things for SQLite (and much more, too). Docs at https://docs.datasette.io/en/stable/json_api.html https://docs.datasette.io/en/stable/json_api.html
Example: Retrieve JSON for https://fivethirtyeight.datasettes.com/polls/president_primary_polls https://fivethirtyeight.datasettes.com/polls/president_prima... simply with https://covid-19.datasettes.com/covid/ny_times_us_counties.json?state__exact=Texas&_sort_desc=date https://covid-19.datasettes.com/covid/ny_times_us_counties.j... (I added a filter for Texas)
- bmn__ 4y agoBig problems with the design of the response here, too. Example: https://fivethirtyeight.datasettes.com/polls/president_primary_polls.json https://fivethirtyeight.datasettes.com/polls/president_prima... The schema is ad-hoc and requires a human to interpret it. Link relations (at the bottom) are expressed the wrong way: a machine could understand the "next" or "license" relations, but not an arbitrary "next_url" or "license_url" JSON key. Recommendation: adopt relevant IETF/IANA standards and reformulate the response to take advantage of them.