about
| platform |
POSIX / LAMP |
| type |
data import tool |
| language |
C, SQL, PHP |
| version |
0.2 |
| last update |
2004.07.05 |
| download |
latest
|
|
README
|
| author |
folkert |
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.
donate
if you like our software, feel free to send us a postcard (or, of course, money, hardware, or chocolate ;) from your corner of the world. we get a kick out of knowing that our stuff actually is getting used by other people =)
folkert snailmail |
patrick snailmail
requirements
to build and run pod2sql, you need:
to use pod2sql, you need:
sample queries
-
songs and duration of all albums<![CDATA[
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<![CDATA[
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<![CDATA[
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
]]>
all rights [r] belong to us.
