Whatever you do, don’t panic!
Web
Audiogalaxy – Your Music. Your Playlists. Hit Play from Anywhere
Oct 22nd
Today I’d like to highlight a software I found out about yesterday called Audiogalaxy.
If you’re about my age you surely remember the peer-to-peer audio file sharing application by the same name that took over Napster’s market share in 2001. Well this software is actually made by the same people only that they’ve shifted their focus from file sharing to a “placeshifting service” as they call it. Audiogalaxy lets you install a small client software on your computer that scans all your music and makes it available to you on the audiogalaxy.com website, Android phones & iPhone. And it’s completely free!
There have already been a number of attempts to offer this kind of service, the one I used quite a bit was Simplify Media which unfortunately was shut down. What makes Audiogalaxy truly stand out for me is it’s easy of installation, performance and iOS integration. I’ll outline the steps necessary to get the whole system up and running on a Mac and an iPhone.
- First go to audiogalaxy.com and click on Sign Up. The easiest way is to use Facebook connect so we’ll choose that option.
- Next you’ll be offered to download the client application for your computer which already has your login data included, so just drop it into your Mac’s application folder, start it and you’re good to go.
- The website patiently waits to detect the client application on your computer which then starts scanning your default Music location.
- It can take quite a while to index a big library, so hop over to your iPhone in the meantime and download the Audiogalaxy App from the App Store.
- Start the Audiogalaxy App on your iPhone, log in with Facebook and you’ll be instantly connected to the music on your computer including all the Playlists you’ve set up in iTunes.
From now on you’ll be able to play all your computer’s music via the website or your mobile device (an Android client is available as well). What makes this service really special is the level of integration they’ve been able to accomplish with iOS. It can really replace you iPod App on the iPhone by offering background music playing, access to play/pause/skip/volume controls via all the available shortcuts and the headset buttons. One last thing I was doubtful about was how it will perform while being on the move, so I tested it out on my morning commute today and let me say I was extremely pleased.
I started music playback before leaving my appartement, so I was still connected to my home WiFi. When I reached the street my iPhone lost contact to the WiFi and switched to 3G, this only triggered a ~2 second gap in playback, after which the music just played on from where it lost contact. Performance on 3G is absolutely brilliant and I could keep on listening during the whole train ride. What was astonishing was that there is a tunnel on my way to work where I know that there is no cellular access at all (phone calls always drop while going through that tunnel), the Audiogalaxy app apparently had enough of the music buffered, so playback continued without interruption. When I got close to my office I once again experienced a little gap in the playback, that was when my phone picked up the company WiFi.
Let me finish of by stating a few things I’d love to see improved/added to the iPhone client:
- Submission of played tracks to Last.fm
- Updating of the playcount in iTunes’ library
- Gapless playback between tracks of an album. If the software manages to play through short signal losses, why not pre buffer the next track as well to offer continuous playback?
Software download Links:

Android market QR code for Audiogalaxy

YQL – Yahoo! Query Language
Oct 18th

The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services.
YQL’s possibilities are virtually endless, say you want to get specific Flickr Images containing a defined word in the title, or you want to geo-code some addresses on the fly. YQL makes those tasks extremely easy by just forming a simple query that gathers the data. Output can be switched between JSON and XML, so you can choose whatever fits best for your application.
The best way to go about using a YQL service is as follows:
- Construct your query using the YQL Console and try out if it gives you the right result.
- Copy the REST Query URL the console gives you at the bottom and insert it into your web app. There are even examples in the documentation on how to use REST queries in different programming environments.
Let me give you an example of such a query:
select * from upcoming.events where woeid in (select woeid from geo.places where text="Vienna, Austria")
This will give you an XML response listing all upcoming events in Vienna, Austria using the Yahoo! Upcoming API by calling the following REST URL:
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20upcoming.events%20where%20woeid%20in%20(select%20woeid%20from%20geo.places%20where%20text%3D%22Vienna%2C%20Austria%22)%0A
This service makes it very easy to use different web APIs without knowing their respective syntax and it becomes extremely convenient when you start joining together different webservices to get a combined result.
I’ll give you one more example here. This gets all the Foursquare places around a particular address sorted by their distance by combining geo.placefinder and Foursquare :
USE "http://www.datatables.org/foursquare/foursquare.venues.xml" as venues; SELECT group.venue.name, group.venue.address, group.venue.stats.herenow, group.venue.distance FROM venues WHERE (geolat, geolong) IN (SELECT latitude, longitude FROM geo.placefinder WHERE text="koenigsklostergasse 7, wien") | sort(field="group.venue.distance", descending="false");
Click here to try this query in the YQL Console.
The really neat thing is that YQL can be used commercially and there even is a fairly decent rate limit applied per IP address that should make it useful in production.
Usage Information:
- YQL can be used for commercial purposes.
- If we’re going to shut down YQL, we will give you at least 6 months notice with an announcement on YDN and in our forum.
- YQL has a performance uptime target of over 99.5%.
- YQL relies on the correct operation of the Web services and content providers it accesses.
Rate Limits:
- Per application limit (identified by your Access Key): 100,000 calls per day.
- Per IP limits: /v1/public/*: 1,000 calls per hour; /v1/yql/*: 10,000 calls per hour.
- All rates are subject to change.
- YQL rate limits are subject to the rate limits of other Yahoo! and 3rd-party Web services.
Some resources:
- 5 Great YQL One-Liners (readwriteweb.com)
- A highly scalable YQL + JavaScript use case (developer.yahoo.net)
- A simple hack to geoplace images (developer.yahoo.net)
- YQL Query Builder and Explorer (developer.yahoo.com)
- Web services and YQL (developer.yahoo.net)

Twitter time weirdness
Aug 13th
I just stumbled over a very odd detail concerning the Twitter homepage:
The timestamps on my tweets differ, depending on which URL I use to access my profile.
http://twitter.com/azath0th shows my last tweet as being published on 10:40 AM Aug 9th
http://twitter.com/Azath0th (notice the capital “A”) says the last tweet was posted on 12:40 AM Aug 9th
A two hour time difference because of a capital letter in the URL?
I assume it’s because of the GMT – CET timezone difference, but why is it triggered by different URLs as a signed-out user?










