Download from:
http://he3.magnatune.com/info/sqlite_magnatune.db
or
http://he3.magnatune.com/info/sqlite_magnatune.db.gz
You should be able to open the database file up directly from inside SQLite. Feel free to have your own software program(s) automatically download from this URL, it is stable. Please download the gzipped version of the file if you have gzipping capability on your platform.
Tables exported: artists, albums, collections, genres, songs
Explanation:
- Artists have albums
- Albums have genres, collections and songs
Notes:
A URL to play a song is created with this pseudo code:
url = "http://he3.magnatune.com/all/".urlenc($mp3)
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
----------
An artist's page is located at:
url = "http://magnatune.com/artists/".$page
----------
An album's page is located at:
url = "http://magnatune.com/artists/albums/".urlenc($sku)
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
----------
Cover art is available at this url:
url = "http://he3.magnatune.com/music/".urlenc($artist)."/".urlenc(album)."/cover_100.jpg"
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
Cover art is available in a variety of sizes, and is always square:
cover_50.jpg
cover_75.jpg
cover_100.jpg
cover_160.jpg
cover_200.jpg
cover_300.jpg
cover_600.jpg
cover_1400.jpg
Sample data:
artists(artist) = Zilla artists(city) = (this is empty if artist is from the USA) artists(country) = USA artists(description) = live, improvised electronica artists(homepage) = zilla artists(state) = CO (this is empty if artist is from outside the USA) ====================== albums(albumname) = Egg (Note: album names are unique at Magnatune) albums(artist) = Zilla albums(launchdate) = 1159513200 albums(sku) = zilla-egg albums(upc) = 876809005078 ====================== collections(albumname) = Egg collections(collection) = Experimental Electronic ====================== genres(albumname) = Egg genres(genre) = Electronica ====================== songs(albumname) = Egg songs(desc) = Soupy Sails songs(duration) = 357 songs(mp3) = 13-Soupy Sails-Zilla.mp3 ======================
