Database Structural Decision
Budget: $30 – $50 USD
working on a data feed to export millions of postgres records to a partner. Each record fits into one or more of several different categories and I want help deciding how to store that categorization so it is best suited for producing the needed data feed.
There are two options I have in mind, but want an expert to help me think through the pros and cons to each, and pick the best approach.
Deliverables
A top level plan for table(s) to create and the workflow for how to populate them and query them to build the export file.
No real SQL coding is needed, just strategy.
There are two options I have in mind, but want an expert to help me think through the pros and cons to each, and pick the best approach.
Deliverables
A top level plan for table(s) to create and the workflow for how to populate them and query them to build the export file.
No real SQL coding is needed, just strategy.