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