Articles on Rexbeast2's Blog

Week Blog #12 - Adding EPSS probability filter

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:32:31 +0000

What did I do this week?

This week, I successfully added epss probability filter. I also added test for EPSS probability filter.

What is coming up next?

Since this was the last week of the GSoC period, next week on I will continue to contribute to the organization and implement my "future goals" all the while working on other issues as an open-source enthusiast as well.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while adding epss percentile filter. The process was smooth and straightforward.

Week Blog #11 - Adding EPSS percentile filter

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:29:34 +0000

What did I do this week?

This week, I successfully added epss percentile filter. I also added test for EPSS percentile filter.

What is coming up next?

In the next phase, I will focus on adding epss probability filter.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while adding epss percentile filter. The process was smooth and straightforward.

Week Blog #10 - Adding test for output

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:14:02 +0000

What did I do this week?

This week, I successfully added test for the new output format for each of them (console, HTML, PDF, JSON and CSV).

What is coming up next?

In the next phase, I will focus on adding epss percentile filter.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while test case for the new output. The process was smooth and straightforward.

Week Blog #9 - Changing JSON and CSV output

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:11:56 +0000

What did I do this week?

This week, I successfully added data into JSON and CSV. the metric field was added to both of them.

What is coming up next?

In the next phase, I will focus on adding test case for the new output structure.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while data into JSON and CSV format. The process was smooth and straightforward.

Week Blog #8 - Changing HTML, Console, PDF output

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:10:07 +0000

What did I do this week?

This week, I successfully added data into HTML, PDF and console.

What is coming up next?

In the next phase, I will focus on JSON and CSV.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while data into HTML, PDF and console. The process was smooth and straightforward.

Week Blog #7 - Adding data to output engine

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 10:08:01 +0000

What did I do this week?

This week, I successfully added data into output engine. Output engine class was changed to accommodate new metric.

What is coming up next?

In the next phase, I will focus on adding metric to output formats.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while data into output engine. The process was smooth and straightforward.

Week Blog #6 - Adding queries to extract data

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 09:44:18 +0000

What did I do this week?

This week, I successfully added queries to extract the data from the database new structure. I also added test to ensured that the data extract contain new data.

What is coming up next?

In the next phase, I will focus on adding data to output engine.

Did I get stuck anywhere?

The cursor of the database was getting reset after extracting the data from the database. It took lot of time to find out were was the problem. After know the problem I create a new function which create a new cursor and extract data.

Week Blog #5 - Adding data into new schema

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 09:39:05 +0000

What did I do this week?

This week, I successfully added data into new schema that was created. I also added test to ensured that the table were containing the data.

What is coming up next?

In the next phase, I will focus on adding the queries to extract the data from database.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while data into new schema. The process was smooth and straightforward.

Week Blog #4 - Updating database structure

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 09:32:28 +0000

What did I do this week?

This week, I successfully Added table metrics and cve_metrics to database. I also added test to ensured that the table were created.

What is coming up next?

In the next phase, I will focus on adding data to the table.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while updating the database structure. The process was smooth and straightforward.

Week Blog #3 - Enhance the downloading and testing EPSS

ssukhveer514@gmail.com (Rexbeast2) — Sun, 27 Aug 2023 09:29:17 +0000

What did I do this week?

This week, I successfully Enhance the downloading and testing EPSS data. I added test to ensured that the table had features for downloading, parsing, and storing EPSS data accurately.

What is coming up next?

In the next phase, I will focus on updating the current database structure.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while Enhance the downloading and testing EPSS data. The process was smooth and straightforward.

Week Blog #2 - adding EPSS metrics

ssukhveer514@gmail.com (Rexbeast2) — Thu, 08 Jun 2023 19:37:29 +0000

What did I do this week?

This week, I successfully implemented a new table in the database to incorporate EPSS metrics. I ensured that the table had features for downloading, parsing, and storing EPSS data accurately.

What is coming up next?

In the next phase, I will focus on modifying the current database schema to accommodate two additional tables.

Did I get stuck anywhere?

Fortunately, I did not encounter any challenges while adding the EPSS metrics to the database. The process was smooth and straightforward.

Week #1 : Design new database schema

ssukhveer514@gmail.com (Rexbeast2) — Thu, 08 Jun 2023 19:26:48 +0000

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.