[Fwd: Pand-Aid help - PostgresSQL help for Covid-19 project]
---------- Forwarded message ---------
From: Brianna Harris <[hidden email]>
Date: Tue, Mar 17, 2020 at 3:20 PM
Subject: Pand-Aid help - PostgresSQL help for Covid-19 project
To: Sheri Dover <[hidden email]>
Hello Sheri, if you can forward on the message below to the PostgresSQL
folks, I would really appreciate it.
Hello beautiful people. I have an announcement in regards to covid-19 in
our community. I am currently working with a group of Non-profit
organizations and Arielle (the head of the Covid-19 response team at OHSU)
to develop a simple tool to aid in mitigating the spread of covid-19 among
our most vulnerable populations.
It is in the design phase right now, so input is extremely important as
this is the easiest time in its life-cycle to adjust its functionality.
Currently what the tool is being designed to do is this:
1) It aggregates the supply needs of immunocompromised and elderly
individuals and places them in a secure central database.
2) It allows for NPOs, medical facilities, and government bodies to filter
and "checkout" groups of individuals based on things like need and
3) Once a need is met, that need is checked off, a confirmation email sent
to the at risk individual (just in case they were mistakenly removed) and
that particular need is removed from any and all instances in the database.
In addition to the above the web-app will provide guidelines supported by
our best professionals on how to train volunteers in pick up and delivery
of items in order to reduce risk of accidental exposure as much as
On the client side there will be information on steps individuals can take
to maintain their own safety as well as emergency phone numbers and other
This tool is meant to allow multiple organizations to spread the workload
of responding to our vulnerable populations in an organized fashion and
avoid duplication of work. In addition it aims to maintain health safety
standards that may be difficult to train for in a purely volunteer "sign up
sheet" type format (for example, people in need post their need and
In future releases we hope to also offer self reporting of illness to help
gather data on the possible spread of Covid-19 beyond what is currently
available with tests alone.
To read more about it please go over to the README.md file on our github
1. I need feedback. This app is going to have a fast turnaround, so this is
our chance to get the groundwork laid out correctly for future more complex
versions even if the first version is very simple. Getting the data
structure right from the get-go is invaluable.
2. I need help. I am not an expert in databases or designing them. Even if
you are not an expert, there is a good chance that you know more than me.
Please consider joining our hack-a-thon or submitting commits on github.
To join our team, leave feedback, or even just keep up with current
developments you can join our slack here: