View Single Post
  #7   Spotlight this post!  
Unread 05-01-2011, 10:46
timothyb89 timothyb89 is offline
code monkey
FRC #1977 (Loveland High Robotics)
Team Role: Alumni
 
Join Date: Oct 2008
Rookie Year: 2009
Location: Loveland, Colorado
Posts: 45
timothyb89 will become famous soon enough
Re: Best Data Format?

Well, our JSON interface interface is working nicely, and currently looks something like this:
Code:
http://frcdb.net/event/whatever/json (single event, includes match data and standings)
http://frcdb.net/team/####/json
http://frcdb.net/json/teams (all teams)
http://frcdb.net/json/events (all events)
This works fairly well at least (via initial testing with the android app we‘re working on) save for trouble with database speed. It could be tested now save for some hosting issues that I‘m working on resolving (current server is down due to hardware problems...).

Anyway, it‘s a good thing someone‘s thought to make a standard XML format! We‘ve been planning to offer that but lost some priority when it was decidedly too hard to parse, but standardizing it can make this a ton easier.

CSV is still in the works, but converting our data to a relational model tends to be more time consuming than simply dumping it out Apparently that‘s what we get for storing everything with mass serialization instead of in an SQL database like we should have...
__________________
FRC-DB: A detailed, web-based scouting database for FRC teams with lots of interesting statistics.