Skip to content

SteamDB is a platform for buying, trading, rating, and selling different video games, alongside friending functionality amongst users.

License

Notifications You must be signed in to change notification settings

kyletimmermans/SteamDB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Version 1.0 Python 3.10 Streamlit 1.16.0 PostgreSQL 14.5 Last Commit kyletimmermans Twitter

SteamDB Logo

SteamDB is a platform for buying, trading, selling, and rating different video games. There is functionality for adding / removing friends and keeping track of what games they have. Once friending another user, you can trade and sell games with / to them, and keep track of the history of your transactions. The UI handles for a number of various user input errors and misuse cases. The point of this project is to better understand SQL, specifically PostgreSQL and SQL injection attacks.



Installation / Setup

  1. cd into top level folder
  2. Run pip install -r requirements.txt
  3. cd into src folder
  4. Start PostgreSQL and run psql -U postgres -c 'CREATE DATABASE steamdb;'
  5. Run psql -U postgres -d steamdb -f schema.sql
  6. Optionally, fill the app w/ test data by running psql -U postgres -d steamdb -f load.sql
  7. Run streamlit run login.py --server.headless=true
  8. Open your browser and visit http://localhost:8501/



Screenshots

Userpage Top Section

Userpage Middle Section

Userpage Bottom Section

Login Page

Login Failed

Register Page

Register Page Success

Register Page Deals w Special Chars

Register Failed

Friend Added

Friend Removed

Failed Trade

Sold Game

Rated Fame

Bought Game

Marketplace Star Ratings

About

SteamDB is a platform for buying, trading, rating, and selling different video games, alongside friending functionality amongst users.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages