Whiel surfing around, I accidentally ran across the [url=http://www.invokemedia.com/spanish-digg-meneame-installation-instructions.html]table structure for meneame[/url]. The site is like basically a Spanish digg-clone.
So while a lot of it did reinforce what I am already doing, I did tweak the tables a tad, and now it has 123 columns across 15 tables.
More interestingly is something I learned from the [url=http://xooglers.blogspot.com/2005/12/just-do-it.html]just do it![/url] post. What hit me was Larry realized that 99.9% of people are decent, and have no intentions of screwing the system. So while I have always been very defensive (manually checking everything that comes my way), this time I am going to go the other way - allow submissions to show up instantly, and let the users report spam (automated ‘holding’ and then manual checking). In return, this lets the users have instant feedback, thereby encouraging them to submit more!
I hope my team combined with the 99.9% of the userbase can take care of the annoying 0.1%
I will likely add a level of email verification - damned near instantaneous but with a little check ([i]nod[/i] to craigslist).
