Need an API framework made for a web-based server service. The specific implementation is up to the developer, but I am already somewhat familiar with relational SQL frameworks and this would be preferred unless there is a convincing technical advantage to using something else.
The following outcomes are expected:
-Implementation of database tables which can implement the attached test cases and requirements
-Server-side code which implements an API to fetch data through HTTP request strings. The data requested is returned as a JSON structure.
-Data requests must only return the data requested if the HTTP request includes a valid API key and fulfills other constraints. Valid API keys are unique hexadecimal strings defined in the database and correlate to a single user.
-Each API key can make a maximum of 100 successful requests per 12 hour period
-To write to the database requires a secure username/password administrative login
-Instructions detailing how to administrate the product into the future, including how to add/define new tables, restructure existing data structures, integrating changes within the HTTP send/receive request framework, and suggestions on web hosting for deployment are expected results
-Solution must be scale-able to accommodate tens of thousands of requests per day.
-Code must be logically formatted, well-commented, and easy to follow and maintain. Documentation for the API data request format and JSON data return strings developed are required deliverables.
Please refer to the attached document for a more complete set of requirements and test cases.