Real Life Fail Whale

Filed Under Funny, Twitter |

I threw together this image even though we see less and less of the Fail Whale these days. (Thanks @netik and crew!) Hopefully our friend will some day be as rare as the chance of seeing the above.

Sources:
Seagulls from: http://www.flickr.com/photos/pkeleher/1363971024/
Whale from: http://pats0n.livejournal.com/

Comments

My 3,000th Tweet: Juno Reactor

Filed Under Movies and Music, Twitter |

Last night while watching Juno Reactor at The Independent here in San Francisco I hit my 3,000th tweet. The comment was in regards to the completely unexpected Juno Reactor show. I had never seen them live, and had only heard the music in soundtracks or on my ipod. They came out with an intense energy and an interesting stage show with only the performers. The music felt like The Matrix, the female vocalist looked like Pris (Daryl Hannah) from Bladerunner, and there was a definite tribal feel as horns (real ones, not brass) were played amidst unbelievable drumming.

If you want to follow me on Twitter and be there for my 4,000th tweet, my twitter name is edrabbit

Comments

Statistics for Twitter

Filed Under Twitter |

Tweetrush stats for edrabbit

Tweetrush stats for edrabbit

Anyone else out there a statistics junkie? Yes, I’m looking at you, the one with a last.fm account who’s adamant about scrobbling every last mp3 you play so you can generate fancy charts. Well if you’re a Twitter user, you’ll be happy to know about Tweetrush. Tweetrush is a site that will spit back statistics on how many twitters/tweets you sent, what time of the day you send them, etc. Currently they’re only showing stats for the last 7 days, but they’re using data from Gnip, which parses Twitter’s full data feed of all the tweets. This means they could theoretically parse more data as long as they have the servers to handle it. Want to see my (weak) stats? If you’re missing out on my low traffic Twitter, you can follow me here.

However TweetRush isn’t just a fun little Twitter site. It’s a test of the new RushHour engine, an analytics system for measuring actions and events as opposed to raw page views and clicks. RushHour might be just the thing that many sites are looking for to get a more detailed analysis of how people use their site. Unfortunately it’s under a closed beta right now, but you can apply to get into that beta over at rushhouranalytics.com.

Comments

Critter’s New Tattoo: Fail Whale

Filed Under Body Modification, Twitter |

Fail Whale Tattoo

Wow, Critter already sealed the title of “Best Geek Ink” long ago with his Seesmic, ColdFusion, and Adobe Air tattoos. (Did I miss any Critter?) Oh yeah, there’s also the Twhirl tattoo. But now he’s taken it one step further to get another piece of the web tattooed on him. This time it’s the ever lovable Fail Whale from Twitter. He says the white on the whale will show better once it’s healed up.

UPDATE: Of course he had to go and upload a Qik video of it being inked:

Comments

Zappos + Twitter

Filed Under Geek, Twitter |

Looks like Zappos is doing a Twitter experiment while they’re in town visiting the Twitter offices. Not sure what they’re up to, but I’m game.
The original twitter:

If you r in San Fran area, write “Zappos” on back of left hand w/ marker & twitter @zappos link to picture of it. Why? Details to come, 4 PM

And my response:

Comments

Post to Twitter when you post to your blog

Filed Under Twitter, Wordpress |

I don’t like doing things manually when I can have software do my bidding. Usually I’ll send a twitter when I have a new blog post on here that I think people are interested in. (I recognize not everyone has my RSS feed in their feed reader…yet) But it’s a manual process and an extra step, so I went out and found Alex King’s Twitter Tools plugin. Alex King is a name forever associated in my head with Wordpress, primarily for his help in finding themes back in the early days of WP. This plugin is pretty full-featured:

  • Archive your Twitter tweets (downloaded every 15 minutes)
  • Create a blog post from each of your tweets
  • Create a daily digest post of your tweets
  • Create a tweet on Twitter whenever you post in your blog, with a link to the blog post
  • Post a tweet from your sidebar
  • Post a tweet from the WP Admin screens
  • Pass your tweets along to another service (via API hook)

I’ve currently got it set up to send to twitter when a post goes live on here. So in theory, when this post went live, it should have shown on my Twitter page.

UPDATE: Looks like Twitter Tools will post any edits to a posts if that blog post has not been twittered yet. Sorry for the twitter flood when I removed the “Uncategorized” category from a couple old posts. I’m going to look into manually adding the “twittered” metadata to all my posts so it doesn’t happen again.

UPDATE 2: Threw together a quick little php script to update the database so old posts aren’t twittered when they’re edited. YMMV, User beware, no warranty, etc. You’ll want to make a backup of your databases, then fill in your username, password, and database_name and then run this either from command line or via the browser.

/*--------code start--------*/
mysql_connect(localhost, "db_username", "db_password");
mysql_select_db("database_name");
$res1 = mysql_query("SELECT * FROM wp_posts p WHERE (p.post_status LIKE \"publish\")");
while ($row = mysql_fetch_array($res1, MYSQL_ASSOC)) {
	//find out if the TwitterTools metadata has already been written
	$sql2 = "SELECT * FROM wp_postmeta WHERE (post_id = ".$row['ID'].") && (meta_key LIKE \"aktt_tweeted\") && (meta_value LIKE \"1\")";
        print "Post ID: ".$row['ID']."  \n";
	if (!mysql_numrows(mysql_query($sql2))) {
		//metadata not found, let's fake it without twittering
	        $sql = "INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (".$row['ID'].",\"aktt_tweeted\",1)";
		mysql_query($sql);
		print " -- added metadata to fake it.  \n";
	} else {
		print " -- already been twittered.  \n";
	}

}
/*--------code end--------*/

Comments