Here I dreamt I was an architect…

Hello blogosphere! I bet you thought you got rid of me, but never fear, my faithful (or obsessive, in some cases) following. Lots to catch up on, so hopefully my fingers don’t get tired – there’s a lot of stuff to talk about.

  • I’ll start with some personal news, involving my ballpark tour thus far. I took a somewhat long-awaited trip to Ohio University this weekend, and thus unexpectedly went to a game at the Great American Ballpark in Cincinatti, OH.

    I say the visit was somewhat unexpected, because as you all may recall, Cincinatti was not on my to-visit list when I made the list back in March. However, given its close proximity to Ohio University (at least somewhat) and inexpensive tickets, I could hardly pass up the opportunity.

    Getting to Cincinatti was somewhat of an adventure, thanks to our fearless leader (ahem, Frankie) but we got there and the stadium looks very nice and new from the outside:

    Great American Ballpark

    The view from our seats was also nice:

    Great American Ballpark
    As nice as the stadium looked, something about it didn’t quite strike the right chord with me. Maybe it was the obnoxious (and dumb) Cincinatti fans, maybe it was the old fashioned organ music playing constantly in what is a very new ballpark, or maybe it was the fact that the Indians simply weren’t playing very well. On a scale of 1 to 10, I’d say the Great American Ballpark gets a solid 6. Nonetheless, a good time was had by all and some more pictures have been posted.

  • I have a suggestion for the people at Apple, particularly those making iTunes.

    One of the coolest features (in my opinion) of iTunes is the ability to generate Smart Playlists, ones which are automatically populated based on rules that you set. For example, one of the preset Smart Playlists is the “Recently Played” playlist, which creates a playlist of all of the items played in the last two weeks.

    But say, for example, you wanted to have all items played in the last three weeks. All you would do is right click on the playlist and click “Edit Smart Playlist”. You get this interface:
    iTunes Smart Playlist

    You can filter by date last played, rating, play count, whatever you want. But what the Smart Playlist feature basically boils down to is the ability to query the iTunes database. For example, the SQL query for the screenshot above (more or less) is:

    SELECT [songs] -- TOP 25 -- not needed here
    FROM TableOfSongs
    WHERE (UNIX_TIMESTAMP() - LastPlayedDate <= 2*7*24*3600)
    ORDER BY LastPlayedDate

    Before really discovering this feature, I made a playlist about once a month featuring my favorite songs at that time. But the last playlist I made was in August 2007, because I created a “Random Favorites” playlist which looks a little bit like this:
    iTunes Smart Playlist

    Notice the “match any” criterion. What I really wish is that there were more options, because as it stands right now, I can only have PlayCount > 5 OR (UNIX_TIMESTAMP() - DateAdded) < (1 * 7 * 24 * 3600) OR Rating = '*****'. What I'd really like is the ability to have PlayCount > 5 OR ((UNIX_TIMESTAMP() - DateAdded) < (1 * 7 * 24 * 3600) AND Rating = '*****'). You can't do that with the current tools, and while that's a meaningless example, if I were given the tools I may never have to create a real playlist again.

    Editor's note, 3/31/2013: I'm replacing these screenshots because the originals no longer exist, but since 2008, many of these features have been added.

  • Hillary Clinton is still alive - not only alive, but alive and kicking. The primaries in Kentucky and Oregon are tomorrow, and most experts expect that Clinton will win Kentucky while Obama will win Oregon. And "Operation Chaos" continues.

    Clinton should really drop out unless she wins Oregon tomorrow - meaning that she should simply drop out. She's hurting Obama, whether she likes it or not (and secretly, I think she enjoys the fact that she may not win the election but she'll still decide who is elected). But we'll see.

  • I saw Iron Man over the weekend, and let me just say this: I was floored. I totally did not expect that movie to be as good as it was, although I did figure it might give me a quote of the day:

    Army: Is it true that you went twelve-for-twelve with the Maxim Girls last year?
    Tony Stark: That is an excellent question. Yes and no. March and I had a scheduling conflict but fortunately the Christmas cover was twins.

It's still way too cold for the month of May - here's to global warming, everybody!

Update: Fixed the SQL to match.



Originally posted on Cleveland, Curveballs and Common Sense on May 19, 2008 at 5:21 PM. Post text content © 2008 Jimmy Sawczuk. All rights reserved.

Comments