Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

If you want to run GraphQL queries against this kind of data I have a roundabout way of doing it:

1. Set up a repo that uses actions to scrape data into a CSV

2. Set up another action that converts that CSV to SQLite (using my sqlite-utils tool) and then...

3. Publishes that database to Cloud Run or Vercel with Datasette and with the datasette-graphql plugin

Here's an example repo that does exactly that: https://github.com/simonw/cdc-vaccination-history

It scrapes vaccination data from the CDC, complies that into a SQLite database and publishes it using Datasette on Vercel at https://cdc-vaccination-history.datasette.io/

Then you can run GraphQL queries at https://cdc-vaccination-history.datasette.io/graphql

(Here's the plugin: https://datasette.io/plugins/datasette-graphql)

Another demo: https://covid-19.datasettes.com/graphql runs from this repo: https://github.com/simonw/covid-19-datasette



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: