#musicbrainz

bzzt

soyy couldn't resist

bz2 is Perfect

in my ignorance ;)

good, because 3.6mb isn't

Where are you uploading it to?

Thanks for that.

you're welcome

o_O my teacher broke her arm!

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

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

done

hi rj

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

hi

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

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

but sortname isn't in there...

Where is it?

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

rj__: nice!

the first query?

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

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

I wonder scarling aren't linked

they're the same in mb

wonder *why*

http://www.audioscrobbler.com/music/Jennifer+Te... isn't matched either

I'm getting more stupid I think

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

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

hmm, cunning

it's far from perfect yet ;)

ah

rj__: :-)

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

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

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

and I'm always confused

oh, I see what you were doing

That's hardly any!

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

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

That was the delete statement.

done...

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

How many rows are left?

21997, apparently

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

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..

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

mhh. maria solheim isn't matched either

neither are tommy february6/tommy heavenly6...

or martha wainwright

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

some are linked wrong

for artists with the same name

isn't that to be expected?

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

the vast majority is correct, of course

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

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

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

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

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

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

yalaforge: whichever db snapshot was available last night

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

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

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

cikkolata: :-)

1430

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

months?

weeks/

?

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

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

but AR only came out a month ago...

enjayhch: sorry!

and that was with it, wasn't it?

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

I thought yours was ~20th april

cikkolata: not 20th march?

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

no

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

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

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

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

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

cikkolata: I won't! promised ;-)

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

yalaforge: I see; the MBID is different?

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

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

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

hey guys!

Hi

yalaforge: awesome, that makes sense

hi

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

hi people...

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

enthalpyX: np

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

in case you need more IDs

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

donredman_: not at the moment

he uses zeroGravitas usually

perhaps you can help me.

how much are you into the wikidocs stuff

?

donredman_ is now known as donredman

not at all. I wrote the initial proof of concept

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

rob ported it over to moinmoin and explained me your concept

ok?

what do you want to know?

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

let me read the source for a minute ...

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

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

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

the URL is /read/whatever?action=content

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

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

and that's it

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

just roughly

mhh. let me see ...

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

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

it's a bit strange, I agree