CS329e Presentation

Presentation for website videogamelibrary.me

Transcript

1. videogamelibrary.me A Creation By: Alejandro Palacios, Brandon Ford Madalyn Marabella, William Kwon Noah Placke
2. What Does It Do? A website that consists of a set of static HTML pages for three different pillars related to a topic of our choice that display all forms of data collected. We selected video games and are tasked with creating pages for games, genres, and companies.
3. Pillars 1. Games - Name, Summary, Rating, Genres, Companies 2. Genres - Name, Description, Popularity, URL, Games 3. Companies - Logo, name, Description, Country, Date Founded, Game Developed info(team, founded, etc)
4. How Did We Do It? (Frontend) With the front-end, we are using HTML, CSS, and the Bootstrap library to create a responsive interface that is both appealing and user friendly. Along with custom CSS, we are using the grid component from Bootstrap. Other components used consist of navbar, carousel, cards, and many more.
5. How Did We Do It? (Backend) - Flask + SQLAlchemy ORM - Classes for each pillar - Routes for each pillar - Request data passed as url parameters
6. How does the DB Work?
7. How does the DB Work?
8. How does the DB Work? - Normalized tables: three pillars/entities and two bridge tables - Joins to execute multi-table queries - ORM to map SQL queries to Python objects db.session.query(Game).join(Genre,Game.genres).all()
9. Collecting data from API - IGBD API - Limits of free account -> static json files - Issues with ‘Requests’ library -> bash scripts curl -H 'user-key: 401df87a02a8f4c13842a135bad415a4' \ -d 'fields name, url; limit 50;' \ 'https://api-v3.igdb.com/genres/' >> genres.json
10. Critique Of Our Website The Good: - Simple and easy to use animation - Vast database - Interconnectivity between pillars - Easy search functionality The Bad: - No pictures for all pillars - Static news feed - Logo is not sortable - Popularity for Genre is static What Needs To Be Changed: - Add pictures to all pillars - Find sortable attributes companies and genres
11. Critique Of Other Website (fureverfriend.me) The Good: - Good purpose - Very nice layout - Clear navigation - Vast database - Clear search results The Bad: - Some images are distorted - Sometimes CSS is not consistent What Needs To Be Changed: - Keep consistent CSS - Crop images instead of resizing