Project Date: Fall 2015 - Fall 2016
Computer Science House celebrated it’s 40th anniversary in April of 2016. That’s 40 years of history, and hundreds of members making their mark on the tech industry and beyond.
I wanted to get an idea of where CSHers end up after escaping the cold, snowy clutches of Rochester, NY, so I created the Alumni Map. CSH members can view the map, search for other members, and add/update their own location. View the project on GitHub!
I stuck with MySQL for the database - this is a relatively small project, and I was already familiar with it. Instead of a single table - one entry per user, overwriting whenever the user moves - I set up a more robust system. I decided to track Members (users on the map), Locations (places users have been), and Records (records of a Member setting a new Location). By storing all changes and tracking years of data you could analyze trends. How often do CSHers move? What cities were the hubs of CSHers over time?
A big goal of this project was to maintainability. This was something I often overlooked in my college projects and didn’t really appreciate the need for until I got some real world experience. I used ESLint for code linting and style checking. I wrote tests using Jasmine for both the client and the server. And I set up CircleCI to build, test, and validate each commit and pull request. Thanks to these tools and more thoughtful design, the code is much more readable and stable compared to my past projects.