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
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