Archive for June, 2010

Computing, Work

MySQL Training

A few weeks ago, I went to a MySQL training seminar focused on developing and tuning high-availability applications with MySQL, hosted by Percona and paid for by my work. It was an extremely informative seminar. We’ve hired the people at Percona before as our database ninjas, as I like to call them. They are not at all cheap to hire for consulting, but they are absolutely worth every penny. These guys live and breathe MySQL.

Anyway, I took away some good tidbits from the session, but more than that I gleaned some good general philosophies. For example, when diagnosing a problem first make sure it’s really a problem. If only a few users are experiencing it intermittently, then maybe it’s not worth 40 man-hours to investigate and fix. Another tips is: have good instrumentation. Don’t take educated guesses as to what might be slow — build in some metrics so that you can see exactly where a problem is.

A lot of this stuff is still sinking in, but I’ve already started putting some of it to use immediately. Good company investment, and a good personal investment too.

Reviews, tech

iPhone 4 Preliminary Review

I got my iPhone 4 a day early (thanks to ordering it through the Apple website), and have taken some time to try out its features. I’m coming from a 3G though, not a 3GS, so this thing is probably more impressive to me than it would be to someone with the latter.  So, review below, with important parts in bold.

General Feel

This thing is way more responsive than the 3G. Then again, the iOS 4 did seem to speed up my 3G a bit too, but it was still fairly laggy for most things. The iPhone 4, however, feels just about as snappy as the iPad (which is to say very snappy).

The battery life seems good.  The first day I used it more than moderate but less than heavy/constant, for about 8 hours — recorded maybe 6 minutes worth of video, lots of app downloading and use, compressed a couple of videos and sent them to YouTube, etc. I also had WiFi and Bluetooth on. That used up about half the battery, which is nothing magical, but still pretty impressive. Second day, with a bit of talking, Bluetooth turned off most of the day, and medium to light usage, between 10am and 6pm the battery is at 70%. Not too shabby.

I didn’t think that I was going to even notice the snazzy “Retina” display that packs tons of pixels in tightly, but I actually do notice things being much more crisp.

Form Factor

I’m not in love with the design, but I don’t hate it either. It is rather annoying that accessories that I bought for my 3G (like case/protector, car dash mount, etc.) won’t work with the iPhone 4. It is thinner though, which is subtle but can still be noticed, and I like the design of the buttons — raised and separate.

The smudge-resistant glass actually works fairly well. Well enough that the smudges that do show up are subtle, and get cleaned off completely when I put the phone in my pocket and take it back out again.

Video/Photos

The camera does seem to take better low-light pictures from my preliminary tests, though nothing magical — you’re not going to get great low-light photos from any smartphone with current technology. That’s mitigated by the flash though; the LED flash does seem to help a lot. The general picture quality of the front-facing (main) camera is quite good. About as good as a point-and-shoot camera in fact. I took the picture on the left last night (click on it to see the full-sized version). It was enough of a close-up that I had to tap to focus.

Video quality is good, though holding the phone in your hand to take video isn’t the most natural thing in the world. It also disappointed me to discover that you can’t switch between the front and back cameras when recording video — it’s either one or the other.

There is also a built-in utility to upload to YouTube. On the downside, it downsamples to 320p, so no uploading hi-def videos directly to YouTube from your phone. On the plus side, that means it doesn’t take a year and a day to upload videos. I’d like the ability to control this.

The rear-facing camera seems pretty decent. Not as swank as the front-facing camera, but definitely good enough for basic self-photos. One thing that would have been nice is a fake flash for this. I bet someone will make an app for that — something that makes the screen mostly white but shows just enough of what the front camera is seeing so that you can tell what you’re taking a picture of.

iMovie

iMovie is pretty basic, but a cool toy. It allows you to do some very simple video editing like adding a single non-DRM song as background accompaniment to your video project, mesh multiple videos and/or photos together (with some basic transitions), add a Ken Burns effect to your photos, and add a title to your video.

Things that I think that I should be able to do in iMovie, but can’t:

  • Set the volume level of the music clip.
  • Set the music clip to start somewhere other than the beginning of the video.
  • Make the music clip start somewhere other than the beginning of the song (so I can start playing at the good part of Final Countdown, for example).
  • Crop the music clip, to make it stop playing when I want it to.
  • Insert a title over a photo (it can only be added to a video clip as things stand).
  • Add multiple music clips.
  • Insert an image into the middle of a movie clip, so that the clip pauses to show the photo, then continues.

Here’s a link to a quick clip I tossed together of Link at White Wolf | CCP getting “iced” at work, video taken on iPhone 4 and edited with the iMovie app.

Miscellaneous

You lose reception if you hold the phone in your left hand. This is apparently a known issue, and Apple’s reaction has been less than reassuring. I’m not sure if this can be fixed (without a recall of some sort), and it’s pretty astounding that it got through Apple’s QA. I’ve heard that this issue is also fixed by using the bumpers that Apple sells, so I assume that when protective cases come out those will solve it too. So while it’s certainly a bad flaw, functionally it won’t affect most people. I’m assuming that most people will use a case anyway — otherwise the screen is at risk of breaking if you drop it.

