Steam DB System

Required

• MySQL
• Node.js
• Jupyter (If you want to generate data yourself)

Repo Layout

• client/: FrontEnd of the project
  
• server/: BackEnd of the project. SQL commands used in backends are mostly in routes/. Loading database to the project is in models/index.js
  
• SQL/: All you need on how to create and load our sample/production database, as well as test-sample.sql, test-production.sql and their outputs. We are using steamdb.json as our data source
  
• database/: Contains the data we use (toy & production)
  

Project Startup

!! If first time starting this project, please run ./Setup.sh which sets up the dependency, user privilege and schema !!

Under the project directory, run ./Run.sh to start up both backend and frontend. The web will pop up for you.

Project Features that (Currently) Supported

• Posts(Review)
• Posts Deletion (Must be owner of the post)
• Comments for the Posts(Review) (Must Login)
• Comments Deletion (Must be owner of the comments)
• Different Games Display Category
• Game Details Page
• Game Details Page showing its reviews
• Profile Page for Users
• Profile Page displaying owned games
• Profile Page displaying reviews the user posted
• User Login
• User Register
• Like/Unlike a Post
• Password protection
• JWT Authentication

To Generate SQL Data

See the two jupyter notebooks in directory database/.