gamr

Learning Objectives

• I want to gain a firm understanding of Database architecture and design.
• I want to begin to make TDD my default mode of development, rather than writing code first and fixing it later.
• I want to improve my front end development skills, particuarly CSS.

Problem to Solve

• I buy loads of games.
• I love cataloguing things and I love stats and metrics.
• I want to be able to keep a track of and measure things about my games collection.
• I want to be able to share this information with my friends.

What I am building

• I want to build a small scale social netowrk for video games.
• I want to connect gamers together and allow them to talk about games, look at what games their friends are playing and just hang out and chat.
• I want to connect to a nubmer of APIs. A video game database API would be good so that I do not need to keep track of every game ever.
• It would be great to be able to track when a friend is currently playing on gaming service X so that I can hop on and play. Currently, the various gaming services are in their own enclaves which makes it hard to keep a track across a number of services. A central point of contact for gamers would be awesome.

User stories

• "I want to list all of the games that I own."
• "I want to add new games to this list."
• "I want a wishlist of future titles that I would like to own."
• "I would like stats on what kind of games I am buying, eg. More physical games, what system etc?"
• "I want to be able to display charts around stats."
• "I want to be able to keep a track of whether I have finished a game or not."
• "I want to be able to share my library with my friends."
• "I want to connect to other social networks to post information about my games."
• "I want box art to be added automatically when I add a game."
• "I want to track how much time I spend on games."
• "I want to track how much I spend on games."
• "I want to be able to rate games I have played."
• "I want to be able to comment on gamers"
• "I want to be able to comment on games"

Stretch Goals

• "I want to track my backlog of games and how long the Internet thinks it will take to finish them using an API."
• "I want a central spot to find out what my friends are playing, and on what gaming service."
• "I would like to pull in reviews from metacritic on games."

MVP

• I want to show a basic user page which lists information.
• I want to show basic information about a game
• I want all users to be displayed on the / route
• Basic styling is done
• I want to interface where I can list games that I own.
• I want to be able to edit user information.
• I want to be able to add games. -- Need to figure out tests!!!!!!
• I want to be able to delete games.

DB Design

Basic tables

• users
• games
• friends
• game systems
• publishers
• genres
• status (eg. Completed, in progress, not started, never going to start)
• users-game_service_ids
• regions

Feature design

Write back end, db stuff - TDD!!

Look at front end styling

API Stuff

• Add form needs to use API
• Add form needs to automagically download boxart and save as ${id}.jpg
• Add form needs to allow user to select what platform they bought game on.
• User form needs to list what systems they own

Metrics

• Need a pie chart of what systems a user owns games for
• Need to be able to produce reports based on a time. Eg, I have bought x games over the past x months on which systems.
• Need to record whether a game is physically or digitally owned.

Stretch stuff

• Allow a user to mark a game as completed
• Allow a user to add x amount of time against a game
• Allow a user to comment on a game, which will appear on that game, not userGame.
• Allow logins!