*** RYAN TATE: Shocking secrets--revealed! ***





Professional bio

Media appearences



Weblog archive



Contact info

RSS feed

PGP key

415.640.6119 mobile

415.288.4968 office

510.548.4576 home

Home address and map

My building

AIM: ryantatedotcom

Recent San Francisco Business Times stories

Table set at Ferry Building (Jun. 6)

S.F. out to rattle chains (May. 30)

S.F. plan sets goal of 10,000 homes (Jun. 27)

Stanford's new senior class (Jun. 13)

Is San Francisco's housing crisis over? (Jun. 20)

Stanford Shopping Center on block (May. 23)

Insurers locking up condos (May. 23)

Developer makes bold housing play (May. 16)

Williams-Sonoma revs web (May. 9)

Residential Real Estate Deals of the Year (May. 9)

More ...

Recent personal essays

Private property (Oct. 8)

Blogs I read

Anne and her Cheese Diaries





David Warsh

Dave Winer


Philip Greenspun

Joel Spolsky

Tuesday, February 04, 2003

New story: Mission in transition

New column: Redevelopment funds proposal pits large cities against small


Been doing some research into online community data models and database implementations. Thus far that mainly means reviewing Philip Greenspun's seminal Philip and Alex's Guide to Web Publishing, in particular chapter 3, scalable systems for online communities and chapter 12, Database Management Systems.I've read his book several times over, but it was always too easy to just skim the SQL bits.

Then Greenspun is also publishing SQL for Web Nerds, which I am busy reading right now. Trouble is, he writes from an Oracle perspective, and I am going to have to try and implement everything in the somewhat icky, non-ACID-compliant but free from my gracious Web host MySQL.

Models of community sites: Slashdot for its cool distributed comment moderation system and extensive personalization options; photo.net for its educational utility, ability to attract and retain sophisticated, experienced and skilled long term users who teach others, for its diversity of input points and for excellent static content; Epinions for mass moderation approach and ability, at least once upon a time, to instill user loyalty; craigslist for community focus and utility; Scripting News for lack of discussion groups, effective use of partner weblogs and successful masquerade as a news and opinion blog. MediaNews for showing what can be done with conventional e-mail (see "Letters" section).

More updates