Re: Two kinds of IDs in the Database?

Marc van Woerkom (van.woerkom nospam at netcologne.de)
Mon, 5 Apr 1999 23:19:33 +0200 (CEST)

Hello Darin!

> When entering a "new" CD, you can connect a new ID to an already-entered
> CD by choosing with radio buttons in the web browser.
>
> >For debugging purposes it would be helpful, if it was
> >possible to display the ID of an stored entry, maybe date
> >of entry too.
>
> The XML version of CD data includes all the IDs for that entry.

That was very helpful.

I tried to receive XML information, but could not figure out how to access
this without knowing a valid ID first hand. :-)

E.g the plain HTML info can be caught with:

http://www.freeamp.org/cgi-bin/cdi/xshowartist.pl?artistid=186

but I found no XML equivalent, like this pair:

http://www.freeamp.org/cgi-bin/cdi/hget.pl?\
id=m1WjfYjQRY48XLUeb0jydF0s2tc-& ... (HTML)

http://www.freeamp.org/cgi-bin/cdi/xget.pl?\
id=m1WjfYjQRY48XLUeb0jydF0s2tc-& ... (XML)

Now let us have a look at the query result:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE CDInfo SYSTEM "http://www.freeamp.org/cdindex/dtd/CDInfo.dtd">

<CDInfo>

<Title>Post</Title>
<NumTracks>11</NumTracks>

<IdInfo>

1) OK, here comes the MD5 version:

<DiskId>
<Id>16EB9914688E6E00FA87E607581973F4</Id>
</DiskId>

2) This seems to be the first SHA1 one:

<DiskId>
<Id>qlxGYSacB5ejBq.req7vsESwUuo-</Id>
<TOC First="1" Last="11">
<Offset Num="0">208302</Offset>
<Offset Num="1">150</Offset>
<Offset Num="2">17732</Offset>
<Offset Num="3">41830</Offset>
<Offset Num="4">60590</Offset>
<Offset Num="5">76995</Offset>
<Offset Num="6">94777</Offset>
<Offset Num="7">105995</Offset>
<Offset Num="8">132027</Offset>
<Offset Num="9">155037</Offset>
<Offset Num="10">173322</Offset>
<Offset Num="11">182782</Offset>
</TOC>
</DiskId>

3) This one looks like a duplicate of the above:

<DiskId>
<Id>qlxGYSacB5ejBq.req7vsESwUuo-</Id>
<TOC First="1" Last="11">
<Offset Num="0">208302</Offset>
<Offset Num="1">150</Offset>
<Offset Num="2">17732</Offset>
<Offset Num="3">41830</Offset>
<Offset Num="4">60590</Offset>
<Offset Num="5">76995</Offset>
<Offset Num="6">94777</Offset>
<Offset Num="7">105995</Offset>
<Offset Num="8">132027</Offset>
<Offset Num="9">155037</Offset>
<Offset Num="10">173322</Offset>
<Offset Num="11">182782</Offset>
</TOC>
</DiskId>

4) This one differs at Offsets 2 (-25), 3 (-8), 4 (-15), 5 (-15), 6 (-22),
7 (-8), 8 (-12), 9 (-15), 10 (-15), 11 (-7)

<DiskId>
<Id>Yxn157NYSWRyCGO8l1hmXPCNG3E-</Id>
<TOC First="1" Last="11">
<Offset Num="0">208302</Offset>
<Offset Num="1">150</Offset>
<Offset Num="2">17707</Offset>
<Offset Num="3">41822</Offset>
<Offset Num="4">60575</Offset>
<Offset Num="5">76980</Offset>
<Offset Num="6">94755</Offset>
<Offset Num="7">105987</Offset>
<Offset Num="8">132015</Offset>
<Offset Num="9">155022</Offset>
<Offset Num="10">173307</Offset>
<Offset Num="11">182775</Offset>
</TOC>
</DiskId>

5) That is my one:

