Updated: April 10th, 2009

Recently I read an article on the Six Revisions blog that discussed 10 seemingly simple improvements to the twitter interface. They included such things as nick autocomplete, mentions, groups, and more.

You could only dream about such twitter improvements… that is until you use the Troys Twitter script. Just perform the following steps and you will have the features I describe in this article. Here we go:

  1. Install Firefox (you already have that, right?)
  2. Install the Firefox greasemonkey extension
  3. Install the Troys Twitter script

Greasemonkey is the most versatile extension available for Firefox, as it’s essentially a whole framework for scripts that can manipulate any aspect of any page. Head over to userscripts.org and take a look at the myriads of scripts written and submitted by other Greasemonkey users.

Once you are done with the above steps, head over to twitter.com (there’s no need to restart Firefox). You will then be able to enjoy the following enhancements, which I ordered here in terms of usefulness to me:

Autocomplete

Do you have a few friends with names so complicated, you can’t type them out by hand? Troys script autocompletes your friends’ names – just type @ and a few letters of their name. This is my favorite feature.

Before:

 

image

After:

image

 

Search Bar And Favorite Searches Saved

A search box is added to the sidebar. You can make a number of favorite searches, which then also remain sticky on the sidebar above the search box. When you click on a search term, the current page is updated without reloading the whole thing. Note that the favorite search terms are saved locally in your browser and won’t show up on your other computers.

Before:

image

After:

image

Auto Expander Of Shortened URLs

Automatically expands url shorteners, so instead of seeing a load of tinyurls and bit.lys, you see proper urls and their native page titles (neat!).

Before:

image

After:

image

Auto URL Shortener

Updated: The URL shortener auto shortens urls as you type them but only if they will overflow the 140 character limit, otherwise they stay as they are (it now works flawlessly).

Before:

image

After:

image

Auto Pagination

As you reach the bottom of the page, more earlier updates are automatically loaded after a few seconds. This means you don’t need to click or leave the page in order to see earlier updates. It could get a bit annoying, so I requested an ability to turn off certain script features. Update: you can now turn off every feature of the script individually.

Auto Media Embed Expander

Pictures and videos are automatically embedded.

Before:

image(Uhmm, I don’t know why I highlighted “sack” but I don’t feel like retaking the screenshot… Yeah…)

After:

image

Retweet (RT) Button

Adds the missing RT button to each update.

Before:

image

After:

image

Autopopulate Bios on User Listings

Updated: This function will save you hundreds of clicks – when viewing someone's followers, rather than just seeing their names, the script adds their bios.

Before:

image

After:

image

Hyperlinked Hash Tags

Hash tags are now hyperlinked to the twitter search page. Seriously, twitter can’t do that by default?

Before:

image

After:

image

User’s Local Time

The script adds a user’s local time. See the example below using the profile of a lovely Kamikazekitty. This feature seems unpublished and I found it by accident.

Before:

image

After:

image

Nested Replies

This is a great feature – it gives context to @ replies. For example, @ev’s reply to kevin is boring and out of context until you see what they’re talking about, all without looking up @kevin’s updates.

Before:

image

After:

image

Mutual Friends Marked

Updated: This is a new feature. People who you follow and who also follow you back (mutual friendship) are marked with a little smiley face.

Before:

image

After:

image

Auto @fxxxmylife Expansion

Updated: Woot! Following the infamous @fxxxmylife is no longer annoying: all posts get auto-expanded. Brilliant. For those who don't know, FML is a site collecting short stories that all start with "Today," and end with "FML". Here are the top FMLs to get you started [hooked].

Before:

image After:

image

That’s it for now in the current script version (6.5) but what a world of difference, isn’t it? Tweet this post if you like it and let your friends know about this great twitter web tool.

 
  • Share/Save/Bookmark

Updated: April 18th, 2008

  • Tom Hanlon of MySQL presents
  • monitoring tool basics
    • SHOW FULL PROCESSLIST
    • SHOW GLOBAL STATUS
    • SHOW GLOBAL VARIABLES
  • basic tools
    • mysqladmin is provided with the server
      • mysqladmin -i 10 extended status: will repeat the same command every 10 seconds. Pipe through grep "and smoke it" (bad pun, hah hah)
      • -r: show only changed values
    • MySQL Administrator
  • cacti
    • rrdtool based network graphing tool
    • uses snmp
    • PHP apache and MySQL based solution
    • MySQL plugins, download and install
    • "poller" gathers data and populates the graphs
    • someone offers munin as an alternative
      • not snmp based, its own agent is used
    • pros
      • cacti is fairly easy to configure
    • cons
      • could be CPU intensive with lots of machines (Perl polling seems to be the problem)
  • zenoss
    • complete network monitoring tool
    • AJAX, integrated with Google Maps (if you don't know where the servers are, everyone laughs at this comment)
  • innotop
    • monitoring innodb, complex output
    • developed by Baron Schwartz
  • mytop
    • similar to Linux's top
    • filter connections on database/host being used
    • queries per sec
  • mtstat-mysql
    • plugin for the system monitoring tool mtstat
    • mtstat provides functionality of vmstat and iostat tools to monitor system activity
  • nagios
    • nagios is more of a notification tool, although it can do graphs
    • pain to set up, text config files, but still the most widely used tool, should be better in upcoming versions
    • NagiosQL is a front end tool for nagios administration (somebody from the audience pointed this out, that's completely new to me!)
    • I offer zabbix as an alternative
    • hyperic is another, apparently very easy to set up, with service autodiscovery
  • MySQL Enterprise Monitor (not free)
    • graphs, monitoring, GUI
    • built by MySQL folks themselves
    • agent based
    • well organized
  • webyog, sqlyog, monyog, mon, heartbeat, moodss, fiveruns are added by the audience members
 
  • Share/Save/Bookmark

MySQL Conference 2008

Monday, March 24th, 2008

Updated: March 26th, 2008

April 14-17th is going to be an exciting time. Why? Because the 2008 MySQL Conference and Expo is going to be held in Santa Clara, CA. Who would want to miss out on a chance to lurk around, let alone talk to, some of the smartest people in the MySQL world? Well, those who don't have at least $1000+, of course. A 3 day pass to the conference without tutorials costs a whopping $1199. A full pass would dry up your pockets $1499.

Well, "good news everyone". Thanks to Sheeri Cabral of The Pythian Group, PlanetMySQL.org, Jeremy, and, most importantly, LinuxQuestions.org, I am now in possession of a 3-day conference pass!! I'm incredibly excited that I will be able to attend and finally meet many geniuses, including the ones mentioned on my Must-Know People In The MySQL Field page. I've never won anything worth over 50 cents before. As a funny side note, there were 4 pages of replies to the raffle post, 90% of them saying that they could not attend (mostly due to living in other countries), so in reality only 2-3 people out of everyone could actually attend. I like those odds.

Here is a link to the oh so colorful conference schedule. I'm particularly interested in this short list of highly exciting subjects:

April 15th

April 16th

April 17th

April 18th

  • temporarily unload all the information gathered in the previous 3 days and drown in beer

Excitement is in the air. Can you FEEL IT?

 
  • Share/Save/Bookmark