#musicbrainz

/

      • cikkolata
        bleh

        • 2005-04-01 09157, 2005

      • bmaury has quit

        • 2005-04-01 09114, 2005

      • tro has quit

        • 2005-04-01 09122, 2005

      • tro joined the channel

        • 2005-04-01 09106, 2005

      • bmaury joined the channel

        • 2005-04-01 09142, 2005

      • bmaury
        i want to install the musicbrainz tables in a database already populated with other tables, procedures, etc. i'm fairly sure there are no naming conflicts. any other problems with doing this?

        • 2005-04-01 09127, 2005

      • ruaok
        bmaury: its been done -- the audioscrobbler's have done it.

        • 2005-04-01 09135, 2005

      • bmaury
        awesome, thank you. we have a similar data model, with reviews linked to the artist, album and (hopefully) track. i wish i had come across your data about 3 months ago...

        • 2005-04-01 09156, 2005

      • ruaok
        I've heard that before. :-)

        • 2005-04-01 09104, 2005

      • bmaury
        i bet...

        • 2005-04-01 09130, 2005

      • cikkolata
        ooh, life.

        • 2005-04-01 09137, 2005

      • bmaury
        check it out if you'd like: http://orpheus.notlong.com. the demo shows what we are aiming for.

        • 2005-04-01 09126, 2005

      • ruaok
        url doesn't work

        • 2005-04-01 09129, 2005

      • ruaok waves at cikkolata

        • 2005-04-01 09141, 2005

      • cikkolata
        hi

        • 2005-04-01 09156, 2005

      • bmaury
        http://groups.sims.berkeley.edu/orpheus/

        • 2005-04-01 09111, 2005

      • bmaury
        that should work...

        • 2005-04-01 09148, 2005

      • ruaok
        sounds like fun

        • 2005-04-01 09102, 2005

      • bmaury
        sure is.

        • 2005-04-01 09116, 2005

      • ruaok
        I'll stash the link for now. I'll read up on it in more detail later...

        • 2005-04-01 09118, 2005

      • bmaury
        cool. you guys are doing awesome work. i've been sitting on some of the mailing lists for a while, but didn't start checking out the data until yesterday. really impressive.

        • 2005-04-01 09127, 2005

      • ruaok
        thanks.

        • 2005-04-01 09134, 2005

      • ruaok
        we've come a looong way. that's for sure.

        • 2005-04-01 09159, 2005

      • ruaok
        there are some really dedicated people part of this project.

        • 2005-04-01 09113, 2005

      • bmaury
        when are the AdvancedRelations coming out?

        • 2005-04-01 09146, 2005

      • ruaok
        april 9th.

        • 2005-04-01 09156, 2005

      • bmaury
        really?

        • 2005-04-01 09157, 2005

      • cikkolata
        wow, there's a date?

        • 2005-04-01 09100, 2005

      • ruaok
        have you played with them on the test server?

        • 2005-04-01 09113, 2005

      • ruaok
        djce and I are trying to pull together the plan.

        • 2005-04-01 09121, 2005

      • bmaury
        not yet. just got the live data set up.

        • 2005-04-01 09131, 2005

      • ruaok
        we should have everything nailed down this weekend.

        • 2005-04-01 09142, 2005

      • ruaok
        test.musicbrainz.org if you want to play.

        • 2005-04-01 09102, 2005

      • bmaury
        cool, thanks. i love the artistalias and artist_relation data i'm looking at.

        • 2005-04-01 09117, 2005

      • ruaok
        we're going to merge the branch this weekend and then call for the last and final round of testing

        • 2005-04-01 09135, 2005

      • bmaury
        what kind of testing are you doing?

        • 2005-04-01 09155, 2005

      • ruaok
        1000 monkeys will eventually create all works of shakespeare.

        • 2005-04-01 09100, 2005

      • ruaok
        sp?

        • 2005-04-01 09113, 2005

      • bmaury
        that will be awesome

        • 2005-04-01 09123, 2005

      • ruaok
        if you catch my drift. :-)

        • 2005-04-01 09151, 2005

      • bmaury
        i'm getting there...

        • 2005-04-01 09106, 2005

      • ruaok
        bmaury: got a q for ya....

        • 2005-04-01 09115, 2005

      • bmaury
        k

        • 2005-04-01 09117, 2005

      • ruaok
        I take it you're a berkeley student?

        • 2005-04-01 09122, 2005

      • bmaury
        yes

        • 2005-04-01 09149, 2005

      • ruaok
        I need to find a good music prof -- do you know any that are somewhat technically minded?

        • 2005-04-01 09157, 2005

      • ruaok
        how well do you know AR?

        • 2005-04-01 09114, 2005

      • bmaury
        i don't really...

        • 2005-04-01 09115, 2005

      • ruaok
        AR has the possiblity for having an instrument attribute for a given link

        • 2005-04-01 09135, 2005

      • ruaok
        and our hierarchy of music instruments sucks.

        • 2005-04-01 09145, 2005

      • ruaok
        And having a cleaner one to start with is key.

        • 2005-04-01 09145, 2005

      • bmaury
        i can inquire with some of my professors...

        • 2005-04-01 09152, 2005

      • ruaok
        that would be lovely.

        • 2005-04-01 09158, 2005

      • ruaok
        unfortunately I'm running out of time.

        • 2005-04-01 09103, 2005

      • ruaok
        Apr 9 is coming *fast*.

        • 2005-04-01 09155, 2005

      • bmaury
        a hierarchy of music instruments. a faceted hierarchy, i presume? do you have a link?

        • 2005-04-01 09107, 2005

      • ruaok
        one sec.

        • 2005-04-01 09153, 2005

      • ruaok
        http://cvs.musicbrainz.org/cvs/mb_server/admin/ar…

        • 2005-04-01 09100, 2005

      • ruaok
        This is our crude import format.

        • 2005-04-01 09116, 2005

      • ruaok
        the brackets are the descriptions for the instruments (attributes in general)

        • 2005-04-01 09131, 2005

      • ruaok
        which means, they're essentially empty. :-(

        • 2005-04-01 09114, 2005

      • ruaok
        The fact that bazooka is 4th level down, is worrying me.

        • 2005-04-01 09124, 2005

      • ruaok
        I *like* that its there, but its a little promiment.

        • 2005-04-01 09100, 2005

      • bmaury
        this is a great problem. i wish i had more time. i'm banging away on my final project. due may 10th.

        • 2005-04-01 09127, 2005

      • bmaury
        i'll send out some emails and see if anyone can help. i have a couple of people in mind.

        • 2005-04-01 09155, 2005

      • ruaok
        awesome -- I appreciate it.

        • 2005-04-01 09104, 2005

      • ruaok
        that stuff is a little low tech for my skills. :-)

        • 2005-04-01 09155, 2005

      • ruaok
        if you give me a your email, I'll forward you a mail that states the problem in a bit more detail

        • 2005-04-01 09143, 2005

      • bmaury
        brookem [at sims.berkeley.edu]

        • 2005-04-01 09139, 2005

      • ruaok
        setn

        • 2005-04-01 09140, 2005

      • ruaok
        er

        • 2005-04-01 09142, 2005

      • ruaok
        sent

        • 2005-04-01 09120, 2005

      • lind has quit

        • 2005-04-01 09118, 2005

      • bmaury
        got it, and sent it out to two musicians (a sax player in the berkeley jazz band and a professional cellist) who are in my program (which deals with just this kind of organizational problem). i'm sure if they had more time, they'd help out. but we are all dealing with our theses. hopefully they will come back with some suggestions or contacts.

        • 2005-04-01 09143, 2005

      • ruaok
        awesome -- thanks mucho.

        • 2005-04-01 09151, 2005

      • ruaok
        and I look forward to reading more about your project.

        • 2005-04-01 09102, 2005

      • bmaury
        thanks, ruoak. hopefully i'll be able to pitch in to mb in a couple of months.

        • 2005-04-01 09111, 2005

      • bmaury
        er ruaok.

        • 2005-04-01 09116, 2005

      • ruaok 'd love that

        • 2005-04-01 09132, 2005

      • ruaok
        I get up to Berkeley pretty often too.

        • 2005-04-01 09116, 2005

      • bmaury
        cool. i'm in sf. shoot me an email if you are in the area.

        • 2005-04-01 09117, 2005

      • ruaok
        I have good friends that live at Claremont & Prince...

        • 2005-04-01 09135, 2005

      • ruaok
        will do.

        • 2005-04-01 09108, 2005

      • bmaury
        one more question for you: if i want to bypass the perl scripts, and just write a quick shell program to create and populate the tables, would i be able to figure out the proper order of the sql scripts in the mb_server/admin/sql directory, and then just load the data using \copy?

        • 2005-04-01 09116, 2005

      • bmaury
        or should i just try it?

        • 2005-04-01 09155, 2005

      • ruaok
        the perl scripts are *robust* and *fast*.

        • 2005-04-01 09103, 2005

      • ruaok
        I can't recommend them highly enough.

        • 2005-04-01 09110, 2005

      • bmaury
        yeah, they work great on my machine.

        • 2005-04-01 09127, 2005

      • bmaury
        but i don't have root at school, and i'm missing some modules...

        • 2005-04-01 09142, 2005

      • ruaok
        which modules?

        • 2005-04-01 09128, 2005

      • bmaury
        one sec...

        • 2005-04-01 09141, 2005

      • ruaok
        you don't need all of them for just importing the data.

        • 2005-04-01 09149, 2005

      • ruaok
        most of the them relate to the use of the web site.

        • 2005-04-01 09107, 2005

      • ruaok
        DBI and DBD::Pg are the most crucial ones.

        • 2005-04-01 09134, 2005

      • ruaok
        to be safe, import the data into a clean/disposable DB that you're importing to.

        • 2005-04-01 09153, 2005

      • bmaury
        yeah, i commented out all the stuff i thought i didn't need in MusicBrainz.pm, but i'm still missing String::Similarity

        • 2005-04-01 09110, 2005

      • ruaok
        you don't need that for DB import.

        • 2005-04-01 09119, 2005

      • djce has quit

        • 2005-04-01 09135, 2005

      • bmaury
        ahh. okay. i figured i didn't.

        • 2005-04-01 09138, 2005

      • cikkolata blinks

        • 2005-04-01 09103, 2005

      • cikkolata
        I don't remember needing to install anything (already had dbi) when I imported the data

        • 2005-04-01 09110, 2005

      • cikkolata
        trying to get apache to start... hah!

        • 2005-04-01 09119, 2005

      • bmaury
        he he.

        • 2005-04-01 09137, 2005

      • bmaury
        all i need is the data. we have our own app server.

        • 2005-04-01 09136, 2005

      • yalaforge joined the channel

        • 2005-04-01 09146, 2005

      • cikkolata
        hi!

        • 2005-04-01 09152, 2005

      • yalaforge
        hey! still up?

        • 2005-04-01 09155, 2005

      • cikkolata
        yep

        • 2005-04-01 09106, 2005

      • ruaok
        moin moin!

        • 2005-04-01 09110, 2005

      • yalaforge
        morgen!

        • 2005-04-01 09131, 2005

      • yalaforge noticed another db import going on via the chatlogs :-)

        • 2005-04-01 09124, 2005

      • cikkolata finds it amusing that yalaforge seems to sit reading the chatlogs rather than sit in here reading it normally

        • 2005-04-01 09143, 2005

      • ruaok
        yalaforge: http://groups.sims.berkeley.edu/orpheus/

        • 2005-04-01 09150, 2005

      • ruaok
        bmaury's project

        • 2005-04-01 09155, 2005

      • yalaforge looks

        • 2005-04-01 09122, 2005

      • yalaforge
        cikkolata: *my* computer is off, at least sometimes :-)

        • 2005-04-01 09152, 2005

      • yalaforge
        and I always check the chatlogs before turning it off, just to make sure you're not talking bad about me behind my back :-P

        • 2005-04-01 09125, 2005

      • cikkolata
        I remember when I was saying bye and you left too soon, so you came back

        • 2005-04-01 09136, 2005

      • cikkolata
        I wondered what was going on then :P

        • 2005-04-01 09139, 2005

      • yalaforge
        :-)

        • 2005-04-01 09142, 2005

      • moZZZZ
        hi

        • 2005-04-01 09148, 2005

      • yalaforge
        hey mo

        • 2005-04-01 09150, 2005

      • moZZZZ
        moZZZZ is now known as mo_

        • 2005-04-01 09155, 2005

      • mo_
        :D

        • 2005-04-01 09101, 2005

      • mo_
        good morning

        • 2005-04-01 09106, 2005

      • ruaok
        must be morning in europe. :-)

        • 2005-04-01 09116, 2005

      • mo_
        about 09:35 here

        • 2005-04-01 09120, 2005

      • yalaforge
        ruaok: I played on the test server a bit. do we have someone to create cute icons?

        • 2005-04-01 09128, 2005

      • ruaok
        donredman. :-)

        • 2005-04-01 09138, 2005

      • yalaforge
        I mean displaying 'Type: person' isn't cool

        • 2005-04-01 09140, 2005

      • ruaok
        whatchahaveinmind?

        • 2005-04-01 09145, 2005

      • cikkolata
        hi mo!

        • 2005-04-01 09149, 2005

      • ruaok
        ah yes. we did talk about that.

        • 2005-04-01 09154, 2005

      • cikkolata
        I was thinking icons too

        • 2005-04-01 09155, 2005

      • yalaforge
        great

        • 2005-04-01 09109, 2005

      • ruaok
        he did some other icons.

        • 2005-04-01 09117, 2005

      • ruaok
        he never liked the star icon, which I liked.

        • 2005-04-01 09127, 2005

      • yalaforge is another one who has more and more feature requests ;-)

        • 2005-04-01 09137, 2005

      • ruaok
        I think we should use the mic and maybe one that has cute people on it.

        • 2005-04-01 09150, 2005

      • cikkolata
        star icon?

        • 2005-04-01 09103, 2005

      • yalaforge
        actually, I don't care which one, just to differentiate between person and group

        • 2005-04-01 09115, 2005

      • bmaury
        That dang String::Similarity module gets referenced in mb_server/cgi-bin/MusicBrainz/Server/Database.pm.

        • 2005-04-01 09126, 2005

      • ruaok
        arg.

        • 2005-04-01 09140, 2005

      • ruaok
        so, is your limitation not having root?

        • 2005-04-01 09145, 2005

      • yalaforge
        not in my copy

        • 2005-04-01 09147, 2005

      • mo_
        hi cikkolata

        • 2005-04-01 09155, 2005

      • yalaforge
        (I'm working on a slightly older branch)

        • 2005-04-01 09131, 2005

      • bmaury
        yeah, pretty much. that and not really having a clean db for install.

        • 2005-04-01 09132, 2005

      • ruaok
        if you're not root you can install a local copy of it into your dir and then adjust the include path as appropriate

        • 2005-04-01 09153, 2005

      • yalaforge
        String::Similarity needs to be patched, btw