<DiskId>
<Id>m1WjfYjQRY48XLUeb0jydF0s2tc-</Id>
<TOC First="1" Last="11">
<Offset Num="0">208310</Offset>
<Offset Num="1">182</Offset>
<Offset Num="2">17747</Offset>
<Offset Num="3">41847</Offset>
<Offset Num="4">60610</Offset>
<Offset Num="5">77015</Offset>
<Offset Num="6">94787</Offset>
<Offset Num="7">106010</Offset>
<Offset Num="8">132047</Offset>
<Offset Num="9">155060</Offset>
<Offset Num="10">173340</Offset>
<Offset Num="11">182797</Offset>
</TOC>
</DiskId>
</IdInfo>

<SingleArtistCD>
<Artist>Björk</Artist>
<Track Num="1">
<Name>Army of Me</Name>
</Track>
<Track Num="2">
<Name>Hyper-ballad</Name>
</Track>
<Track Num="3">
<Name>The Modern Things</Name>
</Track>
<Track Num="4">
<Name>It's Oh So Quiet</Name>
</Track>
<Track Num="5">
<Name>Enjoy</Name>
</Track>
<Track Num="6">
<Name>You've Been Flirting Again</Name>
</Track>
<Track Num="7">
<Name>Isobel</Name>
</Track>
<Track Num="8">
<Name>Possibly Maybe</Name>
</Track>
<Track Num="9">
<Name>I Miss You</Name>
</Track>
<Track Num="10">
<Name>Cover Me</Name>
</Track>
<Track Num="11">
<Name>Headphones</Name>
</Track>
</SingleArtistCD>

</CDInfo>

Interesting that there are so many -here three- versions.
Let's try another one:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE CDInfo SYSTEM "http://www.freeamp.org/cdindex/dtd/CDInfo.dtd">

<CDInfo>

<Title>Debut</Title>
<NumTracks>12</NumTracks>

<IdInfo>
<DiskId>
<Id>iMqdb6VfpXyfPUaOWScQJqVRxzc-</Id>
<TOC First="1" Last="12">
<Offset Num="0">236250</Offset>
<Offset Num="1">150</Offset>
<Offset Num="2">19077</Offset>
<Offset Num="3">40895</Offset>
<Offset Num="4">62087</Offset>
<Offset Num="5">77202</Offset>
<Offset Num="6">97707</Offset>
<Offset Num="7">115455</Offset>
<Offset Num="8">139775</Offset>
<Offset Num="9">157360</Offset>
<Offset Num="10">179512</Offset>
<Offset Num="11">201950</Offset>
<Offset Num="12">218497</Offset>
</TOC>
</DiskId>
<DiskId>
<Id>vOOQzvMmDCOyrfbLVQN2S2h4AaY-</Id>
<TOC First="1" Last="12">
<Offset Num="0">240135</Offset>
<Offset Num="1">150</Offset>
<Offset Num="2">18995</Offset>
<Offset Num="3">40957</Offset>
<Offset Num="4">62160</Offset>
<Offset Num="5">76877</Offset>
<Offset Num="6">97757</Offset>
<Offset Num="7">115520</Offset>
<Offset Num="8">139140</Offset>
<Offset Num="9">157407</Offset>
<Offset Num="10">179577</Offset>
<Offset Num="11">202017</Offset>
<Offset Num="12">222415</Offset>
</TOC>
</DiskId>
</IdInfo>

<SingleArtistCD>
<Artist>Björk</Artist>
<Track Num="1">
<Name>Human Behaviour</Name>
</Track>
<Track Num="2">
<Name>Crying</Name>
</Track>
<Track Num="3">
<Name>Venus As A Boy</Name>
</Track>
<Track Num="4">
<Name>There's More To Life Than This (Recorded live at the Milk Bar toilets)</Name>
</Track>
<Track Num="5">
<Name>Like Someone In Love</Name>
</Track>
<Track Num="6">
<Name>Big Time Sensuality</Name>
</Track>
<Track Num="7">
<Name>One Day</Name>
</Track>
<Track Num="8">
<Name>Aeroplane</Name>
</Track>
<Track Num="9">
<Name>Come To Me</Name>
</Track>
<Track Num="10">
<Name>Violently Happy</Name>
</Track>
<Track Num="11">
<Name>The Anchor Song</Name>
</Track>
<Track Num="12">
<Name>Play Dead</Name>
</Track>
</SingleArtistCD>

</CDInfo>

Again two versions. I can't see any system in the differences - in case there was a
systematic error due to different hardware drivers and their data interpretation.

Regards,
Marc