Exploring Apps4Edmonton using Microsoft Live Labs Pivot

You’re going to hear a lot more about apps over the next few weeks! The deadline for submissions for the City of Edmonton’s Apps4Edmonton competition was Friday evening. Local developers came up with more than 30 really interesting and useful local apps, which will now compete for your votes and for the attention of the judges. You can learn more about the prizes and the competition here.

I started looking at some of the apps, and decided I wanted a better interface to browse them. I thought it would be nice to be able to sort the apps, to see a screenshot of each one, and to see which datasets each of the apps made use of. I also didn’t want to spend too much time on it, so with all of that in mind, this seemed like the perfect opportunity to experiment with Pivot.

Here’s what I came up with! Click on the image below to load the Apps4Edmonton Apps Directory in Pivot. You’ll need Silverlight 4 installed for it to work. Alternatively, if you have downloaded Pivot and have it installed on your computer, you can browse to this URL inside Pivot.

Click here to launch the Pivot!

Might take a minute or two to load. If it doesn’t, just refresh it. What you see are all the apps from the contest page, with a screenshot, description, contest URL, and list of datasets for each one. If you want to see just the apps that use the “Police Stations” dataset for example, you can select it in the navigation pane on the left and the view will update.

Ever since TechEd, I’ve been really interested in Microsoft Live Labs Pivot, an interactive data visualization technology. It’s great for exploring large datasets, identifying relationships, visualizing patterns, etc. The Apps4Edmonton dataset isn’t very large of course, but the tool still does a great job.

How It Works

I started out by building a Pivot Collection using Microsoft Excel. Pivot has a pretty handy tool for turning spreadsheets into collections, so that’s what I used initially. Quickly though I realized that I wanted to host this on the web somewhere, and that I wanted others to help me refine the dataset.

I uploaded the spreadsheet to Google Docs, and then downloaded the Just In Time Pivot Collection sample. After a little bit of experimentation with the Google Docs API (which I have never used before) I had the code working to create my collection on the fly. It loads the spreadsheet from Google Docs, creates the collection, and then serves up the XML and Deep Zoom images.

The spreadsheet is mostly complete, but a few apps are missing datasets. This is because either it wasn’t immediately obvious which they were using, or they simply don’t use any that are part of the data catalogue. You can update the spreadsheet here.

If you’d like to experiment with creating your own just-in-time Pivot Collection, you can download the sample code here and the code for the collection I wrote here. I also made use of CutyCapt to generate screenshots. You’ll also want to check the XML schema.

Apps4Edmonton

There are some really great apps in the Apps4Edmonton competition, so check them out. You’ve got until September 10 to vote for your favorite ideas and apps!

And for full disclosure, I submitted ShareEdmonton to the competition. If you like it, vote for it!

UPDATE: Thanks to John for helping me get the Pivot Collection right!

I love Opera 10

As long-time readers will know, my web browser of choice is Opera. I’ve been using it as my primary browser since at least version 9.0, which came out over three years ago. On September 1st, the latest version was released:

In a world of ordinary Web browsers, Opera 10 stands out from the crowd with innovative new features wrapped in an elegant, fresh interface. Opera 10 is absolutely free, comes in 43 languages, and works on Windows, Mac and Linux platforms.

Opera 10 really does look fantastic, and has a decent list of new features. Interestingly enough, I haven’t found the most touted feature, Turbo, all that useful. I suppose I haven’t really used it on a slow connection however, and that’s what it is designed for.

Here are my favorite things about the new release:

  • Speed. Opera now loads Facebook and Google Reader as fast as, if not faster than, Chrome. I used to leave Chrome open for those apps, but not since Opera 10.
  • The big, beautiful new icon, as seen above.
  • The updated interface. It’s slick, and I love the little circle notification when a tab has been updated. Visual tabs are also pretty neat. I also enjoy that I can get rid of the File menu.
  • Spell checking built-in. Yes I know other browsers have this.
  • Customizable speed dial! You can now increase the number of buttons on your speed dial.
  • Built-in auto-updates. This is long overdue for Opera, and works quite well (I was using the betas and release candidates which got auto-updated).

