Search and Discover

This week, Samantha and I performed extensive research on the developer graphs and tables, and worked on pair programming techniques. Two new issues were assigned:

Do manual investigation of non-central sheriffs and central non-sheriffs

and

Add missed_vuln column to dev_snapshots

I had a heavier focus on the first issue where I became more comfortable with our databases and what each of the queries hold. From there, I focused on catching correlations between developer ownerships, contributions, and sheriff hours. I was able to discover which developers were very active in working on a snip of code but did not own or sheriff for it, and vice versa. This allowed me the exposure of using psql and the Ruby console. Samantha has been primarily working on the second issue where she is writing queries to analyze whether a vulnerability has been overlooked or not by a developer.

For these two issues, Samantha and I have been bouncing ideas off each other and helping one another with query creations.