Another question on CD track info retrieval

[1kyle]

A lot of my CD's don't have CD TEXT so the only way to get the info is via the (internal)serial number which is effectively the key for the DB lookup and either CDDB or much better the freedb.

Is there a simple MySQL type query one can submit to FREEDB for example giving the serial for the lookup

For example the CD has this info on it : Serial : 0109BF63 CDDB : 62106608

given that info I should be able to loon to the site with the CD info and submit a query like

SELECT * FROM <DB name>

where SERIAL eq 0109BF63

and CDDB eq 62106608 ;

These 2 numbers are generated from the CD title somehow - no idea how it's done.

I should be able to get the info back.

I need to know the actual database name and the variable names but this type of app should work.

I would like then to save the info retrieved into my own database so I could use the track info etc for other applications without say having to re-rip a CD with NERO etc to get this info.

Anybody got a simple internet query program that would simply return me the basic info that CDDB / FREEDB returns as a simple text file (or even a series of strings which I could save as a file.

Linux would be fine if necessary.

Note I DON'T WANT any RIPPING software. I just want the CDDB information which I can then save as TEXT or as an EXCEL spreadsheet or even html.

Most of the applications I've seen always need to import tracks into some sort of library for example MonkeyMedia.

Cheers

-K

Edited April 17, 2006 by 1kyle