Favorites I mentioned about versions 9.5 and 9.1 are still relevant too!

If you haven’t tried Opera, I encourage you to do so. It’s a fantastic browser! Others seem to think so too – Opera 10 was downloaded 10 million times during the first week of release. Pretty impressive.

Windows 7 Feature Request: Unified Application Updates

I’m sick of the way software updates are handled in Windows, and I want a new unified application update center in Windows 7 to solve the problem. Apparently Microsoft is asking Windows 7 beta participants questions related to “a single place for finding and managing updates on my PC.” The survey seems to go beyond updating however, and covers installing, uninstalling, configuring, and even discovering new applications. I think they should keep it simple – make updating applications easy.

The problem today is that every new application ships with its own update mechanism, if it has the ability at all. I can’t tell you how many times I’ve told the Adobe Updater to screw off because it has started automatically downloading 500 MBs worth of updates in the background. At least Logitech asks me before it starts using my bandwidth. Why is it bad for each application to have its own updater?

  • Instead of one OS component running to perform updates, dozens of little apps or background processes may be running to support the various applications you have installed. Each one takes resources.
  • Every time I want to configure an updater, I have to start from scratch because they all have different interfaces and options. This wastes my time.
  • Related to the previous point, if I want to see if my applications are up-to-date, I have to check each one individually! Again, this wastes my time.

I’m not sure exactly how Microsoft would go about implementing this (do Adobe servers push notifications to Microsoft servers?) but I think it should be like Windows Update on steroids. Here’s what I want:

  • The ability to see all of my applications and whether or not they are up-to-date.
  • The ability to define a schedule for downloading and installing updates, preferably on a per-application basis.
  • The ability to see a complete history of application updates.
  • The ability to easily suspend all updating temporarily.
  • Options for notifications. I want to be notified about some application updates, and others I never want to hear about.
  • The ability to have a restore point set before each update.

I think having unified application updates would drastically improve the user experience on Windows. It would reduce user frustration and improve system performance and security. The survey is definitely encouraging – I hope this becomes a reality!

Thoughts on Google Chrome

As you probably read or heard today, Google has released a beta version of their very own browser, named Chrome. You can download it today for Windows XP or Windows Vista, and Google promises that Mac and Linux versions are coming soon. I downloaded it as soon as it was available, and have been playing with it all day. Here are some of my impressions and thoughts so far:

  • The interface is surprisingly simple. I like it.
  • Chrome is fast. The two sites I’ve noticed the greatest speed difference with so far are Google Reader and Buxfer.
  • I love the “Create application shortcuts” feature. The first thing I did after testing that out was uninstall Mozilla Prism. This feature is what will keep me running Chrome.
  • I like having the status bar at the bottom of the window, so the fact that it is missing in Chrome will take some getting used to. Fortunately a box still appears when you hover over a link.
  • Firefox made an effort to look more “native” to the operating system with version 3, and I wish Google had done the same with Chrome.
  • A couple of my favorite Opera features are built into Chrome: paste and go, search shortcuts (such as “g” for Google”), and the “Speed Dial” page, though it is automatically created in Chrome vs manually created in Opera.
  • As a web developer, I’m incredibly grateful that Google built Chrome atop the WebKit rendering engine, rather than creating yet another one for us to test against.
  • I find it amusing that the Google Chrome logo has the same color scheme as the Windows logo.

Google very creatively launched Chrome with a web cartoon written by Scott McCloud. It’s quite long, but worth a look.

If you’d like to read more about Google Chrome, I suggest the following:

And for my own reference, here is the NYTimes launch article.

I’ll be sticking with Opera for now, but I’ll definitely keep my eye on Google Chrome.

I love Facebook Mobile via text messages

facebookBuilding a mobile application that works really well is hard. In general, I think we put up with sub-standard mobile applications simply because they offer convenience, not because they blow us away. The iPhone is definitely changing things but for the most part, I still cringe when I need to use most mobile apps. Especially ones that claim to work over text messaging. There’s only one SMS app that I really like – Facebook.

I think Facebook has absolutely nailed the text messaging experience.

