links for 2007-05-15

• 
  
  10 Tips for Optimizing MySQL Queries (That don’t suck) | 20bits
  
  
  (tags: mysql optmization database sql performance)
  
  

Jonathan Coulton in NY Times

The New York Times has an article on Jonathan Coulton.

[via Slashdot]

Findory Neighbors

I just discovered that Findory generates an interesting "blog cloud" of the blogs that are related to each other.  Some of the blogs listed on my cloud are pretty interesting.

DeepSleep

Normally when I bring my computer between home and work, I shut it down.  I mainly do this to prevent it from waking up, and have the drive jostled while it is spinning.  The downsides of this are that it takes a long time to start back up, and I lose all of the current state.

I have started to used DeepSleep to put my Mac Book Pro in "hibernate" mode.  In this mode, The state of the memory, registers and CPU state are stored on disk.  When the computer starts up, this file is read, and the state is restored.

links for 2007-05-11

• 
  
  DIGG button
  
  
  The Digg button mimics the popular Digg.com website: each time you push the button, the button flashes "Dug" and increments the counter up to 999 "diggs".
  
  
  (tags: electronics diff hardware diy make solder kit)
  
  


• 
  
  Spamtrap
  
  
  Spamtrap automatically prints, shreds spam
  
  
  (tags: spam art email web shred)
  
  

Time wasters

Here are some pretty fun flash games.  It is very easy to spend a lot of time on these games:

• Doodle - move a stick figure across a map, without getting erased.


• Desktop Tower Defense - prevent waves of "invaders" from getting across the map.

[via TechCrunch, Download Squad]

Mail.app Smart Mailboxes

This post has some pretty handy smart mailboxes for Mail.app.  These make it easy to list the:

• Flagged messages in the Inbox


• Recently viewed messages


• Recently sent messages


• Messages from a sender listed in an Address Book group