API to help make public data easier to access. Idea started with need for King County, WA COVID-19 data in API format while only having an excel file for source data.
I am using Postgresql for the datastore due to what I read about concurrancy over mysql, figured that would be good for an API. During development using a container on my machine.
docker run --rm --name pg-docker -e POSTGRES_PASSWORD=postgres -d -p 5432:5432 -v $HOME/docker/volumes/postgres:/var/lib/postgresql/data postgres:11
You can use this command to connect to the postgresql instance in the container.
docker ps # to find the CONTAINER ID docker exec -it 05b3a3471f6f bash
From the shell login to the db and setup initial user and database
psql -U postgres
Create your creds.py from the creds_sample.py
cp creds_sample.py creds.py
Edit creds.py with correct info for your db.
More info coming soon on using the scripts in database/ to create tables and load them with data.
Project is using Python 3.7
In the project we use pipenv when developing.
pipenv install && pipenv shell
When running on Debian server libpq-dev is required, this is postgresl library.
sudo apt-get install libpq-dev