One of the things I’ve been working on is a computerized scouting system for competitions. Basically the idea is to host a web server on a computer at competition and have other computers connect to it to input data. Here are some features that the system has:
Customizable data fields (currently supports numerical and true/false data)
Ability to open multiple input forms at once (in case computing resources are limited)
Comment system for qualitative data
Ability to rank teams based on any parameter
Completely portable - can even be installed to a USB stick
Please be advised that there are still some minor bugs in the program so it might behave erratically. I hope to have an update out to fix the bugs before regionals start on Thursday, but if not I will update the guide to include workarounds for the remaining problems
The frontend is a combination of php and ajax. There is phpmyadmin but the problem is the frontend dynamically creates databases and tables as you add data. And because the type of data you want to record is customizable, the number of columns and their names are also dynamic.
I’m not sure exactly what you’re intending to do, but if you want to look at the raw MySQL data phpmyadmin is under “/phpmyadmin” (root password is “frcrules”).
It should absolutely work on vista (unfortunately I didn’t have a vista system handy to test it on). The only problem you might run into is administrator privileges; to play it safe you can just run everything as administrator.
Team 93 used a similar system in 2009 but haven’t used it since for one reason. Power availability/reliability, or rather the lack thereof of it. While it might have just been the crappy laptops (and batteries) we were using, just make sure that you can use it all throughout the day, because having 6 guys (or girls) sitting around doing nothing, or very little or very inefficiently(as in filling out the paper forms we were using at the time), is not very good (or fun for that matter).