pod2sql enables you to import your ipod music metadata into a mysql database. the idea is to upload the itunesDB file from your ipod to your web server, import the data into the db and then issue querys of whatever form wanted in PHP. all metadata strings are converted and stored as web-friendly UTF-8.

Sorry folks, but we decided to put all our software projects on hold - the main reason simply being lack of time. More recently the thing so called "real life" has been keeping both of us (Folkert & Patrick) rather busy. This is why development and support stalled.

Nevertheless, this should not make our software less attractive – it is still great software, mature enough for daily use. Therefore, please go ahead and download any of the packages and make use of it. Even better: Write us a nice email if you like it.

If you are a developer and interested in taking on the task of continuing one of the projects, then please contact us.

• GNU libiconv
• libmysql

• mysqld database server

• songs and duration of all albums SELECT COUNT(s.id) AS cnt, a.name, a.id, SUM(s.duration) AS dur FROM album a, song s WHERE a.id = s.album GROUP BY a.name, a.id ORDER BY a.name"
• songs in playlist #4 SELECT s.id, s.title, s.rating, a.name AS artist, a.id AS a_id FROM song s, songxlist x, artist a WHERE x.list = 4 AND x.song = s.id AND s.artist = a.id ORDER BY x.trackno
• all about song #2764 SELECT s.rating, s.playcount, s.trackno, s.duration, s.bitrate, s.size, s.year, s.trackno, s.path, s.title, s.comment, al.name AS album, al.id AS al_id, ar.name AS artist, ar.id AS ar_id, g.name AS genre, g.id AS g_id, c.name AS compo, c.id AS c_id FROM song s LEFT JOIN album al ON s.album = al.id LEFT JOIN artist ar ON s.artist = ar.id LEFT JOIN genre g ON s.genre = g.id LEFT JOIN composer c ON s.composer = c.id WHERE s.id = 2764