search

COHHIO / ryha

R Shiny app for analyzing COHHIO Youth Homelessness Data
GNU Affero General Public License v3.0
8 stars 1 forks source link

Spin down old database #82

Open mthomas-ketchbrook opened 10 months ago

mthomas-ketchbrook commented 10 months ago

With the successful migration to the new database (containing the new HMIS specification), there is no need to have the "old" database still running.

We could save the database tables as a list of data frames saved to an .rds file locally, or save the data to another file format that COHHIO prefer. Then we can spin down the "old" database.

mthomas-ketchbrook commented 6 months ago

There's no need to do this at the moment. The PostgreSQL database server can have multiple databases on the node. We do not appear to be approaching any storage limitations, and the existence of the old database does not appear to be affecting the performance of the app when querying the new database.

mthomas-ketchbrook commented 5 months ago

An .RDS file was created by reading each table in the ryha PostgreSQL database and storing the resultant data frames (1 for each table in the database) in a list object. It may now make sense to spin down the old PostgreSQL database.