Michael Yakobi sent us this clever use of MySQL's user defined variable syntax to return row numbers in a result set:
Occasionally, one wants to execute a query and have the rows in the results set numbered. This could be done using a variable. For example:
SELECT @row := @row + 1 as row, t.*
FROM some_table t, (SELECT @row := 0) r
I haven't used this feature of MySQL before, but it looks like it could be pretty useful. The user defined variables are scoped to a connection but persist between statements, so you can use them to store intermediate state information between queries or even perform iterative calculation within a single query, as was done in the example above.
All platforms with Firefox: The SiteLauncher extension adds a keyboard launcher for your favorite bookmarks in Firefox.
Once you've memorized the keys that go along with your most-used bookmarks, you can just hit the "Direct to Site Hotkey" plus the letter and off you go, no prompt involved. Of course all the URLs and keys associated with them are configurable. Quicksilver lovers will recognize this interface, which is a little easier to get used to than straight-up Firefox bookmark keywords. SiteLauncher is a free download that will work wherever Firefox does; thanks to the creators for including Lifehacker as a default entry.