Can I get down now dad?

Tramps like us, baby we were born to code

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.picture-18.png

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!

picture-16.png

Android/Gmail Contacts

this is all a bit of a struggle to be honest. There is an ical sync if you have an iphone fox sake. Sigh.

All I want for Xmas …..

fatdad.jpg

Betty’s new woolly



26112008(002), originally uploaded by Spuggy.

- Taken at 11:00 AM on November 26, 2008 - cameraphone upload by ShoZu

22112008(002)



22112008(002), originally uploaded by Spuggy.

- Taken at 3:02 PM on November 22, 2008 - cameraphone upload by ShoZu

G1 - Walking the dog

Baby, back
Dressed in black
Silver buttons all down her back
High hose, tippy toes
She broke the needle and she can sew

Walking the dog
I’m just a walking the dog
If you don’t know how to do it
I’ll show you how to walk the dog
C’mon now c’mon

Walking the dog with the G1, running the gps tracker in the background too.

walk.JPG

Android Review 01.

Hmmmm, had the G1 for a morning. I turned it on at 08:30 and it is winging about it’s battery at 12:00 midday. I was in a meeting most of the morning so didn’t really hammer it either.

These people seem to have been fiddling with battery charging so I will give that a go.

Update:
The battery lasted from 8:30 till 1:30pm. Hmmm, back on charge now.

31102008



31102008, originally uploaded by Spuggy.

- Taken at 9:05 AM on October 31, 2008 - cameraphone upload by ShoZu
This photo was sent via ShoZu from a mobile phone.
Get ShoZu for FREE at http://www.shozu.com and enjoy easy photo and video sharing to any email address and sites like Facebook, Flickr, Blogger, Picasa and more, all from your mobile phone
http://www.shozu.com.

« Previous Entries Next Entries »