Hacker News new | ask | show | jobs
Show HN: March Madness Bracket Research with Stats (madness.io)
3 points by ncavig 4471 days ago
Showing a little side project of mine that will hopefully appeal to sports and stats fans alike. I am an engineer with a great passion for sports, particularly college basketball. My goal is/was to set up a site to easily discern important data about a given team and players. The site runs on a myriad of technologies including MySQL, Couchbase, Redis, and Rails + Foundation frameworks. Feedback would be appreciated. Good luck in your brackets.
1 comments
ncavig 4471 days ago
OP here; Showing a little side project of mine that will hopefully appeal to sports and stats fans alike. I am an engineer with a great passion for sports, particularly college basketball. My goal is/was to set up a site to easily discern important data about a given team and players. The site runs on a myriad of technologies including MySQL, Couchbase, Redis, and Rails + Foundation frameworks. Feedback would be appreciated. Good luck in your brackets.
link
ClassicFarris 4470 days ago
Hey, I'm interested in my you have Redis, MySQL and Couchbase? That's three database technologies for this project? I can see Redis being used like Memcache… but how are you using MySQL and Couchbase together. I'm interested in that interaction.
link
ncavig 4470 days ago
Thanks for the interest! For MySQL I wanted an easy ORM layer for team, conference and player data. Essentially those 3 objects are stored in MySQL. For redis, I use ordered lists for sorting and easily discerning indexes of team and player data, eg: how I come up with "n overall" and "n in conference" http://madness.io/teams/fak

For Couchbase, all game data is stored in a document, including player stats. I actually use Couchbase as a cache layer as well instead of Redis. Voting and some cache keys are documents and I write couchbase views or use traditional get's to grab that data. Couchbase does the map reduce to give me the numbers I need to come up with all the stats you see on the site. It also comes in handy for things like standard deviation and the tempo-free stats on the matchup pages

Hopefully that helps!

link