GSA / data.gov

Main repository for the data.gov service
https://data.gov
Other
546 stars 87 forks source link

Update harvest DB tables #4731

Closed rshewitt closed 1 month ago

rshewitt commented 1 month ago

User Story

In order to use the most recent table definitions, datagov wants to update the harvest database tables to reflect what's in the table definition document

Acceptance Criteria

[ACs should be clearly demoable/verifiable whenever possible. Try specifying them using BDD.]

Background

[Any helpful contextual notes or links to artifacts/evidence, if needed]

Security Considerations (required)

[Any security concerns that might be implicated in the change. "None" is OK, just be explicit here!]

Sketch

[Notes or a checklist reflecting our understanding of the selected approach]

rshewitt commented 1 month ago

needs to occur before #4744

rshewitt commented 1 month ago

columns are nullable by default (source). just wanted to share

rshewitt commented 1 month ago

a conclusion that we reached in our stay-after is to drop sqlite and look into scaling another instance of postgres. one for the flask app and another one for db integration tests. we also discussed moving the flask app out of the compose file and into the makefile