I have been messing around with Google Fusion Tables a lot over the past few months and I really like the service. However it really bothered me that the only format that the response data came in was CSV. I also wanted to be able to work with Fusion Tables query data entirely on the browser/client side. So I spent part of the weekend writing an application that proxies Fusion Tables API queries and transforms them from CSV into JSON. I also added a simple Javascript that you can embed on your page and then make Fusion Table queries directly from Javascript.

I posted the application on App Engine and you can find it here: http://ft2json.appspot.com

I wrote it in Python and used Tornado Web Server to help parse requests. Tornado works quite well within App Engine.

I was looking to learn about the Google Data Protocol so I wrote a quick Python script that will fetch Youtube videos by their playlist.

This utility allows you to download all the videos from a playlist on Youtube. It creates a folder in the current directory (or in the specified path) named after the playlist name and then downloads each video in order and places it within the folder.

If the script fails in the middle of the playlist you can restart it with the same options and should pick up where it left off.

The script depends on youtube-dl for the actual downloading of videos. It is also an easy to install Python script.

The script can be found on GitHub: https://github.com/jordoncm/youtube-dl-playlist

You can also get more details on the project page.