I'm trying to figure out the best method to create a webapp using JSON data. League of Legends has an API that returns JSON data from their requests and I'd like to create a site that uses this data. What I'm having trouble figuring out is the best way to go about this. I don't have hardly any experience with web design, but I know I can learn. I'm just not sure what to learn.
It seems like JQuery or AJAX are good for using JSON data, but the API has a request limit, so they recommend caching the data. Fine, a lot of the reason I'm interested in this project is my interest in data. So a friend I talked to recommended using PHP. I started learning PHP, and the tutorial I was reading says to use MySQL. Cool, getting somewhere. Except apparently SQL has no support for JSON.
What I was thinking is maybe I should not worry about the caching data yet, just get started using static data requests, that don't have limits. But I want to do so with a method that will scale well for my project.
Also, I understand the basics of processing the JSON format. But what's the best way to build a website that's set up to fill with JSON requests? This seems like it's a separate problem than the actual requesting, but most of what I read doesn't really address it.
Basically I'm becoming a bit overwhelmed. I know that there's a lot to learn for this project, that doesn't worry me. But I can't learn everything in the field of web design all at once. If anyone can help me figure out a direction, that'd be awesome.
Also I do know the basics of html but haven't worked with it much at all.