GameHub

Transcript

1. GameHub Developers: Lauren Blummer, Janssen Bozon, Michael Chan, Daniel Gonzalez, Yuan Lu, Linh Vu
2. About GameHub
3. Why Create GameHub? • Help gamers explore various games from different companies across a plethora of genres in a single location.
4. APIs We Scraped for Models’ Data RAWG.io • We mainly used RAWG.io’s API to gather the bulk of our data. However, there were numerous instances in which RAWG’s data was incomplete, leading us to use IGDB to fill in these gaps. IGDB.com • We used IGDB’s API to fill in any gaps in the data gathered from RAWG.
5. Models Games • Id # • Name • Description • Score • Genre_Id • Released • Company_Id • Pictures • Platform Genres • Id # • Name • Description • Num_Games • Games • Picture • Themes • Companies Companies • Id # • Name • Description • Location • Year • Num_Games • Games • Genre_Id • Img
6. Model Relationships Explained Company – Games : One-to-Many • One company may produce many games. Genre – Games : One-to-Many • One genre may have many games in that genre. Genre – Companies : One-to-Many • One genre may have many companies contribute to it, but each company typically specializes in one main genre.
7. Application Demonstration
8. Critique: GameHub
9. What did we do well? • Cohesive design of the user interface • Designed a cohesive user interface where every page contained clear links to other pages of related information • Easy to navigate
10. What did we learn? • Scrape APIs and create and use a database • Design an interesting website frontend using HTML, CSS, and JavaScript/Bootstrap • How React adds dynamic functionality to a webpage • How Flask organizes a backend with Python • How APIs can be scraped to provide data, and how this data can be stored in a database • Use GCP to deploy the web applications to the cloud • Use Postman to test APIs
11. What can we do better? • Adding more information for each item ◦ Social media links on company pages • Add trailer and review for each game • General Search Page ◦ Display some sample games/companies/genres ◦ Show a specific number of items ◦ Implement “Show more” option • A map that shows the density of players of specific game
12. What puzzles us? • Get data from the APIs. ◦ Not familiar with the mechanics of API requests ◦ Many results seemed inconsistent with the documentation
13. Critique: FindJobs
14. What did they do well? • The website was laid out clearly ◦ Information neatly divided into tables ◦ The headers made it easy to access each page • The website also included useful interactive elements ◦ Inbuilt Google Maps windows for each location • Simplistic and not overwhelming
15. What did we learn from their website? • Different Jobs ◦ Where they are located at ◦ The companies that are looking to fulfill these jobs • Interesting Visualizations ◦ Brainstorm styled words display that are very visually appearling ◦ Graphs to represent data
16. What can they do better? • Show a list of page numbers ◦ Hard to navigate by just arrows • A quick Apply button on Job page model • Improving the search function on the list pages, which (at the time) don’t show anything • Add more visuals to create a more inviting feeling to the website • Improve UI ◦ It kind of feels like a big spreadsheet
17. What puzzles us about their website? • It was a bit difficult to figure out how to sort the elements of their website. It turned out that we had to click the header of each table to do so, which was not clearly indicated. • Visualizations (word cloud) were fun, but ◦ Visitors couldn’t figure out exactly what information was supposed to be conveyed by them ◦ Perhaps, convey the amount of item in each word?