Use it for a while, and you’ll realize that the SMS functionality of Facebook is so much better than everything else. Take Twitter, for instance. One of its original claims to fame was that it worked well over SMS. Except that compared with Facebook, it absolutely sucks.

Here are a few of the reasons why Facebook over text messaging rocks:

  • You can do many different things. You can update your status by prefixing your message with the @ symbol, or write on someone’s wall by prefixing the message with “wall Name”. Similarly, you can send messages by prefixing with “msg Name”.
  • Facebook will ask for clarification. If I send a message prefixed with “wall Kim” it will ask me which Kim I mean if it can’t figure it out automatically.
  • Context! Let’s say someone sends me a Facebook message, which I have set to come to my phone. All I need to do is reply, and it will send a Facebook message back. Same goes for wall notifications. I don’t need to specify the “msg” or “wall” because Facebook understands the context.
  • Taking that to the next level, Facebook over text messaging is “multithreaded”. By that I mean, there is more than one number. If I get two messages, they’ll come from different shortcodes, so that when I reply Facebook knows which one I am replying to.

The key difference between Facebook SMS and other applications, is that idea of a session. The way that my reply to a notification is not isolated – Facebook understands some of the context around it. It makes the whole experience so much better.

Another major plus with Facebook over text messaging is that it’s both fast and reliable…unlike Twitter. I’ve never had any problems with it – it just works.

If you don’t already make use of Facebook Mobile, I encourage you to give it a shot. You can learn more about the SMS features here.

Five iPhone / iPod touch applications I want

appstoreI finally got my iPod touch updated to the new 2.0 software today. I had tried repeatedly yesterday, but eventually gave up due to all the errors. The download was about 230 MB, and it took about an hour to get installed with all my data restored. The update costs $9.95 for iPod touch owners and is free for iPhone owners.

The first thing I did was poke around the App Store in iTunes. Pretty quickly though I realized that the best way to browse it is actually on the device itself. So far I’ve installed Twitterific, Evernote, the New York Times app, and the Facebook app. The second thing I did was get Exchange working. The applications are cool, but right now the Exchange support is what makes the update worth it for me.

I know that more applications will appear over time, but right now it seems like there aren’t very many useful ones. Here are five applications I’d love to see:

  1. Remember the Milk – They’ve already got a web app for the iPhone, but I’d love to see a full app complete with offline access to my task list. I’d be surprised if they didn’t create one, actually. This is the app I want most.
  2. Buxfer – I use this app all the time to manage my personal finances, and I’d love to have on-the-go, offline access.
  3. Brightkite – Apparently they have one in the works, and it should be ready by the end of the month. I hope it has some sort of auto-check-in feature (based on the network I’m connected to or something).
  4. Ping.fm – The current web app works great, but it would be better to not have to open up the web page and possibly log in.
  5. WordPress or Windows Live Writer – I’m not sure how often I’d post to my blog from my iPod touch, but it would be cool just to know that I can.

A couple of honorable mentions: a better weather app than WeatherBug (from Environment Canada would be wicked) and some sort of FriendFeed app.

What applications do you want?

My favorite things about Opera 9.5

opera 9.5 Everyone is talking about Firefox 3, but I’d like to take a moment to talk about a different browser! On June 12th, Opera released the latest version of its desktop web browser. Version 9.5 includes a bunch of new features and lots of incremental improvements. Here are some of my favorite things about it so far:

  • Faster. Opera says the new version is twice as fast as 9.2 at rendering HTML and Javascript, and my experience would support that. I haven’t timed it obviously, but 9.5 does indeed seem quicker.
  • Quick Find. Firefox 3 has the so-called “awesome bar” that remembers page titles and such, allowing you to type in the address bar to find pages you’ve visited in the past. Opera 9.5 does this too, and a whole lot more – it indexes the actual content of pages! Remember a word you read on a page you visited? Type it in the address bar, and Opera will help you find it again. Very slick.
  • Vista stability. I don’t think this is an official improvement, but 9.5 definitely seems more stable on Windows Vista than 9.2 did.
  • New look and feel. When I first launched 9.5, I was a little surprised at the black default theme. After a day or two of using it though, I’m hooked. I love it. It looks great on Vista too.

