|
Universal Scouting Backend
Many teams (and other organizations) have attempted to create a scouting database which can be used by multiple teams in order to provide scouting information to everyone. One of the setbacks that these attempts have faced is that they are unable to use information gathered by other efforts and thus must start their information from scratch. My objective is not to create another scouting interface, but instead to create a united database, which other organizations can write clients for. This will make creating a scouting system much easier, because it can be easily populated with a wealth of information. Below is my proposed implementation (Be forewarned I am going to assume you have a basic knowledge of web design):
The site would be based around a MySQL database. The database would have at least two tables (matches and teams), but likely far more. Each table would have many pre-defined fields (i.e. participants, scores, video) a comments field and a custom data field. Teams would be allowed to submit information to the database by POSTing JSON format information to an acceptor page. Information would be retrieved by POSTing a query to a querier page that would run the query with a user that could only select, and then parse and return the results. Information could be further processed by the client.
What do you think? Would you be interesting in working on this project?
|