#musicbrainz

/

      • mo
        bzzt

        • 2005-05-09 12913, 2005

      • mo
        soyy couldn't resist

        • 2005-05-09 12915, 2005

      • rjmunro
        bz2 is Perfect

        • 2005-05-09 12919, 2005

      • mo
        in my ignorance ;)

        • 2005-05-09 12927, 2005

      • cikkolata
        good, because 3.6mb isn't

        • 2005-05-09 12943, 2005

      • rjmunro
        Where are you uploading it to?

        • 2005-05-09 12912, 2005

      • cikkolata
        http://lmfao.org.uk/.files/rjmunro/

        • 2005-05-09 12904, 2005

      • rjmunro
        Thanks for that.

        • 2005-05-09 12918, 2005

      • cikkolata
        you're welcome

        • 2005-05-09 12907, 2005

      • mo
        o_O my teacher broke her arm!

        • 2005-05-09 12920, 2005

      • rjmunro
        Could you do "delete from track_feat_artist where artistname in (select name from artist)"

        • 2005-05-09 12920, 2005

      • mo
        she's still going to be there, but.. poor creature :(

        • 2005-05-09 12921, 2005

      • rj__ joined the channel

        • 2005-05-09 12929, 2005

      • cikkolata
        done

        • 2005-05-09 12935, 2005

      • cikkolata
        hi rj

        • 2005-05-09 12942, 2005

      • rj__
        see the coverage of audioscrobbler <--> musicbrainz linkage for artists here: http://www.audioscrobbler.com/explore/?artistname…

        • 2005-05-09 12943, 2005

      • rj__
        hi

        • 2005-05-09 12948, 2005

      • rjmunro
        Then run the last query again, but change artistname at the end to sortname.

        • 2005-05-09 12920, 2005

      • rjmunro
        see if anyone has put (feat. sortname) instead of (feat. artistname)

        • 2005-05-09 12934, 2005

      • cikkolata
        but sortname isn't in there...

        • 2005-05-09 12945, 2005

      • rjmunro
        Where is it?

        • 2005-05-09 12930, 2005

      • rjmunro
        Oh, I see. I'm being silly. Change aritst.name to artist.sortname on the line above,

        • 2005-05-09 12939, 2005

      • yalaforge
        rj__: nice!

        • 2005-05-09 12904, 2005

      • cikkolata
        the first query?

        • 2005-05-09 12905, 2005

      • rj__
        that's more or less just a plain text match to link them up

        • 2005-05-09 12923, 2005

      • rj__
        hoping to use some lucene trickery to automatically detect slight mispellings etc

        • 2005-05-09 12935, 2005

      • cikkolata
        I wonder scarling aren't linked

        • 2005-05-09 12938, 2005

      • cikkolata
        they're the same in mb

        • 2005-05-09 12953, 2005

      • cikkolata
        wonder *why*

        • 2005-05-09 12922, 2005

      • yalaforge
        http://www.audioscrobbler.com/music/Jennifer+Terr… isn't matched either

        • 2005-05-09 12934, 2005

      • cikkolata blinks

        • 2005-05-09 12939, 2005

      • cikkolata
        I'm getting more stupid I think

        • 2005-05-09 12900, 2005

      • rjmunro
        cikkolata: Sorry, run the last query, changing the artist.name on the second line to artist.sortname.

        • 2005-05-09 12915, 2005

      • yalaforge
        http://www.audioscrobbler.com/music/Tori+Amos+fea… is matched, but to VA for some reason

        • 2005-05-09 12931, 2005

      • rj__
        hmm, cunning

        • 2005-05-09 12940, 2005

      • rj__
        it's far from perfect yet ;)

        • 2005-05-09 12942, 2005

      • cikkolata
        ah

        • 2005-05-09 12946, 2005

      • yalaforge
        rj__: :-)

        • 2005-05-09 12948, 2005

      • rjmunro
        That should find the (feat. [sortname]) tracks.

        • 2005-05-09 12918, 2005

      • rjmunro
        I'm getting confused because there seems to be 2 conversations on very similar topics happening at once...

        • 2005-05-09 12946, 2005

      • cikkolata giggles

        • 2005-05-09 12947, 2005

      • yalaforge is quiet now. he's got other things to do anyway

        • 2005-05-09 12949, 2005

      • rjmunro
        audioscrobbler is matching MB artists to it's artists, and I am matching (feat. ) tracks to artists...

        • 2005-05-09 12950, 2005

      • cikkolata
        and I'm always confused

        • 2005-05-09 12910, 2005

      • cikkolata
        http://lmfao.org.uk/.files/rjmunro/3.txt

        • 2005-05-09 12924, 2005

      • cikkolata
        oh, I see what you were doing

        • 2005-05-09 12935, 2005

      • rjmunro
        That's hardly any!

        • 2005-05-09 12955, 2005

      • cikkolata
        removing the artist names so that ones where the sortname is the same as the artist name don't get included?

        • 2005-05-09 12922, 2005

      • rjmunro
        Could you do "delete from track_feat_artist where artistname in (select sortname from artist)"

        • 2005-05-09 12930, 2005

      • rjmunro
        That was the delete statement.

        • 2005-05-09 12940, 2005

      • cikkolata
        done...

        • 2005-05-09 12911, 2005

      • rjmunro
        We could try matching the rest of track_feat_artist to artist aliases.

        • 2005-05-09 12915, 2005

      • cikkolata prods at rj's artist thingy

        • 2005-05-09 12919, 2005

      • rjmunro
        How many rows are left?

        • 2005-05-09 12936, 2005

      • cikkolata
        21997, apparently

        • 2005-05-09 12911, 2005

      • cikkolata
        the brilliant green didn't match either... weird.

        • 2005-05-09 12915, 2005

      • rj__
        if ruaok makes an appearance could someone point him at that /explore/ page on A/S. i can dish up a mbid,mbid,% file for artist similarity now if desired. otherwise we can wait and match more artists..

        • 2005-05-09 12935, 2005

      • cikkolata
        he's probably not going to be around much, if at all though...

        • 2005-05-09 12940, 2005

      • yalaforge
        mhh. maria solheim isn't matched either

        • 2005-05-09 12911, 2005

      • cikkolata
        neither are tommy february6/tommy heavenly6...

        • 2005-05-09 12921, 2005

      • yalaforge
        or martha wainwright

        • 2005-05-09 12907, 2005

      • yalaforge
        maria solheim and jennifer terran have been in MB for quite a time. more than a year, I think

        • 2005-05-09 12916, 2005

      • DJKC
        some are linked wrong

        • 2005-05-09 12920, 2005

      • DJKC
        for artists with the same name

        • 2005-05-09 12933, 2005

      • cikkolata
        isn't that to be expected?

        • 2005-05-09 12937, 2005

      • rj__
        that is entirely possible as well.. we had a dodgy linking script running a while ago that was too vague

        • 2005-05-09 12948, 2005

      • yalaforge
        the vast majority is correct, of course

        • 2005-05-09 12949, 2005

      • rj__
        i may wipe all links and make new ones based just on artist name

        • 2005-05-09 12901, 2005

      • enthalpyX joined the channel

        • 2005-05-09 12912, 2005

      • DJKC
        won't that fail even worse on ones with the same name that are seperated on MB?

        • 2005-05-09 12928, 2005

      • DJKC
        also see some linked to just VA for some reason o.O

        • 2005-05-09 12901, 2005

      • yalaforge
        cikkolata: your db snapshot is pretty new, I suppose?

        • 2005-05-09 12909, 2005

      • cikkolata
        and "GO!GO!7188" are linked to an artist that mb can't find...

        • 2005-05-09 12930, 2005

      • yalaforge
        could you run "select count(*) from artist where type = 1 and not begindate is null;" please?

        • 2005-05-09 12930, 2005

      • cikkolata
        yalaforge: whichever db snapshot was available last night

        • 2005-05-09 12949, 2005

      • yalaforge
        I'm interested in how many birthdates we have so far

        • 2005-05-09 12950, 2005

      • cikkolata
        and dammit, I can never type snapshot without typing shot as snot

        • 2005-05-09 12955, 2005

      • enthalpyX
        Hey-- how do I extract a TRM id from an mp3 that's already been tagged?

        • 2005-05-09 12909, 2005

      • yalaforge
        cikkolata: :-)

        • 2005-05-09 12909, 2005

      • cikkolata
        1430

        • 2005-05-09 12929, 2005

      • yalaforge
        cikkolata: thanks. almost doubled during the last two months :-)

        • 2005-05-09 12933, 2005

      • lindestinel joined the channel

        • 2005-05-09 12946, 2005

      • cikkolata
        months?

        • 2005-05-09 12949, 2005

      • cikkolata
        weeks/

        • 2005-05-09 12950, 2005

      • cikkolata
        ?

        • 2005-05-09 12952, 2005

      • yalaforge
        enjayhch: are you running linux? and what do you need it for?

        • 2005-05-09 12916, 2005

      • yalaforge
        cikkolata: hm, I think my snapshot is ca 6 weeks old

        • 2005-05-09 12929, 2005

      • cikkolata
        but AR only came out a month ago...

        • 2005-05-09 12934, 2005

      • yalaforge
        enjayhch: sorry!

        • 2005-05-09 12937, 2005

      • cikkolata
        and that was with it, wasn't it?

        • 2005-05-09 12956, 2005

      • yalaforge
        enthalpyX: so, once again: are you running linux? and what do you need it for?

        • 2005-05-09 12900, 2005

      • cikkolata
        I thought yours was ~20th april

        • 2005-05-09 12929, 2005

      • yalaforge
        cikkolata: not 20th march?

        • 2005-05-09 12941, 2005

      • enthalpyX
        yalaforge: I'm (attempting) to write an audioscrobbler plugin for this player called musikcube

        • 2005-05-09 12944, 2005

      • cikkolata
        no

        • 2005-05-09 12956, 2005

      • yalaforge
        cikkolata: ok, then it's newer than I thought :-)

        • 2005-05-09 12958, 2005

      • cikkolata
        mine was 23rd april, and you said yours was about 3 days older

        • 2005-05-09 12917, 2005

      • yalaforge is sure cikkolata is right

        • 2005-05-09 12929, 2005

      • cikkolata
        because I didn't set up an AR server until a couple of weeks after it was released (10/11th april)

        • 2005-05-09 12939, 2005

      • yalaforge
        enthalpyX: well, then you don't need the TRM but rather the MBID, I suppose

        • 2005-05-09 12946, 2005

      • cikkolata
        don't underestimate my ability for remembering pointless stuff! ;)

        • 2005-05-09 12959, 2005

      • yalaforge
        cikkolata: I won't! promised ;-)

        • 2005-05-09 12946, 2005

      • yalaforge
        enthalpyX: the TRMId is just a fuzzy audio checksum that can match to multiple tracks

        • 2005-05-09 12936, 2005

      • Moof has left the channel

        • 2005-05-09 12946, 2005

      • enthalpyX
        yalaforge: I see; the MBID is different?

        • 2005-05-09 12933, 2005

      • Kanmu has quit

        • 2005-05-09 12948, 2005

      • yalaforge
        enthalpyX: yes, the MBId is unique. it maps to exactly one track. see http://www.musicbrainz.org/track/98200ec7-d828-4e… for an example

        • 2005-05-09 12901, 2005

      • yalaforge
        98200ec7-d828-4e4f-8dbe-b20e6d519f88 is the ASCII representation of the 128 bit MBID

        • 2005-05-09 12925, 2005

      • yalaforge
        you can get that ID from the id3v2's UFID frame

        • 2005-05-09 12909, 2005

      • donredman_ joined the channel

        • 2005-05-09 12911, 2005

      • luks joined the channel

        • 2005-05-09 12933, 2005

      • yalaforge
        hey guys!

        • 2005-05-09 12946, 2005

      • donredman_
        Hi

        • 2005-05-09 12951, 2005

      • enthalpyX
        yalaforge: awesome, that makes sense

        • 2005-05-09 12959, 2005

      • luks
        hi

        • 2005-05-09 12910, 2005

      • enthalpyX
        yalaforge: I wasn't sure if it was artist||album||track that uniquely identified it, as opposed to just the trm (or the track)

        • 2005-05-09 12911, 2005

      • rjmunro has quit

        • 2005-05-09 12932, 2005

      • cikkolata
        hi people...

        • 2005-05-09 12941, 2005

      • enthalpyX
        yalaforge: but that clears up a lot; thanks :)

        • 2005-05-09 12903, 2005

      • yalaforge
        enthalpyX: np

        • 2005-05-09 12914, 2005

      • yalaforge
        we've got our specs here -> http://musicbrainz.org/docs/specs/metadata_tags.h…

        • 2005-05-09 12923, 2005

      • yalaforge
        in case you need more IDs

        • 2005-05-09 12923, 2005

      • donredman_
        is zero gravitas in here (whatever nic he uses)?

        • 2005-05-09 12933, 2005

      • yalaforge
        donredman_: not at the moment

        • 2005-05-09 12941, 2005

      • yalaforge
        he uses zeroGravitas usually

        • 2005-05-09 12959, 2005

      • donredman_
        perhaps you can help me.

        • 2005-05-09 12908, 2005

      • donredman_
        how much are you into the wikidocs stuff

        • 2005-05-09 12909, 2005

      • donredman_
        ?

        • 2005-05-09 12915, 2005

      • donredman_
        donredman_ is now known as donredman

        • 2005-05-09 12930, 2005

      • yalaforge
        not at all. I wrote the initial proof of concept

        • 2005-05-09 12946, 2005

      • donredman
        I need to understand this "websevice" thing a little better

        • 2005-05-09 12950, 2005

      • yalaforge
        rob ported it over to moinmoin and explained me your concept

        • 2005-05-09 12954, 2005

      • yalaforge
        ok?

        • 2005-05-09 12918, 2005

      • yalaforge
        what do you want to know?

        • 2005-05-09 12932, 2005

      • donredman
        what is it doing from the moment you request /wd/SomeThing to the moment it displays the page?

        • 2005-05-09 12904, 2005

      • yalaforge
        let me read the source for a minute ...

        • 2005-05-09 12945, 2005

      • yalaforge
        ok, it works like this (not much different to my original concept):

        • 2005-05-09 12914, 2005

      • yalaforge
        the /wd/whatever is rewritten to a different URL: /docs.html?id=whatever

        • 2005-05-09 12928, 2005

      • yalaforge
        the code inside of docs.html calls a mason component.

        • 2005-05-09 12945, 2005

      • yalaforge
        this mason component loads a page from the wiki via HTTP-GET

        • 2005-05-09 12907, 2005

      • yalaforge
        the URL is /read/whatever?action=content

        • 2005-05-09 12935, 2005

      • yalaforge
        it seems there's some link rewriting done with the requested content

        • 2005-05-09 12900, 2005

      • yalaforge
        and then it's displayed on the website. inside ouf our usual framework (header, sidebar, footer)

        • 2005-05-09 12917, 2005

      • yalaforge
        and that's it

        • 2005-05-09 12951, 2005

      • donredman
        Ok thanks, what kind of link rewriting is it doing (that is the important part to me)?

        • 2005-05-09 12906, 2005

      • donredman
        just roughly

        • 2005-05-09 12917, 2005

      • yalaforge
        mhh. let me see ...

        • 2005-05-09 12913, 2005

      • yalaforge
        apparently, the wiki returns some links like 'http:/page.html' (relative links)

        • 2005-05-09 12941, 2005

      • yalaforge
        they are rewritten to absolute links (http://www.musicbrainz.org/...)

        • 2005-05-09 12956, 2005

      • yalaforge
        it's a bit strange, I agree