Opera 9.5 also has support for Extended Validation (EV) certificates – finally!

One new feature that I haven’t tried yet is Opera Link. It allows you to synchronize your bookmarks and Speed Dial settings between computers and devices. Firefox 3 has a similar feature. It’s a great idea for the average user, but for someone like me who uses del.icio.us, it’s kind of useless.

Of course, my list of ten things to love about Opera from last year is still valid too!

Want to give Opera 9.5 a try? You can download it here.

Coming soon: Clean up your Facebook profile

Post Image Apparently Facebook is gearing up to release a "profile clean-up" tool that, if enabled, will only keep a user’s top 12 applications on the main profile page, and will move the rest to an extended profile. They say they are implementing this feature in response to user feedback:

As time has gone on, we’ve received increased complaints from users that friends’ profiles are getting too cluttered, and that people are having trouble finding the information they are looking for on their friends’ profiles. On the other side, users are complaining that their own profiles are cluttered, and they have installed so many applications that it has become overwhelming to un-clutter it.

I can see how this fixes the latter problem, but how exactly does this help the user looking for their friend’s wall? As I understand it, the clean-up tool is an optional thing, meaning that unless a user cleans up their profile, it will still be overloaded as hell. I can think of more than a few friends who desperately need to get rid of their thousand applications. I don’t visit their profiles anymore, because it has become nearly impossible to do so!

What I’d really like is a "hide all applications across the site" button. Not that they’d ever give me that, but I can dream can’t I? Heck, while I’m at it an "automatically ignore all application requests" button would be nice too. Get on that will you Zuckerberg? And let me know when it’s done – kthxbye!

For more, check out ReadWriteWeb and FaceReviews.

Read: Facebook

Safari comes to Windows

Post ImageIt’s no secret that an incredibly large number of web developers build sites only for Internet Explorer, ignoring standards and other browsers. It drives me nuts. Unless instructed by the client to focus on a particular browser, I build sites that work on as many different browsers and platforms as possible. Take Podcast Spot, for instance. We want it to work anywhere, no matter what technology the user happens to have installed. So far, I think we’ve done a good job. There’s always room for improvement however.

Since we’re a “Microsoft shop” we don’t have any Macs in the office. For testing, we’ve relied on friends and the incredible BrowserCam service. It would be nice to just have a Mac though. Or, you know, Safari on Windows:

Apple® today introduced Safari™ 3, the world’s fastest and easiest-to-use web browser for Windows PCs and Macs. Safari is the fastest browser running on Windows, based on the industry standard iBench tests, rendering web pages up to twice as fast as IE 7 and up to 1.6 times faster than Firefox 2.

Let me first say that I think this is absolutely fantastic news! The more standards-adhering browsers available the better. That said – what about Opera?! Dammit why does everyone ignore the best cross-platform browser. Argh!

You can download Safari here. It’s just over 8 MB. I just installed it and already found a bug. I have three monitors, and dragging Safari to a different screen than the one it launched in and maximizing causes the application to disappear. Oh well, it’s beta. Looks exactly like Safari on the Mac to me though (and that kind of sucks, I hate how Apple completely ignores the Windows look and feel).

There’s lots more discussion from around the blogosphere here.

Read: Apple

Ten Years of Visual Studio

Post ImageI missed this last week, but March 19th was the ten year anniversary of the release of Visual Studio 97 – the first release of the Visual Studio product. Rob Caron has written my thoughts exactly:

Visual Studio has come a long way in that 10-year period.

I remember Visual Studio 97. It was sitting around in my Dad’s office, and I asked if I could “borrow” it. Who knows why they had ordered it…they never used it! I might even have the box around someplace.

I love Visual Studio. It’s a great product. More than that, it’s a great environment…and it now forms the base environment of tools in SQL Server and BizTalk Server, among others. Combined with the expanded lineup of SKUs, you could say that Visual Studio is taking over the tools scene at Microsoft!

Despite coming a long way in ten years, there’s much more on tap. Check out the future releases page for more info.