I have just implemented a new feature that I realize will be used by very few people (despite it taking a great deal of work). But those few people might provide some new capabilities that we wouldn't otherwise have, and besides, I wanted the capability myself, so I went ahead and did it anyway.
I am now supporting database exports, similar to those provided by the WCA. I am actually supporting 4 different formats, instead of the WCA's two:
1. An SQL export that basically mirrors our internal database structure, leaving out the private data such as passwords. Note I am also hiding first and last names, since there is an option to hide them, and I don't want old database exports to expose names that people might have since decided to hide. This export contains comments and FMC solutions, so it has more data per solve on average than does the WCA database.
2. A TSV version of the above export.
3. An SQL export where our data has been converted to tables to more or less match those of the WCA. It is my hope that this export will allow people with software written to work on WCA exports to be able to use our data with their software, basically unchanged. One thing I'm hoping is that this might allow Kinch ranks to be calculated for us, much as they are done elsewhere on the web for the WCA data. I basically tried to map or default any fields that we don't have an equivalent of so as to match the database table structure as closely as possible.
4. A TSV version of export 3.
Since this feature will likely have very few users, I would appreciate any feedback any user might be willing to give me. I have done some basic testing of the exports, but I would not be surprised if I have made some mistakes. Please contact me if you see anything I have done wrong, or anything I can do to improve the output (especially for the WCA format). I will be happy to work with you to help make your application of the database export work as much as possible.
The exports can be accessed here:
https://www.speedsolving.com/competitions/results/export.html
This can also be reached from the menu at the top of the statistics pages.
Again, please let me know of any problems you might see; I will attempt to fix them the best I can.