Skip to content
Derek edited this page May 8, 2020 · 5 revisions

News About covid-19-graphql

May 8th

Database has been successfully deployed to AWS (account provided by COVID Relief Coalition), Deployment of GraphQL services using Fargate on AWS is the next step.

COVID Relief Coalition

Nice [article](https://markets.businessinsider.com/news/stocks/vocareum-joins-forces-with-gcrc-aws-nih-and-cornell-at-the-global-covid-19-relief-coalition-hackathon-2020-1029097319_ about the Coalition and Vocareum

Stanford has invited us to participate in the Coalition, and is paying for hosting the service on AWS. Our goal is to have the service live the week of May 10th.

Our page on The Coalition's site https://collective.round.glass/covid-graphql/about

We will be restricting access initially with an API key, send us a request in issues and we will get back to you with details. Longer term we will be allowing anyone that can authenticate with OAuth (e.g. Github or Google).

Status of Data

Data from Johns Hopkins, Apple Mobility, and Google is now in the repo. This data will be updated daily, but you can also run the data loaders found in the '/process-data' folders. The SQL scripts for loading the data can be found in the '/init' folders under 'db', 'google-mobility-db', and 'apple-mobility-data.db', these are updated when the data loaders are run, e.g. 'from google-mobility-db/process-data/' run: 'node simpleSqlCreate.js'. See the README for examples of running psql command line to load the data. The shape of the Google and Apple data is different for now, so if you think that the queries are different for each of those services then you would be correct.

Federation

We are using Apollo Federation services, this will be available in the same time frame as the deployment to AWS. There will be three backing services initially, Johns Hopkins Data, Google Mobility Data, Apple Mobility Data

Repo Will Be Moving

This Repo will be moving to the foundobjx github repo soon. This is to take advantage of the features available by using GitHub organizations. I will put a note on the top of this repo's README when we make the switch.

Clone this wiki locally