Aaron Parecki

This is primarily targeted towards graphic designers, although anyone can benefit from the information here as well. This post focuses on the hardware of a laptop rather than the software. I figure I’ll save a talk about software for a different day.

presented by Aaron Parecki & Effie Siverts

I just stumbled across Google's Treasure Hunt. They're always doing neat things, so I checked it out. It's a series of four problem-solving puzzles released one week at a time. I found out about it after the first question was already over, so I jumped in starting with the second question.

When you have a database of books or movies, some of the titles begin with "The." If you do a regular ORDER BY on the table, all the titles that start with "the" get clumped together. One option is running an unsorted query and sorting in PHP, but it would be better to sort at the database level. Here is a query I came up with to do that, using an IF function in MySQL!

This is pretty much the coolest thing in the world! I am posting from my laptop which is connected to my cell phone's wifi connection, using Sprint's EVDO connection to the internet. The software that enables me to do this is called wmwifirouter. Earlier this month they released their first final version of the software, and started charging for it. It's not outrageously priced, but you can still find the earlier free versions on the internet if you search for versions 0.90 or 0.89.

Well I did it! I got the HTC Mogul on Sprint's SERO plan. Everything has been pretty painless so far. Activation was easy, text messaging works, and Internet browsing is pretty fast! Now comes the hard part: getting my data to sync between Windows Mobile and OS X.

But not in the radiation kind of way... in the omg-too-many-things-to-think-about kind of way.