title: Musicbrainz SQL database
body: <p>While searching for a music database I came across musicbrainz, I found a SQLite Musicbrainz database.</p>
  
  <p>You can find the database scheme <a href="http://webhome.cs.uvic.ca/~thomo/schema.jpg" rel="nofollow">here.</a></p>
  
  <p>and a file with create table statements and explanatory comments <a href="http://webhome.cs.uvic.ca/~thomo/schema_with_comments.txt" rel="nofollow">here.</a></p>
  
  <p>The problem is that I only need the artist names and their songs in my data base.</p>
  
  <p>I tried to create a new database with the artists and song names for hours yesterday, but i couldn't get it to work.</p>
  
  <p>What i'm trying to do is something like this:</p>
  
  <pre><code>Artist| Song |
  --------------
  Eminem|When i'm gone
  Eminem|Lose yourself
  The Eagles|Hotel California
  </code></pre>
  
  <p>Thanks everybody!</p>