Pulling RDF out of MySQL

With a command line option and a very short stylesheet.

When I wrote the blog posting My SQL quick reference last month, I showed how you can pass an SQL query to MySQL from the operating system command line when starting up MySQL, and also how adding a -B switch requests a tab-separated version of the data. I did not mention that -X requests it in XML, and that this XML is simple enough that a fifteen-line XSLT 1.0 spreadsheet can convert any such output to RDF.

Jo Rabin’s “Mobile is not The Future (It’s Now)” presentation in the Trends and Transients portion of this year’s XML Summer School (and the reading he suggested, such as this Tomi Ahonen blog post) got me thinking much harder about mobile delivery. One of my first ideas was how easy the jQuery Mobile Javascript library could make it to deliver SPARQL query results, and in less than 30 minutes I wrote an XSLT stylesheet that can take the SPARQL Query Results XML Format…

Converting wpl playlists to m3u playlists

Simple XML in, simple text out, but no good search results for wpl2m3u? Write a little XSLT.

I’ve switched around between music-playing programs over the last few years. I suppose I should call them “media players”, but I only use them to play music, which is part of the reason I ended up using Songbird, an open source Windows/Linux/Mac music front end that doesn’t pretend to be anything else. It looks a bit like iTunes, without all the ads in your face; how great is that?

Using XSLT to deliver XML on browsers

An update on Firefox (with some help from the world of model railroading) and Chrome.

Delivery of XML on web browsers isn’t as popular as XML’s inventors originally hoped, but it’s still useful. It’s easy to add a standardized processing instruction to your XML that points at an XSLT stylesheet that converts your XML to HTML, and then when you open the XML file in your browser, you see the result. When you need a rendered version of some XML to review, this can make it happen pretty quickly. (The W3C Recommendation Associating Style Sheets with XML…