The transformational power of “social” media

This post has been sitting in my drafts for a while. The Clay Shirky video embedded below is one of my all-time favorite videos about social media and technological sociology. I had a few versions of what I wanted to write about this video, but forget all that; the more I think about it, the more I realize it doesn’t matter; just watch this video if you haven’t seen it before. Or, if you have seen it before, watch it again. 

What matters here isn’t technical capital; it’s social capital. These tools don’t get socially interesting until they get technologically boring. It isn’t when the shining new tools show up that their uses start permeating society; it’s when everybody is able to take them for granted. Because now that media is increasingly social, innovation can happen anywhere that people can take for granted the idea that we’re all in this together.
—Clay Shirky

Twitter’s 15-character username problem

Rex has lately been hosting guest bloggers over at Fimoculous, including one with the initials and Twitter name ADM. In my day job, I often am faced with tactical details like “what do we name our Twitter account.” If I worked for Archer Daniels Midland or Association for Downloadable Media, I would wonder what best to name that organization’s Twitter account that fits within a 15-character minimum. @ADM is the obvious choice that is already taken. Twitter needs to do something about that, like it does about a handful of problems. 

Cyberterrorism and the IRS suicide attacker

A terrifying thought hit me Monday while watching this flyover video of Apple’s new $1 billion 500,000 square foot data center in North Carolina.

Forget sophisticated digital attacks on our infrastructure; there is absolutely nothing preventing extreme anti-government thugs like Joe Stack from flying planes into the data centers that increasingly are synonymous with computing, the Internet, the cloud and our lives. 

Data centers are famous for their tight access restrictions, but as we learned in last week’s IRS attack, an aerial attack doesn’t care about access cards and finger print scans. 

Just consider this:

Hitting a few key data centers could be catastrophic. No wonder companies don’t like sharing information about these campuses.

Scariest part is I can’t possibly be the first person to have this thought.

The web’s real-time scalability problem (or Twitter’s 600 tweet per second problem)

Twitter’s geolocation guru Raffi Krikorian recently gave an interview to O’Reilly ahead of next month’s Where 2.0 conference in San Jose. The interview is obviously heavy on how Twitter is working with geo, but the last question, or more specifically, the last answer struck a chord and goes straight to the problem of trying to deal with the massive amounts of real-time data a lot of web players are dealing with today.

James Turner: What do you see as the technical side of geolocation, in terms of what’s going to be the new interesting technologies coming along, and how they’re going to be used?

Raffi Krikorian: From Twitter’s standpoint, it’s how do you accept all of this real-time data, index and analyze it and spread it throughout our system in almost real-time. People have traditionally built a bunch of GIS-like systems on top of PostgreSQL or on top of MySQL, and that’s fine, but it doesn’t scale after a while. After you throw a couple million or a couple hundred million entries at it, the amount it takes for one of those databases to process that, to insert it, all I have to do is select against it, and you can understand it’s untenable for real-time operation. And by real-time, I mean sub-second operation.

So the stuff that we’re doing is more geared towards how can you accept tweets that are coming in at what you can imagine to be an incredibly fast rate. Tweets are coming in, figure out their location, attach appropriate metadata data to it. Store it in our database. Span it out to anyone who wants to look at it. Run research and analytics on it and index it in their search index, and do this all within a couple of seconds on the way through the system. I think there’s a lot of interesting stuff being done out there on how things are being stored, how things are being indexed. But I think our personal contribution will be how do you do it at that kind of speed?

Of course, so far Twitter has been doing an admirable job (Fail Whales excluded) of providing uptime on a service with (forget a couple million) 9 billion rows in its statuses table — a table that’s growing by 50 million rows per day.

Those 600 tweets per second are certainly what turned Twitter away from a SQL cluster to using rival Facebook’s Cassandra system. On Tuesday, Twitter’s Ryan King explained why Twitter is turning to Cassandra.

We have a system in place based on shared mysql + memcache but its quickly becoming prohibitively costly (in terms of manpower) to operate. We need a system that can grow in a more automated fashion and be highly available.

My day job involves a lot of media monitoring with such products at Radian 6. Speaking last week with one of R6′s competitors, I was told that no one in the media monitoring space can really do real-time monitoring — there’s just too much data. I think that’s overstating the challenge a little bit, but it will surely be some time before a company can say it’s “real-time” without employing an army of engineers.

Counting sheep

For anyone who has ever had insomnia, this study reported in today’s Times.

What they found was that subjects took slightly longer to fall asleep on nights they were instructed to distract themselves by counting sheep or were given no instructions at all. But when they were told to imagine a relaxing scene — a beach, for example — they fell asleep an average of 20 minutes sooner than they did on other nights. Counting sheep, the scientists suggested, may simply be too boring to do for very long, while images of a soothing shoreline or tranquil stream are engrossing enough to concentrate on.

