Getting a list of stored procedures out of MySQL

Ick!

select SPECIFIC_NAME from information_schema.routines;

Sheesh!

MySQL command-line pager

msql has support for altering the pager's behavior. Current favorite found by a friend:

msql > pager less -n -i -S -F -X

This allows you to view "wide" tables... as tables! Vim navigation is available, as are the arrow keys. Try hitting the right arrow key. Come back when you're done. I'll wait here...

I know, right? You're welcome!

ATI 5850 Installed!

Earlier this week, I crossed my fingers and hit the purchase button on an ATI 5850. I must say, installation could not have been easier, and the results have been spectacular.

I've got an old 1.8 GHz C2D 6300 with two gigs of ram, and an ancient NVidia 7800 GTX driving a 24" monitor. Games were getting slow.

Adding this card did exactly what I wanted to do. I can run all my games at native (1920 x 1200) resolution with maxed out detail settings.

For my next trick, I'll try grouping my monitors to see what that's like (3520 x 1200). Stay tuned.

Troubleshooting Netflix on the PS3

I recently had the Netflix disk for the PS3 suddenly stop working. It would just halt at the red splash page, and never seem to move on. I'm not sure the deactivation of the device step is required, but it's part of the path I followed to the solution.

1) At netflix.com, deactivate the PS3 device
2) Ensure that the time settings on the PS3 are set by Internet
3) In the video section of the cross-bar, go to the BD-Live utility, and delete "Netflix"
4) Insert the Netflix disk, and let it do its thing

I'm sure step three is the magic step, but I wanted to record everything just in case.

Roll back to a previous revision in Subversion

Excerpted from http://aralbalkan.com/1381

To revert to a previous version of your application (roll back changes) in Subversion, you merge the changes from your current revision back to the revision you want to revert to. So, for example, if you want to revert the trunk of your application from revision 73 to 68, you would do the following:

1. svn merge --dry-run -r73:68 http://my.repository.com/my/project/trunk
2. svn merge -r73:68 http://my.repository.com/my/project/trunk
3. svn commit -m "Reverted to revision 68."

Step 1 will perform a dry run and show you what the merge will produce. If you want to see exactly what changes will be applied, do a diff:

svn diff -r73:68 http://my.repository.com/my/project/trunk

F*ck you, Twilight

This... is genius

Watch this. Then watch the other 6 parts. I came to the same conclusion as this guy years ago, but his surgical analysis of one of the biggest let-downs in popular culture really is stunning.

Several points for disarming, self-deprecating humor awarded. A few are lost during some slow bits. Overall score: 9