Show HN: March Madness Bracket Research with Stats | Hacker News Reader

Show HN: March Madness Bracket Research with Stats

madness.io

3 pointsncavig3 comments

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.

Open articleView on HN

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.

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.

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!

Reply on news.ycombinator.com