2019-02-11, 07:13
Hmm. Sorry about that. Their site works for me but does seem rather slow.
I am trying the other one you suggested, here: https://ufile.io/...
Edit: link to ufile.io redacted.
Edit (2): BTW, I peeked inside the database file. I haven't read any documentation on this and I have no idea what the structure is expected to be, but a few things surprise me. First, instead of using a foreign key to the ARTIST table, each row in the SONG table appears to contain the artist's name as a string. Likewise for the ALBUM_ARTIST table. This makes me feel the table design is prone to inconsistency errors since the artist info is duplicated in several places. The first row in the ARTIST table is ([Missing Tag], Artist Tag Missing, [Missing Tag], ...), which I guess is what I'm seeing on the list of artists. If I execute SELECT * FROM song WHERE strArtistDisp LIKE "%Missing%", I don't find anything, so it seems like none of my songs have a missing artist. However, if I execute SELECT * FROM song_artist WHERE strArtist LIKE "%Missing%", I do see one result, whose idSong = -1. I don't know if this helps and my observations are pretty noob-ish, but there it is.
I am trying the other one you suggested, here: https://ufile.io/...
Edit: link to ufile.io redacted.
Edit (2): BTW, I peeked inside the database file. I haven't read any documentation on this and I have no idea what the structure is expected to be, but a few things surprise me. First, instead of using a foreign key to the ARTIST table, each row in the SONG table appears to contain the artist's name as a string. Likewise for the ALBUM_ARTIST table. This makes me feel the table design is prone to inconsistency errors since the artist info is duplicated in several places. The first row in the ARTIST table is ([Missing Tag], Artist Tag Missing, [Missing Tag], ...), which I guess is what I'm seeing on the list of artists. If I execute SELECT * FROM song WHERE strArtistDisp LIKE "%Missing%", I don't find anything, so it seems like none of my songs have a missing artist. However, if I execute SELECT * FROM song_artist WHERE strArtist LIKE "%Missing%", I do see one result, whose idSong = -1. I don't know if this helps and my observations are pretty noob-ish, but there it is.