This is a project to develop a good online stats program for running quizbowl tournaments. The project is based on a collection of PHP scripts that I put together to run tournaments at Grinnell College, since Windows software wasn't an option and it seemed like fun.

It works effectively and is simple to use. Installing it yourself takes some technical knowledge, but you can have your tournament stats hosted on http://quizbowl.gimranov.com/ if necessary.

To try it out, see InstallationInstruction.

There is also a Live Online Demo. In the live demo, try out the "Test Tourney", with the username and password: testtourney/testme

If the installation instructions above don't make sense, or you don't have a place to host a copy of qbsql, I can make a tournament for you at http://quizbowl.gimranov.com/ and you can use that copy for your tournament.

If you have questions or want to help out, let me know.

If you run into a bug, post it in the Issues section.

Cool things you can do with qbsql:

• Upload round results from multiple locations
• Show live-updating results
• Do stats without a Windows machine
• Export tournament results to send to results databases (NAQT only for now)

Tournaments that have used qbsql:

• Minnesota Open Mirror at UCLA, October 17, 2009
• EFT Mirror at UCLA, October 4, 2009
• Intramural Tournament at Stanford, Fall 2009
• Aztlan Cup V at UCLA, March 22, 2009
• BISCUIT III at UCLA, March 21, 2009
• BAIT 2009 at UCLA, March 7, 2009
• NAQT SCT West at UCLA, February 7, 2009
• Grinnell Undergraduate Tournament, 2004-2006
• Grinnell High School Tournament, 2005-2006

Where we're going:

This is a project that could use some work. If you like to code and like to play quiz bowl, this could use some improvements, like:

• A way to cleanly export a tournament and make its results static
• Something like a round-robin and bracket generator, so that qbsql could know what matches should be played, and to make tournament directors' lives easier.
• More intelligent interfaces that might auto-fill fields and show live calculating round stats
• Probably lots more!

Other options

• If you want more options and an all-in-one Windows experience, I recommend SQBS.
• If you want an online system a lot like this one, and don't mind paying a little for the service of having someone else host it, you could try Taft. They charge $25. Then again, you can use this or SQBS for free.
• If you don't want to pay, don't want to use Windows, and aren't afraid of Perl, you might want to try Livestat.