#metabrainz

/

      • ruaok
        no really?

        • 2016-03-14 07416, 2016

      • mihaitish joined the channel

        • 2016-03-14 07402, 2016

      • kanha joined the channel

        • 2016-03-14 07437, 2016

      • ruaok
        nope.

        • 2016-03-14 07440, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-03-14 07410, 2016

      • D4RK-PH0ENiX has quit

        • 2016-03-14 07416, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-03-14 07400, 2016

      • ruaok
        feh. busy week is busy.

        • 2016-03-14 07413, 2016

      • ruaok
        signing office lease today. signing company formation docs on thursday.

        • 2016-03-14 07420, 2016

      • ruaok
        finding some furniture in between

        • 2016-03-14 07420, 2016

      • mr-karan_
        LordSputnik: Hope you are around, npm install is taking a bit of time, I'm reading the docs in the meanwhile

        • 2016-03-14 07418, 2016

      • reosarevok
        ruaok: at least you finally get to stop borrowing places to be busy in :p

        • 2016-03-14 07438, 2016

      • ruaok
        yeah, thats actually kinda nice.

        • 2016-03-14 07444, 2016

      • ruaok
        but the coffee here at MOB is really good.

        • 2016-03-14 07453, 2016

      • ruaok
        not sure how to solve that at the new place.

        • 2016-03-14 07459, 2016

      • reosarevok
        Ask MOB where they get theirs?

        • 2016-03-14 07405, 2016

      • ruaok
        keeping fresh beans stocked is kinda a pain.

        • 2016-03-14 07423, 2016

      • ruaok
        I know where, but I only occasionally drink coffee after lunch.

        • 2016-03-14 07437, 2016

      • ruaok
        I suppose the nearest drinkable coffee place is just 200m away, so not too bad.

        • 2016-03-14 07409, 2016

      • ruaok
        Oh and I scavenged a giant piece of wood from the steets.

        • 2016-03-14 07418, 2016

      • ruaok
        I can carve us cool signs for the office. :)

        • 2016-03-14 07435, 2016

      • reosarevok
        :)

        • 2016-03-14 07437, 2016

      • ruaok
        I want to make a mobile with all of our project icons. :)

        • 2016-03-14 07441, 2016

      • reosarevok
        haha

        • 2016-03-14 07456, 2016

      • ruaok
        the office is going to need serious decorations. and color.

        • 2016-03-14 07429, 2016

      • reosarevok
        "Sir are you sure you want 40 l of bright orange paint?

        • 2016-03-14 07435, 2016

      • reosarevok
        "

        • 2016-03-14 07444, 2016

      • ruaok
        THAT

        • 2016-03-14 07412, 2016

      • ruaok
        I'm nearly certain that I'll do some painting in my office.

        • 2016-03-14 07417, 2016

      • mr-karan_
        LordSputnik: Hey, bookbrainz us up and running

        • 2016-03-14 07421, 2016

      • mr-karan_
        http://i.imgur.com/eM9WVT9.png

        • 2016-03-14 07400, 2016

      • diana_olhovyk joined the channel

        • 2016-03-14 07400, 2016

      • diana_olhovyk_ has quit

        • 2016-03-14 07441, 2016

      • Leftmost
        Freso, I won't be able to be around, unfortunately. Anything I can contribute now or afterward?

        • 2016-03-14 07450, 2016

      • mr-karan_
        LordSputnik: Installed redis. Is there any README on how to setup the webservice ?

        • 2016-03-14 07434, 2016

      • mihaitish has quit

        • 2016-03-14 07419, 2016

      • mihaitish joined the channel

        • 2016-03-14 07409, 2016

      • ruaok
        Leftmost: we most care about your general thoughts toward gosc wrt to bb.

        • 2016-03-14 07427, 2016

      • ruaok
        but, I suspect that LordSputnik can do that. if he turns up. :)

        • 2016-03-14 07426, 2016

      • UmkaDK joined the channel

        • 2016-03-14 07425, 2016

      • UmkaDK_ has quit

        • 2016-03-14 07427, 2016

      • mihaitish has quit

        • 2016-03-14 07431, 2016

      • LordSputnik
        mr-karan_: good job on getting it up and running

        • 2016-03-14 07434, 2016

      • LordSputnik
        ruaok: I'll be there

        • 2016-03-14 07442, 2016

      • ruaok
        k

        • 2016-03-14 07422, 2016

      • LordSputnik
        mr-karan_: there are no instructions for the WS at the moment, unfortunately

        • 2016-03-14 07429, 2016

      • LordSputnik
        However, there is this conversation: http://chatlogs.metabrainz.org/brainzbot/metabrai…

        • 2016-03-14 07447, 2016

      • mr-karan_
        LordSputnik: Thanks taking a look

        • 2016-03-14 07400, 2016

      • LordSputnik
        You should be able to follow that to download the data dumps, set up the database and get the WS running

        • 2016-03-14 07437, 2016

      • LordSputnik
        If you wanted to write some instructions as you go along, that would be wonderful, but if not, I will hopefully get around to it soon (hopefully (maybe))

        • 2016-03-14 07423, 2016

      • mr-karan_
        If I get it working,I'll surely document if for other new users like me :P

        • 2016-03-14 07413, 2016

      • Jormangeud has quit

        • 2016-03-14 07414, 2016

      • LordSputnik
        Thanks very much! Let me know if you get stuck/have any questions, I'll be around on here on and off for the next few hours

        • 2016-03-14 07435, 2016

      • Jormangeud joined the channel

        • 2016-03-14 07441, 2016

      • mr-karan_
        sure LordSputnik

        • 2016-03-14 07459, 2016

      • reosarevok
        Freso: I forget, did we already set up an autoeditor election framework?

        • 2016-03-14 07414, 2016

      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting agenda: Reviews; Schema change review (ruaok), GSoC update (ruaok), DR “nostalgia edition”: MBS-6396, MBS-7501, MBS-7564 (chirlu?); DR: MBS-3722 (Freso)

        • 2016-03-14 07400, 2016

      • armalcolite joined the channel

        • 2016-03-14 07452, 2016

      • typhoe has quit

        • 2016-03-14 07402, 2016

      • typhoe joined the channel

        • 2016-03-14 07409, 2016

      • Jormangeud has quit

        • 2016-03-14 07451, 2016

      • Jormangeud joined the channel

        • 2016-03-14 07456, 2016

      • mr-karan_
        LordSputnik: i need to run python setup.py bootstrap --blank from which repo ? bookbrainz-ws ?

        • 2016-03-14 07429, 2016

      • mr-karan_
        there's no setup.py in that FWIW

        • 2016-03-14 07435, 2016

      • jcazevedo has quit

        • 2016-03-14 07413, 2016

      • LordSputnik
        mr-karan_: that'd be the bookbrainz-schema repo

        • 2016-03-14 07438, 2016

      • LordSputnik
        mr-karan_: Actually, those steps I linked probably aren't going to work. If you're OK to wait, I can write up some proper instructions later?

        • 2016-03-14 07454, 2016

      • mr-karan_
        Ah alright. I'll wait np :)

        • 2016-03-14 07411, 2016

      • jcazevedo joined the channel

        • 2016-03-14 07452, 2016

      • ruaok
        should I pick this up for the new office?

        • 2016-03-14 07453, 2016

      • ruaok
        https://es.wallapop.com/item/sofa-3-pax-regalo-bu…

        • 2016-03-14 07426, 2016

      • darwin_ is now known as darwin

        • 2016-03-14 07440, 2016

      • ruaok
        and then of course: https://es.wallapop.com/item/sofa-2-plazas-color-…

        • 2016-03-14 07456, 2016

      • ruaok
        ok, my office is sorted. what else? :)

        • 2016-03-14 07458, 2016

      • kuno
        >_<

        • 2016-03-14 07430, 2016

      • jaron has quit

        • 2016-03-14 07445, 2016

      • gcilou
        alastairp: have you had a chance to look at https://github.com/metabrainz/acousticbrainz-serv… ?

        • 2016-03-14 07400, 2016

      • alastairp
        not yet, sorry. thanks for sending it though

        • 2016-03-14 07408, 2016

      • alastairp
        the screenshots looked good

        • 2016-03-14 07423, 2016

      • alastairp
        I’ve got a bunch of stuff I’m working on for AcousticBrainz over the next 2 weeks, so don’t have a lot of time

        • 2016-03-14 07436, 2016

      • gcilou
        alright, that's fine!

        • 2016-03-14 07414, 2016

      • alastairp
        today's statistic: 51567 unique artist ids in acousticbrainz

        • 2016-03-14 07436, 2016

      • diana_olhovyk has quit

        • 2016-03-14 07436, 2016

      • mootwo joined the channel

        • 2016-03-14 07410, 2016

      • mootwo
        hi guys... anyone know an easy way to get this via the xml web service? https://musicbrainz.org/tag/pop/artist

        • 2016-03-14 07419, 2016

      • alastairp
        http://musicbrainz.org/ws/2/artist/?query=tag:pop ?

        • 2016-03-14 07443, 2016

      • JesseW joined the channel

        • 2016-03-14 07443, 2016

      • kepstin
        mootwo: I don't think that exact data is available, but using the search api like alastairp's link is probably sufficient for most cases

        • 2016-03-14 07413, 2016

      • kepstin
        in particular, the search api doesn't sort based on tag counts

        • 2016-03-14 07435, 2016

      • mootwo
        alastairp - brilliant, thanks

        • 2016-03-14 07452, 2016

      • alastairp
        yeah, it's likely that the website view is a direct sql query

        • 2016-03-14 07403, 2016

      • alastairp
        but that is definitely not exposed via the lookup webservice

        • 2016-03-14 07430, 2016

      • mootwo
        so the same info from the web app is not necessarily exposed via the xml service?

        • 2016-03-14 07432, 2016

      • kepstin
        mootwo: yes, that's true in a lot of cases :/

        • 2016-03-14 07408, 2016

      • mootwo
        kepstin: interesting thanks

        • 2016-03-14 07419, 2016

      • kepstin
        it's mostly because the two were originally developed beside each-other - since the website could access the sql db directly, it could do custom views, and they weren't always done on the api side as well.

        • 2016-03-14 07440, 2016

      • mootwo
        so the website does not use the api in its backend then

        • 2016-03-14 07439, 2016

      • kepstin
        exactly.

        • 2016-03-14 07422, 2016

      • mootwo
        ok then let me ask a dumb question, and i think i already know the answer...

        • 2016-03-14 07457, 2016

      • mootwo
        is there any API that allows me to get the same data as the web app, without the frontend?

        • 2016-03-14 07437, 2016

      • kepstin
        not an "api" per say, but you can always replicate the db and run sql queries directly.

        • 2016-03-14 07409, 2016

      • mootwo
        yeah we're already doing that, and with help from here ive been able to source a lot of the data... but some things are not in the database

        • 2016-03-14 07417, 2016

      • mootwo
        like artist bio for example

        • 2016-03-14 07429, 2016

      • Jormangeud has quit

        • 2016-03-14 07430, 2016

      • kepstin
        artist bios are pulled from wikipedia via javascript

        • 2016-03-14 07431, 2016

      • kepstin
        that'll let you do anything the website can do, and more if you can think of it :)

        • 2016-03-14 07404, 2016

      • mootwo
        right but then i have to know how to use the wikidata api lol

        • 2016-03-14 07407, 2016

      • Jormangeud joined the channel

        • 2016-03-14 07426, 2016

      • mootwo
        just was trying to avoid doing extra work if it was already available as par tof the server

        • 2016-03-14 07440, 2016

      • kepstin
        hmm. actually, are they done via js? either way, the bios are pulled from wikipedia as part of the web page rendering

        • 2016-03-14 07443, 2016

      • mootwo
        so... the xml web service by nature would only access data that's actually in the database, and even then only a subset of that, correct?

        • 2016-03-14 07417, 2016

      • mootwo
        meaning even if the xml api is ok for some data, for others (like the artist bio), i would still have to parse on my own?

        • 2016-03-14 07435, 2016

      • kepstin
        yeah

        • 2016-03-14 07444, 2016

      • mootwo
        gotcha ok thanks

        • 2016-03-14 07448, 2016

      • kepstin
        the api will only ever return data we store locally, at best

        • 2016-03-14 07454, 2016

      • kepstin
        for linked data, you follow the links :)

        • 2016-03-14 07436, 2016

      • kepstin
        (e.g. cover art you get by doing a separate query to the coverartarchive servers)

        • 2016-03-14 07408, 2016

      • mootwo
        understood, thanks

        • 2016-03-14 07457, 2016

      • Jormangeud has quit

        • 2016-03-14 07423, 2016

      • Jormangeud joined the channel

        • 2016-03-14 07416, 2016

      • JesseW has quit

        • 2016-03-14 07454, 2016

      • mihaitish joined the channel

        • 2016-03-14 07423, 2016

      • mootwo
        does the info listed under an artist's "relationship" tab come from the database or externally? specifically interested in things like "founding member of" and "member of" etc, to determine what other bands an artist has appeared in

        • 2016-03-14 07425, 2016

      • mihaitish has quit

        • 2016-03-14 07423, 2016

      • regagain joined the channel

        • 2016-03-14 07458, 2016

      • bitmap
        those are all stored in the database

        • 2016-03-14 07403, 2016

      • mootwo
        bitmap: thanks, which tables should i start looking in?

        • 2016-03-14 07422, 2016

      • bitmap
        well, artist-artist relationships are in the l_artist_artist table

        • 2016-03-14 07412, 2016

      • mootwo
        is there a doc somewhere showing how these l_ tables work?

        • 2016-03-14 07441, 2016

      • mootwo
        i didnt see them in the schema diagram

        • 2016-03-14 07450, 2016

      • bitmap
        http://wiki.musicbrainz.org/Database_Schema#Relat… :)

        • 2016-03-14 07417, 2016

      • mootwo
        ahhh ok i feel dumb now, thank u

        • 2016-03-14 07429, 2016

      • mike_aiir joined the channel

        • 2016-03-14 07436, 2016

      • mike_aiir has quit

        • 2016-03-14 07425, 2016

      • Mineo joined the channel

        • 2016-03-14 07454, 2016

      • LordSputnik
        mr-karan_: I've added instructions in the schema and ws repositories :) Follow the schema ones first

        • 2016-03-14 07417, 2016

      • LordSputnik
        mr-karan_: https://bookbrainz.org/bbdump-structure.sql is the file for loading up the schema, then the data dumps are the ones in the chatlog I linked earlier

        • 2016-03-14 07421, 2016

      • LordSputnik
        (https://bookbrainz.org/bbdump-core-20160212.tar.b… https://bookbrainz.org/bbdump-derived-20160212.ta… https://bookbrainz.org/bbdump-editor-20160212.tar…)

        • 2016-03-14 07421, 2016

      • mootwo
        in the l_ tables, what is the difference between entity0 and entity1?

        • 2016-03-14 07453, 2016

      • kepstin
        entity0 is the first end of the link, entity1 is the second end.

        • 2016-03-14 07413, 2016

      • kepstin
        to understand the meaning of them, you have to know what the type of link is

        • 2016-03-14 07400, 2016

      • mootwo
        kepstin: understood but for example in artist:artist, im trying to determine what other bands an artists has appeared in... is there a difference if artist X is in entity0 or entity1?

        • 2016-03-14 07430, 2016

      • mr-karan_
        Thanks . I'm on it :)

        • 2016-03-14 07434, 2016

      • mr-karan_
        LordSputnik:

        • 2016-03-14 07444, 2016

      • kepstin
        mootwo: you have to check the docs for the relationship

        • 2016-03-14 07452, 2016

      • kepstin
        mootwo: e.g. "member of band is" https://musicbrainz.org/relationship/5be4c609-9af…

        • 2016-03-14 07411, 2016

      • kepstin
        which means that entity0 will be the person, and entity1 will be the group that they are a member of

        • 2016-03-14 07402, 2016

      • mootwo
        kepstin: i understand now, thanks again for the help

        • 2016-03-14 07447, 2016

      • mr-karan_
        btw, LordSputnik why 2 README in ws repo ?

        • 2016-03-14 07413, 2016

      • kepstin
        if it's not obvious from the doc page, you read it as "{entity0} Long link phrase {entity1}" to see the direction :/