#musicbrainz

/

      • reto_
        FauxFaux: hmm, and on the page you posted, there's another track lit

        • 2008-12-12 34752, 2008

      • FauxFaux
        The Serious version of the release is linked in the annotation, if you want to tag against that. :)

        • 2008-12-12 34703, 2008

      • FauxFaux
        Discogs is not a good sauce of info.

        • 2008-12-12 34715, 2008

      • gioele joined the channel

        • 2008-12-12 34724, 2008

      • gioele
        hi there

        • 2008-12-12 34741, 2008

      • FauxFaux
        Evening!

        • 2008-12-12 34756, 2008

      • reto_
        ah

        • 2008-12-12 34753, 2008

      • CStan has quit

        • 2008-12-12 34718, 2008

      • jcazevedo has quit

        • 2008-12-12 34745, 2008

      • stillLotR
        stillLotR is now known as LotR

        • 2008-12-12 34708, 2008

      • CStan joined the channel

        • 2008-12-12 34747, 2008

      • testing132
        testing132 has joined #Musicbrainz

        • 2008-12-12 34759, 2008

      • RifRaf has quit

        • 2008-12-12 34737, 2008

      • Tykling has left the channel

        • 2008-12-12 34710, 2008

      • Freso has quit

        • 2008-12-12 34741, 2008

      • SenRepus has quit

        • 2008-12-12 34729, 2008

      • gioele has quit

        • 2008-12-12 34753, 2008

      • gioele joined the channel

        • 2008-12-12 34735, 2008

      • v6lur joined the channel

        • 2008-12-12 34733, 2008

      • Tykling joined the channel

        • 2008-12-12 34748, 2008

      • Milosz
        hey ho

        • 2008-12-12 34701, 2008

      • Milosz
        for artist aliases, does the MB database have a concept of what the 'main' alias is?

        • 2008-12-12 34718, 2008

      • Milosz
        i'd like to add support for artist aliases to our player app

        • 2008-12-12 34732, 2008

      • FauxFaux
        I always assumed so..

        • 2008-12-12 34751, 2008

      • Milosz
        however, when listing album artists I'd like to avoid listing an artist once, and then all his aliases below that, and then listing the aliases again, again with the other aliases, etc :)

        • 2008-12-12 34736, 2008

      • FauxFaux
        Aren't all the artistaliases table just linked to a single artist?

        • 2008-12-12 34755, 2008

      • FauxFaux
        i.e. the "main" alias is the artists name, and all the aliases are in that table.

        • 2008-12-12 34716, 2008

      • Milosz
        ok now let's hope this works out in the XML WS

        • 2008-12-12 34720, 2008

      • Milosz tests

        • 2008-12-12 34748, 2008

      • FauxFaux
        A website backed onto the webservice? Surely that's hilliariously slow?

        • 2008-12-12 34711, 2008

      • Milosz
        no an app

        • 2008-12-12 34714, 2008

      • Milosz
        a desktop ap

        • 2008-12-12 34715, 2008

      • Milosz
        app*

        • 2008-12-12 34720, 2008

      • Milosz
        FauxFaux, it will cache the data of course

        • 2008-12-12 34726, 2008

      • FauxFaux
        Ah, okay. Where did I get that idea from. :/

        • 2008-12-12 34734, 2008

      • Milosz
        heh

        • 2008-12-12 34742, 2008

      • Milosz
        FauxFaux, one question if you know it, about adding an alias

        • 2008-12-12 34745, 2008

      • FauxFaux
        Maybe it was gta4, let me go check. ¬_¬_¬

        • 2008-12-12 34755, 2008

      • Milosz
        i just found the artist i wanted to check has not his aliases added

        • 2008-12-12 34706, 2008

      • Milosz
        in the edit box, i can only enter a name, but not find an existing artist (??)

        • 2008-12-12 34714, 2008

      • Milosz
        surely that must be possible somehow?

        • 2008-12-12 34716, 2008

      • Milosz
        heh @ gta4

        • 2008-12-12 34726, 2008

      • Milosz
        anyone knows why it's not possible to add an existing artist?

        • 2008-12-12 34713, 2008

      • Milosz
        so an alias is not linked to an artist MB ID?

        • 2008-12-12 34719, 2008

      • Milosz
        now that blows up my entire plan :/

        • 2008-12-12 34739, 2008

      • FauxFaux
        I don't understand, I haven't really looked at aliases.

        • 2008-12-12 34752, 2008

      • Milosz
        FauxFaux, ok when adding a new alias (I'm in that editor right now), i can enter a name

        • 2008-12-12 34753, 2008

      • Milosz
        a string

        • 2008-12-12 34715, 2008

      • Milosz
        but apparently it's not linked to an uh well.. not to a "real" artist (an artist MB ID if you will)

        • 2008-12-12 34728, 2008

      • Milosz
        it's "just" a string alias

        • 2008-12-12 34735, 2008

      • FauxFaux
        Oh, yeah, the db looks like that too.

        • 2008-12-12 34739, 2008

      • Milosz
        meehhh

        • 2008-12-12 34741, 2008

      • FauxFaux
        There's a "performance name" AR.

        • 2008-12-12 34742, 2008

      • luks
        what make you think it's not linked?

        • 2008-12-12 34744, 2008

      • FauxFaux
        Or something like that.

        • 2008-12-12 34757, 2008

      • Milosz
        luks, i'd imagine that if it was, it would allow me to find an existing name like in the release adder

        • 2008-12-12 34719, 2008

      • FauxFaux can't think of any artists with performance names. :|

        • 2008-12-12 34732, 2008

      • luks
        I don't really understand the problem

        • 2008-12-12 34753, 2008

      • luks
        an artist has name, sortname and a list of aliases

        • 2008-12-12 34703, 2008

      • FauxFaux
        He thinks Aliases are ARs to MB artists, i.e. another name for a real person, not a set of spelling mistakes.

        • 2008-12-12 34711, 2008

      • Milosz
        ok so these aliases have the same MB ID basically?

        • 2008-12-12 34712, 2008

      • Milosz
        as the main artist

        • 2008-12-12 34713, 2008

      • Milosz
        ok

        • 2008-12-12 34720, 2008

      • Milosz
        ok now i understand

        • 2008-12-12 34724, 2008

      • Milosz
        but actually i'm not sure

        • 2008-12-12 34725, 2008

      • LotR has quit

        • 2008-12-12 34730, 2008

      • Milosz
        i'll just explain the specific situation

        • 2008-12-12 34734, 2008

      • Milosz
        there's an artist "Jimmy Edgar"

        • 2008-12-12 34743, 2008

      • luks
        aliases are properties of artists, they don't have MB IDs

        • 2008-12-12 34743, 2008

      • Milosz
        which recorded an album under the alias

        • 2008-12-12 34747, 2008

      • Milosz
        (ironically it's even 2 names)

        • 2008-12-12 34754, 2008

      • Milosz
        luks, please..

        • 2008-12-12 34756, 2008

      • Milosz
        let me explain it

        • 2008-12-12 34757, 2008

      • FauxFaux
        Milosz: You mean like the http://musicbrainz.org/show/artist/relationships.… "is a performance name for the person Quentin Leo Cook"

        • 2008-12-12 34712, 2008

      • FauxFaux
        Where Quentin Leo Cook /is/ an MB artist.

        • 2008-12-12 34714, 2008

      • Milosz
        ohohh yeah

        • 2008-12-12 34726, 2008

      • Milosz
        but this raises the question how to deal with releases under that name

        • 2008-12-12 34735, 2008

      • Milosz
        Jimmy Edgar released one release as "Morris Nightingale"

        • 2008-12-12 34743, 2008

      • Milosz
        but currently this second artist is not linked to Jimmy Edgar in any way

        • 2008-12-12 34752, 2008

      • Milosz
        now i'm not sure what the proper way would be, now questions about my app aside

        • 2008-12-12 34755, 2008

      • FauxFaux
        It should be.

        • 2008-12-12 34705, 2008

      • FauxFaux
        At least, I believe it should be. Using that AR.

        • 2008-12-12 34707, 2008

      • luks
        links plase

        • 2008-12-12 34712, 2008

      • luks
        please

        • 2008-12-12 34726, 2008

      • Milosz
        http://musicbrainz.org/artist/fa263cb3-205f-4a7f-…

        • 2008-12-12 34740, 2008

      • Milosz
        http://musicbrainz.org/artist/6d8ecc05-52c2-433c-…

        • 2008-12-12 34755, 2008

      • luks
        oh, so you are talking about ARs, not aliases

        • 2008-12-12 34702, 2008

      • luks
        see what FauxFaux said

        • 2008-12-12 34710, 2008

      • Milosz
        ok seems i had a misconception

        • 2008-12-12 34713, 2008

      • Milosz
        i get it

        • 2008-12-12 34720, 2008

      • Milosz
        btw that release on the 2nd artist

        • 2008-12-12 34722, 2008

      • Milosz
        is totally wrong

        • 2008-12-12 34726, 2008

      • Milosz
        o_O

        • 2008-12-12 34728, 2008

      • Milosz
        i'll add an edit to remove that

        • 2008-12-12 34739, 2008

      • Milosz
        there exists no such release

        • 2008-12-12 34702, 2008

      • Milosz
        has no track times either

        • 2008-12-12 34716, 2008

      • Milosz
        gah well ok i admit the aliasing with Jimmy Edgar is complex but this isn't right

        • 2008-12-12 34732, 2008

      • LotR joined the channel

        • 2008-12-12 34700, 2008

      • Milosz
        but i'll check better first

        • 2008-12-12 34719, 2008

      • Milosz
        ok thanks for clearing that up about aliases and performance name ARs

        • 2008-12-12 34739, 2008

      • Milosz
        oh ok but this raises a question

        • 2008-12-12 34758, 2008

      • Milosz
        no wait i'll check before i leap over my head again

        • 2008-12-12 34739, 2008

      • jacknetgb joined the channel

        • 2008-12-12 34735, 2008

      • Alan_New joined the channel

        • 2008-12-12 34758, 2008

      • gioele
        luks: would you release picard via PPA? It was such a convenient way to update picard on ubuntu systems

        • 2008-12-12 34701, 2008

      • gioele
        s/would/will

        • 2008-12-12 34745, 2008

      • brianfreud
        gioele, is Picard not still in the default ubuntu repository? I found it even easier to install and update that way

        • 2008-12-12 34710, 2008

      • gioele
        brianfreud: yes but it is always lagging behind the latest release

        • 2008-12-12 34718, 2008

      • brianfreud
        ah

        • 2008-12-12 34735, 2008

      • gioele
        and it takes a lot of time for them to accept updates from upstream

        • 2008-12-12 34744, 2008

      • futilius has quit

        • 2008-12-12 34734, 2008

      • brianfreud
        oooh! we now can have events without a date? Shiny!

        • 2008-12-12 34751, 2008

      • LotR
        events?

        • 2008-12-12 34758, 2008

      • Muz
        Release events with multiple territories would be nicer

        • 2008-12-12 34700, 2008

      • brianfreud
        release events

        • 2008-12-12 34705, 2008

      • LotR
        oic

        • 2008-12-12 34729, 2008

      • luks
        gioele: I'll try to do that over weekend

        • 2008-12-12 34739, 2008

      • gioele
        luks: thank you!

        • 2008-12-12 34707, 2008

      • Tykling has left the channel

        • 2008-12-12 34721, 2008

      • CStan has quit

        • 2008-12-12 34722, 2008

      • jacknetgb
        is it normal to get stuff like this when importing the files to dbn

        • 2008-12-12 34723, 2008

      • jacknetgb
        WARNING: skipping "pg_database" --- only table or database owner can vacuum it

        • 2008-12-12 34725, 2008

      • jacknetgb
        VACUUM

        • 2008-12-12 34737, 2008

      • Muz
        That's fine

        • 2008-12-12 34729, 2008

      • jacknetgb
        just i dont think its working correctly, it only took 20 mins to import mbdump mbdump-artistrelation mb-derived

        • 2008-12-12 34751, 2008

      • Muz
        How fast is your machine, and what command did you run?

        • 2008-12-12 34710, 2008

      • jacknetgb
        its not fast enough to do it that fast :P

        • 2008-12-12 34720, 2008

      • Muz
        Okay, what command did you use to import the DB?

        • 2008-12-12 34734, 2008

      • jacknetgb
        home/musicbrainz_user/mb_server/admin/InitDb.pl --createdb --import /mnt/musicbrainz_data/mbdump*.tar.bz2

        • 2008-12-12 34752, 2008

      • Muz
        What was the entire output of that then?

        • 2008-12-12 34712, 2008

      • jacknetgb
        ill run it again and put the output in a file

        • 2008-12-12 34733, 2008

      • Muz
        You'll need to drop the DBs first to run a reimport

        • 2008-12-12 34738, 2008

      • jacknetgb
        i have

        • 2008-12-12 34742, 2008

      • Muz
        Okay

        • 2008-12-12 34750, 2008

      • Muz
        Just making sure that's not why it was so quick :P

        • 2008-12-12 34702, 2008

      • jacknetgb
        :P its running now

        • 2008-12-12 34719, 2008

      • jacknetgb
        also how can i make postgres store the databases on a different hard disk to the system drive?

        • 2008-12-12 34705, 2008

      • Muz
        By changing the parameter of the -D switch when postgres is started

        • 2008-12-12 34715, 2008

      • Muz
        there's more to it than tht, I suggest the postgres channel

        • 2008-12-12 34727, 2008

      • jacknetgb
        ok ill ask there thanks

        • 2008-12-12 34714, 2008

      • zeno has quit

        • 2008-12-12 34745, 2008

      • zeno joined the channel

        • 2008-12-12 34744, 2008

      • jacknetgb
        when running the db import, this error appeared this time:

        • 2008-12-12 34745, 2008

      • jacknetgb
        tar: mbdump/track: Wrote only 5120 of 10240 bytes

        • 2008-12-12 34747, 2008

      • jacknetgb
        tar: mbdump/url: Wrote only 3584 of 10240 bytes

        • 2008-12-12 34748, 2008

      • jacknetgb
        tar: Error exit delayed from previous errors

        • 2008-12-12 34727, 2008

      • Muz
        How big are your tar.bz2s then?

        • 2008-12-12 34745, 2008

      • zeno has quit

        • 2008-12-12 34748, 2008

      • Muz
        And do they match the sizes on http://ftp.uk.musicbrainz.org/pub/musicbrainz/dat… ?

        • 2008-12-12 34731, 2008

      • jacknetgb
        how do i check the sizes?