[Integrates][db] Migrate to single table
Problem to solve
The current design is prone to problems such as:
- exceeding the 400kb size limit as they store historic states in a list
- id collision due to the random-based format
- many others
Proposal
Let's migrate the tables to the new DB design (sorted ascending by estimated complexity):
-
fi_async_processing 1 -
FI_forces 1 -
fi_events 1 -
fi_finding_comments + fi_project_comments 1 -
fi_portfolios 1 -
fi_organizations + integrates 1.5 -
FI_users + fi_authz + FI_project_access + fi_subscriptions 2 -
FI_projects 2.5 -
FI_vulnerabilities 3.5 -
FI_findings 10
The task with the highest complexity took us about 5 months (20 weeks). Distributed on a scale from 1 to 10, with 2
weeks per complexity point, we arrive at an estimated total duration of 23.5 points * 2 = 47 weeks
(assuming a sequential execution of the tasks)
- Current execution 20/47 = 43%
- Developers assigned = 2
- Weeks to finish: 27
fi_roots was already migrated in #4106 (closed) FI_toe excluded in favor of #4014
What does success look like, and how can we measure that?
- all data stored in a single dynamodb table
Links / references
Edited by Jhon Romero