How this all got started
I keep up with the NBA and everything and see amazing feats of players scoring 30+ points. I've been playing basketball recreationally since high school. However, I never played organized ball, not even the 3v3 tournaments, so none of my stats were ever recorded. I just thought... hmm, how nice will it be to see some stats of my own and see how I compare? It wasn't my original intention, but after playing at P.S. 124 a couple of weeks and recording a couple sessions, that thought arose again. I started collecting the stats in Google sheets for one week and then I just continued.Ok, but why the website?
There's a couple of reasons.- Google sheets was limited in that it couldn't do the weekly totals and averages automatically. Tried setting up a macro but it didn't work. So that's like 15 minutes of work every week which I felt I shouldn't need to do. Edit: I really like how my Advanced-Stats page turned out.
- Google Sheets also some limitations. I couldn't work with the data much. I had developed thoughts of somehow getting more interesting data, such as +/- of a player, and unless I wanted to do that manually, the data will have to go in a database.
So I guess I'm making a website.
Website building process
- HTML/Bootstrap
- Javascript/Jquery
- Node.js/Express
- MySQL
- AWS
- Godaddy
- Kali
Technologies, platforms, libraries, engines to use:
- Reviewing previous course material and googling everything else.
- Deciding what to use (list above).
- Choosing colors.
- Collecting data (weekly). Video can be found in this youtube channel.
- Insert data into the database and building queries for the statistics I want.
- Fetching and presenting the data onto the webpages.
- Stop site from crashing due to self imposed sql injection attacks by implementing parameterized queries and input validation
- Migrating local environment to AWS
- Getting a domain from Godaddy
- Implement a AWS certificate and load balancer
- Go live!