#musicbrainz

hmm, couldn't we just have a release-track relationship to link albums to pre-gap tracks?

And have the track as a NAT?

the tracks are already non-album tracks

at the moment people seem to use annotations to link them

http://wiki.musicbrainz.org/ReleasesWithPregapT... <- there's plenty listed here

hello, i have a DB question, downloaded and setup a offline postgres db, everything seems to be fine but the views are empty, i followed the instructions but what could i have done wrong

i can query and get data from the tables individually or combining them but just the views are empty

im somewhat new to postgre though

hello

anybody home ?

me

can you answer my question

I don't know the answer, so no

ok thanks

oh by the way do you know to get just the english artist names by doing a query ?

how exactly do you mean?

you know like there are japanese artists etc, so i want names that are only in english

hm... not very easily I guess, we don't store enough information about artist names really :/

what do you need them for?

so that people can search for names in a text box and get artist details but not for like japanese names etc even though there is a enlish sort order

ah, there's no way I know of to do that :/

are the "english" names listed as aliases?

well its however its in the MB db, i am just trying to get the artist names

got freedb too but that would take like a million years to process

plus the same problem of the jap/chi names

well I can make a list of only latin script names if that's what you want

does that mean enlish letters ? if so yeah that would do it

do you need anything other than the names? like the artist id or anything?

yeah the artist id, coz ill be making some other tables and attaching stuff to them

hmm, quite a lot... http://lmfao.org.uk/latinscriptartists.txt (there's over 400,000 lines so you might not want to open that straight in your browser)

cool

thanks

also is there a script i can use ? if i need modify stuff

hmm wiered, downloading a 1.30gb file using download accelarator, its at 0 seconds left and downloaded 1.31 and still going

hmm, nikki, 2.19 M/s down from you

Jormangeud^ is now known as Jormangeud

ok, I just am realizing that BMPx is a dead project, and its replacement also seems a dead project.

So, not to start a religeous argument, but I'm looking for a new tagger, pref with podcast, PUID, and decent ID3/vorbis tags support

Looks like it's down to foobar2000 or Amarok? (never really used either before) Anyone have any suggestions?

tagger?

*cough*xmms*cough*

and I should hope you get fast speeds from that server :P

I thought xmms was dead too?

xmms2 isn't afaik

but that's going in the wrong direction as well, imo

either quod libet or xmms natively support mbids and/or puids?

in what way?

O_o regexp-based music finding??? <3

tbh, I'd be happy to stay with bmpx, except I'm just really annoyed that it can't enque a directory and actually play it in anything like correct order

nikki thanks for the file again

no problem :)

later

have a good day evening guys :)

brianfreud: heh, yeah

uses disk order rather than file order :)

that goes all the way back to xmms

well, it's the one "must have" feature I want

and you cannot even sort, to fix it after queuing... makes me nuts when listening to bootlegs to hear the shows out of concert order

So are you looking for a player or a tagger?

a player

Trying quod libit, and liking it, a lot

I wish Artist lookups used soundex matching. Easy to accidentally ad duplicate artists if the name is not a precise match

there are much better ways to do fuzzy search

Apparently none good enough to have been implemented though

Eh?

Perhaps it's the usual case of "bigger fish to fry, and not enough developers"?

Not a case of the technologies not being good enough.

luks: hmm, a summer of code idea? :)

to write a search engine or a custom postgresql index type? I don't think so :)

hmm

mysql has a soundex() built in

soundex is crap, it doesn't matter

Soundex is often implemented wrong, or badly and there are better algorithms out there.

And it doesn't matter if MySQL does or not, MySQL is still crap and not in use. :p

How do i change the language in picard?

found this post: http://forums.musicbrainz.org/viewtopic.php?id=...

but theres no folder for my locale

iirc there where some problems with the translation

but don't nail me down

maybe I can check. What platform do you use?

vista

anyway, i figured it out

what has been the problem?

just delete everything in the locale dir except en :O

half the setings were in norwegian, rest in english

odd..

yeah - couldnt find a no folder in locale so dont know where it got the translation from

creature_ is now known as creature

alastair1: ping?

norweian, eh?