Epic: migrate to postgresql

[jcschaff]

Motivation:

• Enable Cloud Hosting of VCell: In order to run most of VCell as a cloud hosted service (with local SLURM - and possibly a 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.
• Third party hosting: for open source viability, we cannot require others to purchase Oracle in order to run vcell.
• Integration Testing: end-to-end testing in CI a local Postgres can be the database, mockslurm for running simulations, etc.

Completion criteria

• UCHC instances of VCell use PostgreSQL database only.
• cloud hosted PostgreSQL is out of scope of this Epic.

Tasks

• Oracle schema synch to prep for Postgres #271 8/25/2022
• update vcell database access code to support Oracle and Postgres #548 11/7/2022
• more Postgres compatible database syntax changes. #583 11/18/2022
• plan switch to Postgres from Oracle #232
• fix DatabaseConstraint exceptions upon DB Cleanup and pathological Biomodel saves. #840
• configure local Postgres database with VCell schema for development
• install production Postgres database in UCHC cluster with VCell schema.
• develop oracle to postgresql data migration and backup scripts #172
• final data migration and deploy to Alpha and Release sites.