Converting the WURFL to SQL

The WURFL is getting a bit of a whopper these days but it is surprisingly easy to convert it all to a SQL table.

Download the WURFL and then go get the handy XSLT Tools.

Converting the WURFL to a pile of inserts is as simple as:
xsltproc roll_out_into_sql.xsl wurfl.xml > wurfl.sql

By default this only adds a few capabilities but you can add loads more by adding them to the roll_out_capabilities.xml file.

After all this you get:

. . insert into wurfl_devices (id,user_agent,preferred_markup,model_name,brand_name,resolution_width) values ( 'nokia_n81_ver1_sub310035', 'NokiaN81-3/10.0.035 UNTRUSTED/1.0', 'html_wi_oma_xhtmlmp_1_0', 'N81', 'Nokia', '240');

insert into wurfl_devices (id,user_agent,preferred_markup,model_name,brand_name,resolution_width) values ('mot_v9m_ver1_subopwv','MOT-V9m/1.1 UP.Browser/6.2.3.4.c.1.123 (GUI) MMP/2.0', 'html_wi_oma_xhtmlmp_1_0', 'RAZR V9m', 'Motorola', '240' ); . .

This is all jolly handy but I can’t stop being slightly appalled by the syntax of XSL. Like all declarative languages once you go over a level of complexity they become pretty tricky to read and maintain. They often seem to introduce half baked procedural bits which make it worse. Sigh.

Apple iTunes rentals

Apple iTune rentals are not a spontaneous idea.

The W@nker Detector Lives!

After many years in development the W@nker Detector has been release for iPhone and IPod Touch. Go and buy it from here
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=297567384

You know you need one!