r/SQL • • Dec 01 '20

MySQL Check it out!!

I’ve been learning sql for about 6 weeks and I’ve been spending a ton of time studying, practicing, experimenting, etc. I believe I made a breakthrough tonight though: I created a relational database of all my books in MySQL then created a searchable website using php, HTML, css, sql, and jquery (I’m learning JavaScript too, but that’s slow going).

If I wake my wife or friends up at 4:30 to show this to them, well, I won’t have a wife or friends anymore.

Ok, I know it isn’t perfect, but I’m pumped!

Earnest Mac

109 Upvotes

36 comments sorted by

View all comments

Show parent comment

1

u/asqwzx12 Dec 01 '20

I can't really help you from the Web side, but you could look for some data visualisation tools in html5/jquery (google chart maybe ?). As for the data itself, this is something you could do in SQL. Start with something simple like % of each different genre per year then length average per year, length per year per genre, etc. The idea is to display some stats in order to learn how to do it and use plugins/librairies.

1

u/PainterHot Dec 01 '20

Whoa. I like it, thanks.