VGIDb.me

Transcript

1. VGIDb.me
2. Team KANCE Abhi Rathod Front End Issues: 13 Commits: 110 Unit Tests: 7 Chris Collier Back End, Database Issues: 16 Commits: 98 Unit Tests: 7 Keith Wong Database Issues: 12 Commits: 65 Unit Tests: 10 Nathaniel Ballinger Back End Issues: 11 Commits: 61 Unit Tests: 10
3. About VGIDb.me The Video Game International Database is a one-stop location for all game, character, or platform-centric video game information. From a game, platform, or character you can find tons of information and link to other games, platforms, or characters. You'll get lost in a sea of video game related knowledge!
4. Pillars of Content GAMES PLATFORMS CHARACTERS Icon Release Date Platforms Aliases Site Detail URL Characters Icon Release Date Company Starting Price Abbreviation Online Support Number of Units Sold Games Site Detail URL Icon Game First Appeared Description Gender Aliases Site Detail URL
5. Relationship Multiplicity
6. Our API Two types of GET requests for each game/platform/character: Request for a single pillar containing all relevant information in the database. Request for 25 instances of the pillar at a specified offset containing more limited information
7. GiantBomb API scraping "Giant Bomb is a website about video games for people who love that sort of thing. People like you, you know what I mean?" - Giant Bomb Used GET requests using API key and user-agent to create instances of our database models. Stored API entry as dictionary, saved results into a database model. Linked pillars after loading all data into database Had to wait one second (time.sleep(1)) in between every GET request. We are very thankful for GiantBomb allowing us to use their API.
8. DEMO
9. Critiques of our website Quick loading of page results Lots of database entries Learned front end-back end- database integration Github Issues and Wiki More efficient loading of database Full stack planning (accounting for needs outside of immediate proximity). Website makes two requests per click. Inner workings of PostgreSQL database
10. Critiques of research papers Makes building a website look easy Lots of clickable links Design difference show different routes for the same task How to integrate API into our project Possibly include more information for specific papers. Improve 'run-tests' design Back end process of fetching from database Sorting algorithm for each page
11. Questions?