search

Haiti-Distributed-Healthcare-System / hdhs

Haiti Distributed Healthcare System
3 stars 0 forks source link

Investigate hosting a PostgreSQL server within the college #26

Closed bmitchinson closed 4 years ago

abpwrs commented 4 years ago

Email sent on 2020/01/25

Hello,

My name is Alex Powers, and I am a senior in electrical and computer engineering. 
As a part of our senior design project, it would be helpful for us to have a central PostgreSQL server that all of our team could share. 
Would engineering computer services be able to host this for us?

Kind regards,
Alex
abpwrs commented 4 years ago

Response received on: 2020/01/26

Alex,

We can probably do something like that, but will need more details:
1) what level of service do you need? (specifically, do you need just a few
schema within an existing server, a whole server just for your use, etc).
2) what level of access do you need? (spefically will the clients be only
on-campus or will the server need to allow connections from any place in the
world?)
3) what user authentication is needed? (will it be just a few specific
hard-coded identities that will be used or will it need to be open to HawkID
authentication for an arbitrary number of students?)
4) what level of resources will it need? (IE just a few dozen MB of data or 10's
of GBs of data)

It would be helpful if you can have your advisor/instructor sign off on this
request, so we can have some responsible faculty/staff sponsor on record.
abpwrs commented 4 years ago

We will likely need the following:

  1. A whole server where we can freely create and destroy schemas
  2. Access to the server from off-campus
  3. Access only for our team (5 total people)
  4. Not more than 15GB of storage
bmitchinson commented 4 years ago

Depending on how the email goes to get a Postgres Server hosted on campus, I’ve used linode through work, and it’s great. Simple simple pricing, really really cheap cloud linux box that you get full access to.

image

I realize storing data on the university server would be “safer” for patient records though. SSD would be slick too not sure if the university offers that.

Linode on the other hand would just give us full root access to everything on the “machine”, and if we could do the whole thing in a docker container, maybe at the end of the semester we could end up putting it on that raspberry pi like device. if it’s already containerized.

Would have to look into just using PostgreSQL with native level of encryption, which i feel like we should do anyway -> Haiti-Distributed-Healthcare-System/hdhs#25

abpwrs commented 4 years ago

Follow up email sent: 2020/02/12

Just following up on the PostgreSQL hosting. Is what we are looking for feasible? 
If so, do you have a time estimate for when this hosting could be live?

If we don't hear anything soon we should pursue Linode as our centralized PostgreSQL hosting.

bmitchinson commented 4 years ago

Appreciate the follow up, having a university hosted solution would be a good option to have.

Personally, I'd still prefer linode so that we can spin up a production version of our existing docker container. Seems like PostgreSQL with them would require a lot of back and forth anyway as we need changes made.

zainakh commented 4 years ago

Reached out to Dave at ECS to tell him that we no longer need it.