Week #1 : Design new database schema

Published: 06/08/2023

What did I do this week?

I focused on enhancing the current database schema to accommodate EPSS metrics and EPSS percentiles. I carefully reviewed the existing schema and identified areas that needed updating to ensure future-proofing. By doing so, any new metrics that emerge in the future can be easily incorporated into the database. Additionally, I devised a database schema that allows for seamless upgrades and updates.

What is coming up next?

my next work will involve creating a new table in the database specifically designed for EPSS data. This entails downloading, parsing, and storing the EPSS data in the newly created table.

Did I get stuck anywhere?

I encounter difficulties in identifying necessary updates and designing a future-proof schema, particularly when considering uncertain future parameters and ensuring adaptability of the database schema.