plan switch to Postgres from Oracle

[jcschaff]

Motivation:

• In order to run most of VCell as a cloud hosted service (with local SLURM - and local file system), we need to be able to host our database in the cloud (and this is a very good time to remove dependency on Oracle). Cloud providers can host a bulletproof instance of Postgres with backups, encryption, monitoring, etc.
• for open source viability, we cannot require others to purchase Oracle in order to run vcell.
• end-to-end testing in CI a local Postgres can be the database, mockslurm for running simulations, etc.

Current status: running CompareDatabaseSchema.java indicates that the VCell software and the VCell database (oracle) are still in sync.

Next steps:

1. Build a standalone Postgres database (in UCHC cluster ... and on local laptop for dev) and populate with a fresh database - and test vcell locally.
2. Deploy an "Alpha" docker swarm which points to Postgres and test
3. Development/Proof of concept

• Migrate data from existing Oracle to internal/private Postgres instance and test again (but Oracle remains authoritative).
• create a test deployment for Postgres and exercise at scale (push it with math testing framework)

4. Release plan

• release and deploy Postgres-capable vcell software on both Release and Beta sites.
• approve final migration and shutdown Oracle and restart all vcell services pointing toward new authoritative Postgres instance.

[jcschaff]

FYI: @moraru @CodeByDrescher @danv61

[jcschaff]

This issue needs to be broken down into bite-sized pieces to schedule the work

[jcschaff]

closing this issue, moving plan to new Epic (#1032)