A common practice for Twitter application developers is creating a MySQL table to store user objects returned from Twitter’s API. I’m trying to optimize my user table for Friend Or Follow, and it occurred to me how many developers must be reinventing this MySQL table schema, so let’s get it right once and for all.
Here’s where I’m starting. If you see anything that I’m missing, or notice a data type that could be optimized let me know in the comments and I’ll update the post to reflect your suggestions.
On November 1st I shaved my face clean for a friendly bet amongst my friends on who could grow their mustache the longest before their significant other gave them ultimatum to shave it. As it turns out, our little bet coincided exactly the same day Movember started. What is Movember? Movember is an annual, month-long celebration of the moustache, highlighting men’s health issues – specifically prostate and testicular cancer. This of course is brilliant, and I couldn’t help but join the cause.
You can help fight against prostate and testicular cancer by becoming a sponsor of my mustache. “Ridiculous” you say? Ok, sponsoring a mustache is a little silly, but this Movember, the money raised in the U.S. will be split between the Prostate Cancer Foundation and the Lance Armstrong Foundation to fund research to find better treatments and a cure for prostate cancer, and there’s nothing silly about that.
DONATE HERE The link so nice, some times you have to click it twice [to make it work].
For large projects I usually databind my dropdown lists, but sometimes you just need a no-nonsense dropdown list of US States. For all you folks Googling to save time, here’s that code. Enjoy! 🙂