search

dathere / covid19-time-series-utilities

several utilities to help wrangle COVID-19 data into a time-series format
Creative Commons Attribution Share Alike 4.0 International
34 stars 8 forks source link

Generalize DDL for better security #3

Closed jqnatividad closed 4 years ago

jqnatividad commented 4 years ago
jqnatividad commented 4 years ago

https://github.com/dathere/covid19-time-series-utilities/commit/a8cc9177aa8861de0b6ca9161e4c5cfcd4625663 refactors the DDL to ensure the import table used for upserting has the same structure as the main table.

Also renamed database from "covid-19" to covid_19 to reflect Postgres naming best practice, so we don't need to use double-quotes.

jqnatividad commented 4 years ago

https://github.com/dathere/covid19-time-series-utilities/commit/cdd22a19f5a13ba2df27853a23ed55f723069852 updates the README to reflect the new covid_19_user.

Changed script to just vacuum/analyze tables as well, not the whole database.