AthensHorseParty
Smash Journeyman
Hey y'all. You might know me as the 64 section's most impoverished poster but hopefully I'm gonna be able to change that soon with the help of this magical new "information economy" I keep hearing so much about. But to do that I'm gonna need to get a nice little portfolio of projects going on. The next thing I'm going to work on will hopefully also be a nice treat for the 64 community.
So check it out: some of you may have seen the site vods.co which is a searchable database for recorded matches for Melee, Brawl, Pm, and Sm4sh. In order to demonstrate that I can make a simple database application and hopefully a pretty little HTML5 front end (my html/css skills are basically still frozen in the 2004 era internet).
Of course the first step is gonna be to simply collect as many youtube or twitch channels as I can find with archived tournament matches. So this is where you can help. If you are interested in helping out with this project all you need to do to help is post links here to any archived sets you know of. It's okay if you just give me a link to a youtube or twitch channel and lemme know what tournaments they have sets of, I'll do all the data collection myself. In terms of the application and what it can do I figure I'll just record basic parameters like players, the tournament, the date, possibly commentators (if there are any), length of the set, and the game count data.
That's probably pretty much all it needs to do but if any of y'all can think of other cool features you want to see implemented and I'll see if it seems plausible based on my experience level and the amount of time I have. Another cool thing about setting up this database is we can easily analyze the data for info about tiers and match ups etc. etc. Although for the time being I'm probably gonna confine the data set to recorded matches just to make it easier for me to get something done ASAP and also because it's hard to verify matches and set counts that are just listed in some old challonge bracket, some times they aren't totally accurate.
Also just out of curiosity @
Shears
if you are interested in hosting an app like this lemme know what we'd need to do to make that happen. I haven't done much database stuff, especially in recent years but I'm planning on working with Rails and MySQL since that's what a lot of good tutorials suggest you start off with.
So check it out: some of you may have seen the site vods.co which is a searchable database for recorded matches for Melee, Brawl, Pm, and Sm4sh. In order to demonstrate that I can make a simple database application and hopefully a pretty little HTML5 front end (my html/css skills are basically still frozen in the 2004 era internet).
Of course the first step is gonna be to simply collect as many youtube or twitch channels as I can find with archived tournament matches. So this is where you can help. If you are interested in helping out with this project all you need to do to help is post links here to any archived sets you know of. It's okay if you just give me a link to a youtube or twitch channel and lemme know what tournaments they have sets of, I'll do all the data collection myself. In terms of the application and what it can do I figure I'll just record basic parameters like players, the tournament, the date, possibly commentators (if there are any), length of the set, and the game count data.
That's probably pretty much all it needs to do but if any of y'all can think of other cool features you want to see implemented and I'll see if it seems plausible based on my experience level and the amount of time I have. Another cool thing about setting up this database is we can easily analyze the data for info about tiers and match ups etc. etc. Although for the time being I'm probably gonna confine the data set to recorded matches just to make it easier for me to get something done ASAP and also because it's hard to verify matches and set counts that are just listed in some old challonge bracket, some times they aren't totally accurate.
Also just out of curiosity @
Shears
if you are interested in hosting an app like this lemme know what we'd need to do to make that happen. I haven't done much database stuff, especially in recent years but I'm planning on working with Rails and MySQL since that's what a lot of good tutorials suggest you start off with.