Silverman shocks TED

TechCrunch is currently gloating over Chris Anderson of TED’s disappointment with Sarah Silverman’s TED Talk. I love watching the videos of ideas that come out of TED, but I’m also a fan of Silverman’s shock humor. Anderson’s reaction is completely unreasonable, and it reminds me of Stephen Colbert’s 2006 White House Correspondent’s Dinner speech. Silverman, like Colbert, has a certain brand of comedy, and if you don’t know what you’re getting into when you sign on to one of them, that’s your own problem and it shows a real disconnect.

(This isn’t the first time I’ve embedded this video.)

Wing review: Bulldog Northeast and Ginger Hop: Happy Hour Battle

Those who know me or happen to be my friend on Foursquare sure know my favorite hang around town is The Bulldog Northeast. A new favorite since opening last autumn is Ginger Hop.

Despite one being gastro-American and the other Asian-fusion, the two places have some things in common: They’re two blocks apart, part of what I’ve dubbed the Beer Triangle (Mac’s Industrial Sports Bar is the third point of the triangle), have the same 3 p.m. to 6 p.m. happy hour and they both have wings on the menu. Until today, I’d never tried the wings at the Bulldog or Ginger Hop, but what else is one to do on a President’s Day afternoon but eat wings?

Ginger Hop Chicken Wings

Ginger Hop’s wings are listed on the happy hour menu as Hop Wings for just $5. Along with $3 dollar tap beers (I had a Bell’s Two Hearted), I’ll cut the suspense, Ginger Hop wins this battle by a long shot. The wings are just slightly spice and a little bit sticky-sweet; they came covered with scallions and served with blue cheese and celery, and were some of the best wings I’ve had in weeks.

The Bulldog’s wings aren’t on the happy hour menu and go for $8. I got another Two Hearted for $4. Now there aren’t many things on the Bulldog’s menu that I don’t like, but these buffalo wings were way below acceptable. They came in the Bulldog’s signature checkered paper basket; the chicken tasted less than fresh and wasn’t so much coated in a nice thick sauce as swimming in a pool of buffalo juice.

(An aside: try the Bulldog’s short rib sandwich, which is a special this week, but I’m told has a good chance of making it on to the regular menu; absolutely delicious.)

If you’re hungry for wings in Northeast Minneapolis late in the afternoon, do your wallet and a stomach a favor and head over to Ginger Hop.

Which Asus netbook should I buy?

I’m in the market for a netbook; I’ve pretty much got my choice narrowed down to two quite different Asus models: the 1005PE or 1201N.

For all of last year, a netbook was pretty much defined by the following features:

Intel Atom N270 or N280 processor
10.1 display, 1024×600 resolution
1 GB RAM
160 GB hard drive
An inability to play streaming HD Flash video
A webcam
Windows XP
6-10 hours of battery life

The new year brought a couple small changes:

Intel Atom N450 processor
250 GB hard drive
Windows 7 Starter

Here’s how the 1005PE and 1201N stack up:

Feature Asus 1005PE Asus 1201N
Processor N450 1.66 GHz N330 1.6 GHz dual core
Memory 1GB 2GB
Storage 250GB 250GB
Advertised Battery Life
(Real-Life Test Time)
14 hours
(11 hours)
5 hours
(4 hours)
Operating System Windows 7 Starter Windows 7 Home Premium
Display 10.1 inches, 1024×600 12.1 inches, 1366×768
Can Stream HD Flash Video No Yes
HDMI No Yes
Price $390 $484

If you have any experience with either model I’d love to hear it. For me, the main apps for a netbook will be Google Reader, Gmail and Windows Live Writer. An app like Reader definitely benefits from the extra 168 horizontal lines of vertical resolution of the 1201N, and the ability to stream HD Flash video and output it through HDMI is certainly a nice-to-have; but I’m not sure either of those make up for the less-than-half-as-good battery life, the not-as-compact package or the $100 premium.

What do you think?



(Google Reader in Chrome at 1024×600 resolution)

Facebook vs. Twitter vs. Buzz

Facebook vs. Twitter vs. Google Buzz is far from a perfect comparison, but won’t you help me fill in this chart?

  Biggest Strength Biggest Weakness
Facebook Full integrated. Photos, videos, status updates, groups, profiles in one (fairly) easy-to-navigate interface.  ?
Twitter Crazy simple.  ?
Google Buzz  ? Unruly. Still doesn’t know my social circle after years of Google trying to figure it out.