The voice commands are new to me, since I didn’t have a 3GS. They seem to work fairly well — not much better or worse than your average voice command system.

Conclusion

The iPhone 4 is definitely a worthy upgrade from a 3G. If I had a 3GS… maybe not so much better that it’s worth another 2 year contract and $299. Probably not worth it, really. In fact, I’d probably have been better served to get the discounted 3GS, but I’m a technophile and have to have the latest and greatest. The camera quality is great, the phone itself is responsive, and though it’s definitely not the perfect phone, I am quite glad that I upgraded.

Reviews, tech

iPad Follow-Up: Thoughts, Apps, Etc.

I really do like this thing. I’ve actually got myself a messenger bag (i.e. man-purse) just so I can tote it around, in fact.  I plan on getting a stylus for it, since I think its note-taking abilities will be rather keen.  Who needs a moleskine?
As an update on the PC charging issue, most motherboard manufacturers have resolved this issue.  My manufacturer (Gigabyte) even came out with a quick-charge update to charge the iPhone and iPad even faster.  Huzzah!  However… it still doesn’t actually charge when I hook it up to my system.  Boo!  Might be that I’ve got too many other USB accessories plugged in.
Speaking of accessories, I would very much like a case that both stands up, and also has some internal pockets for holding papers, cards, or whatever.  These two features seem to be mutually exclusive from what I’ve seen, but there’s no reason it can’t be done.
Okay, on to some apps that I like:
  • NetFlix – This is probably what I’ve been using it for the most.  Kick back in bed, watch an episode of Avatar the Last Airbender.  This also seems to work well over 3G, not just WiFi (though I’ve only tried in areas with full-bars of reception).
  • GoodReader – GoodReader iswas a mandatory app if you plan on reading PDFs on your iPad. However, iBooks is going to handle PDFs soon, so I’d wait to see how well that works before shelling out money for GoodReader.
  • HarborMaster – Neat little strategy game, that’s free. Well not really “strategy” — you have to direct different boats into different ports, and then back off the screen, without letting any crash into one another. It’s harder than it sounds.
  • Dropbox – File syncing service, which is also accessible via iPad. I’ve found this quite useful for work.
  • EverNote – Not nearly as useful without having a camera, but still a great application for compiling random notes. A favorite amongst people of the GTD philosophy.

And the built-in photos app is just too cool.  Check out the demo here (Photos is the third one down, my favorite bit is about 2:40 in).

Really the big feature is the 3G connection though. I’ve found this useful enough for work that even if they hadn’t got me one, knowing what I know now I’d have bought one myself.

tech

iPhone 4 vs. HTC EVO

I’m deciding between the iPhone 4 and the HTC EVO.  I’ve wanted to try out an Android phone, but I’m really on the fence here. So I’m rounding up the benefits of each that are important to me (so I’m not including things like how the iPhone 4 supports wireless-N, or how the EVO has a 1.3mp front-facing camera as opposed to the 640×480 one on the iPhone 4, or how the iPhone 4 has a higher-resolution display).

iPhone

  • Better battery life. The first iPhone and the 3G models had pretty crappy battery life, but this seems to get better with each iteration. All reports of the EVO say that its battery life is horrendous.
  • I’m already used to the interface. This is a minor quibble, but I already know how things work on the iPhone.
  • More refined user experience. Even with the modified version of Android that the EVO runs, the interface on the iPhone is more refined.
  • I’m already with AT&T.  I’m really not a huge fan of them, but neither do I hate them. Familiar devil, I suppose.
  • Better video chat.  The EVO has the front-facing camera, but the only real video chats supported are through Fring and Qik, and that doesn’t seem to work too well. Then again, realistically I’m not likely to use video chat a whole lot anyway.

HTC EVO

  • Not a closed system. Anyone can make Android apps.
  • Integrated kickstand.  Yes this is lame, but could definitely come in useful, especially with video chat.
  • Better alert system.  It’s not limited to one alert message at a time like the iPhone. I suspect since this is a big flaw in the iPhone future updates might fix this though.
  • About $20/mo cheaper. That’s almost $250 per year, $500 over the life of a 2-year contract.
  • Tighter Google integration. You can actually have an app for Google Voice, and the built-in navigation system uses Google Street View, which is rather awesome.
  • Supports Flash. This can be a big one for web browsing. Apple, get the fuck off your high horse; HTML 5 is not going to replace Flash.

One big features I didn’t include with the EVO is that it’s 4G.  Frankly, I don’t care.  3G is fast enough for everything I want to do with my phone — if I’m going to stream HD video, I’m going to do it on my iPad.  Plus from all accounts I’ve seen, using 4G sucks the battery life out of the camera like a nympho just out of solitary.

My friend Eddy Webb at White Wolf just got himself an EVO, and posted about it if you’re interested in reading his take.

So far I’m leaning toward the iPhone. I’ve got 3 days to decide.