VACUUMing your mail.app with SQLite

Via BoingBoing and Cory Doctorow (who switched to Ubuntu from Mac OS X), a speedup tip for mail.app – pretty easy and fast.

  1. Close mail.app
  2. Backup your mail
  3. Open a terminal window
  4. Go to your mail directory with cd ~/Library/Mail
  5. Start SQLite (which is installed by default) with sqlite3 Envelope\ Index
  6. Clean up your mail DB with vacuum subjects;
  7. Wait for the sqlite prompt to reappear
  8. Exit SQLite with ctrl-D
  9. Open mail.app again and enjoy the improved speed!
5 Mar 2007, 12:56am
mindstorms
by Pedro Pinheiro

2 comments

Lego Mindstorms

Fulfilling a long time dream, last week I ordered a Lego Mindstorms NXT kit. It’s a great way to get my lets-build-things neurons working again, and to return a little into programming, with the difference that your “programs” roam around your living room! :-D

Here are the results of this first week, this is my second robot “designed” by me (if you call “lets see where this is going while I’m building it” approach anything resembling the act of designing something), and the software I “wrote” in NXT-G. The program is basically:

  1. make the robot go forward until it stops if
  2. the distance as measured by the ultrasonic sensor in front is less than a certain distance
  3. backs the robot up a bit
  4. turns the sensor platform 90º to the right
  5. captures the distance into variable R90
  6. turns the sensor platform 180º to the left
  7. captures the distance into variable L90
  8. turns the sensor platform 90º to the right (to reposition it forward)
  9. compares the distances stored on variables L90 and R90
  10. makes the robot turn 90º left or right depending on which side has the furthest distance available
  11. loop to the beginning

The robot: Robot 2

The program: Avoid Obstacles - 4

The robot in action – Windows Media or Quicktime

 
  
  • RSS Photographs

  • RSS Twitter

  • RSS Blippr

  • Archives