Re: RDBMS schema (MySQL)
"Brian K. Hughes" <[email protected]> Thu, 29 Aug 2002 13:50:29 -0700
| Newsgroups | gmane.comp.audio.freedb.devel |
|---|---|
| Message-ID | <[email protected]> |
--=====================_192678221==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Hi all, I'm a developer for Acoustica, whose CD Burner product is due to be released this month with freedb support. Here's a question one of you may be able to answer that's sort of related to the schema discussion (if not, feel free to tell me to go away and I'll repost with a different subject *grin*). I pull a disc ID from the TOC of a CD and go query freedb with it. The DB gives me two possible choices for the album... both use the same artist, title, and genre (which is confusing to the user to begin with), but each has a different disc ID and none of them match the original disc ID. If the search is based on the disc ID, how is it that A) I'm finding other records that do not have my disc ID, and B) why do none of the results returned have my disc ID? Incidentally, if I grab the track times and calculate the disc ID myself, I get the same ID that's in the TOC of the CD. Thanks! ---------- Brian K. Hughes Programmer and Sound Byter Acoustica.com - "Software should be easy to use!" Voice: 559-692-2224, Fax: 559-692-2214 Web: www.acoustica.com, www.cdburner.com ---------- --=====================_192678221==_.ALT Content-Type: text/html; charset="us-ascii" <html> Hi all,<br><br> I'm a developer for Acoustica, whose CD Burner product is due to be released this month with freedb support. Here's a question one of you may be able to answer that's sort of related to the schema discussion (if not, feel free to tell me to go away and I'll repost with a different subject *grin*).<br><br> I pull a disc ID from the TOC of a CD and go query freedb with it. The DB gives me two possible choices for the album... both use the same artist, title, and genre (which is confusing to the user to begin with), but each has a different disc ID and none of them match the original disc ID. If the search is based on the disc ID, how is it that A) I'm finding other records that do not have my disc ID, and B) why do none of the results returned have my disc ID? Incidentally, if I grab the track times and calculate the disc ID myself, I get the same ID that's in the TOC of the CD.<br><br> Thanks!<br> <x-sigsep><p></x-sigsep> <hr> <font size=4 color="#FF0000">Brian K. Hughes<br> </font>Programmer and Sound Byter<br> Acoustica.com - "Software should be easy to use!"<br> Voice: 559-692-2224, Fax: 559-692-2214<br> Web: <a href="http://www.acoustica.com/" eudora="autourl">www.acoustica.com</a>, <a href="http://www.cdburner.com/" eudora="autourl">www.cdburner.com</a><br> <hr> </html> --=====================_192678221==_.ALT--