Week #1 : Design new database schema

Rexbeast2
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.

DJDT

Versions

Time

Settings from gsoc.settings

Headers

Request

SQL queries from 1 connection

Static files (2312 found, 3 used)

Templates (11 rendered)

Cache calls from 1 backend

Signals

Log messages