This term, the club as a whole worked on developing an Ecommerce platform for Oregon State University students to easily buy and sell any items they wanted online. To learn more about what our project was about, check it out HERE. To see how we built the platform, take a look HERE. The store is currently live and running at https://store.osuapp.club. As a reward for the most outstanding members of the club who put their all into this project, we're proud to present the top two MVP members of this term's project!
First place - $100
Blake Hakkila
Blake was specialized in the backend side of the Ecommerce project. He worked on developing the backend MySQL database to store all transactions that would be passed from the frontend site. This data could then be retrieved by the data science team to analyze and predict future sales. He also focused on processing credit card transactions using the Braintree payment gateway. To query the various data sources, Blake used GraphQL and the Apollo engine. Finally, an Express.js REST API was placed in front of the GraphQL server to serve as a middleman to the frontend and backend services.
Second place - $50
Chisomo Banda
Chisomo worked on the AWS (Amazon Web Services) side of the project. He was tasked with hosting our MySQL database in the cloud. To accomplish this, he used a service called RDS (relational database service), a VPC (virtual private cloud), and an EC2 (elastic compute cloud) instance. As he was creating the servers, he made sure security was on the top of his priority. The RDS instance was hosted in a private VPC that was inaccessible to the public internet. In order for developers to access the database, they had to use SSH tunneling through the EC2 instance. Backend developers that needed to connect to the database also had to use a separate Linux user and key pair that Chisomo created for them, containing limited permissions.
Comentários