#musicbrainz-devel

/

      • CatQuest joined the channel
      • 2015-07-15 19622, 2015

      • kepstin joined the channel
      • 2015-07-15 19659, 2015

      • luks
        one important reason to not using pg_dump is that you need to export and update the database at the same time
      • 2015-07-15 19609, 2015

      • luks
        otherwise you can't handle replication packets properly
      • 2015-07-15 19651, 2015

      • luks
        the acoustid format for full export is almost identical to MB
      • 2015-07-15 19601, 2015

      • luks
        but the replication format is different
      • 2015-07-15 19656, 2015

      • ariscop joined the channel
      • 2015-07-15 19617, 2015

      • Freso
        Leo_Verto: git diff $(initial commit)
      • 2015-07-15 19611, 2015

      • jeffsturgis joined the channel
      • 2015-07-15 19622, 2015

      • MBJenkins
        * Michael Wiencek: Make sure Entity::PartialDate sorts same years the same
      • 2015-07-15 19623, 2015

      • MBJenkins
        * Michael Wiencek: Events in a series should be ordered by date, then name (MBS-7557, MBS-7987)
      • 2015-07-15 19624, 2015

      • MBJenkins
        * Michael Wiencek: Release groups in a series should be ordered by first release date, then name (MBS-7557)
      • 2015-07-15 19625, 2015

      • MBJenkins
        * nikki: Fall back to more languages before giving up and picking randomly
      • 2015-07-15 19626, 2015

      • MBJenkins
        * Michael Wiencek: Do sorting from MBS-7557 on the client too
      • 2015-07-15 19621, 2015

      • MBJenkins
        Michael Wiencek: Remove test Wikipedia link type from orderable_link_type
      • 2015-07-15 19633, 2015

      • Freso joined the channel
      • 2015-07-15 19627, 2015

      • d4rkie joined the channel
      • 2015-07-15 19645, 2015

      • MBJenkins
        Yippee, build fixed!
      • 2015-07-15 19646, 2015

      • MBJenkins
        Michael Wiencek: Correctly validate date ranges between fuzzy dates
      • 2015-07-15 19621, 2015

      • MBJenkins
        Michael Wiencek: Use Date::Calc to simplify is_date_range_valid logic
      • 2015-07-15 19656, 2015

      • bitmap
        heh
      • 2015-07-15 19642, 2015

      • ianmcorvidae
        lol
      • 2015-07-15 19648, 2015

      • ianmcorvidae
        maybe not then I guess XD
      • 2015-07-15 19618, 2015

      • diana_olhovik joined the channel
      • 2015-07-15 19659, 2015

      • bitmap
        hm, well seems unrelated to that, since it fails on hobbes if I revert that too. but need to sleep now so I guess we'll find out tomorrow
      • 2015-07-15 19601, 2015

      • ariscop joined the channel
      • 2015-07-15 19605, 2015

      • ohrstrom joined the channel
      • 2015-07-15 19615, 2015

      • ruaok joined the channel
      • 2015-07-15 19602, 2015

      • reosarevok joined the channel
      • 2015-07-15 19605, 2015

      • UmkaDK joined the channel
      • 2015-07-15 19658, 2015

      • Leo_Verto
        Freso, okay, if you have two branches with a common ancestor and no rebasing or merging, you should be able to use git diff otherbranch...
      • 2015-07-15 19640, 2015

      • Freso
        Leo_Verto: Not two branches. One branch.
      • 2015-07-15 19652, 2015

      • Leo_Verto
        Hm
      • 2015-07-15 19627, 2015

      • Freso
        Leo_Verto: One branch, no branching off. I want to compare the repository (or a single file in it) from the initial commit to the current situation (or any given point in between).
      • 2015-07-15 19634, 2015

      • Leo_Verto
        git rev-list --max-parents=0 HEAD gets the first commit
      • 2015-07-15 19657, 2015

      • Leo_Verto
        so git diff $(git rev-list --max-parents=0 HEAD) HEAD should work
      • 2015-07-15 19600, 2015

      • Freso
        I can also do some `git log` magic.
      • 2015-07-15 19612, 2015

      • Leo_Verto
        git log apparently shouldn't be used for scripting
      • 2015-07-15 19657, 2015

      • Freso
        This is not for a script, or a long-winded solution like that wouldn't be a problem.
      • 2015-07-15 19612, 2015

      • Leo_Verto
        mhm, "git diff $(git rev-list --max-parents=0 HEAD) HEAD" seems to work though
      • 2015-07-15 19648, 2015

      • reosarevok
      • 2015-07-15 19609, 2015

      • ruaok
        reosarevok: I received your pm. can you please save those for issues that need to be private?
      • 2015-07-15 19611, 2015

      • ruaok
        reosarevok: please phrase your concerns in a way so that you can freely state them in public.
      • 2015-07-15 19656, 2015

      • reosarevok
        Ok, so, we have a "Good data being deleted" email that needs BDFL-looking-into
      • 2015-07-15 19605, 2015

      • reosarevok
        So you might want to take a look at it when you have some time :)
      • 2015-07-15 19622, 2015

      • ruaok
        ok, thanks, will do. I'm catching up on email now.
      • 2015-07-15 19618, 2015

      • UmkaDK joined the channel
      • 2015-07-15 19657, 2015

      • ruaok joined the channel
      • 2015-07-15 19652, 2015

      • Nyanko-sensei joined the channel
      • 2015-07-15 19624, 2015

      • Mineo
        if anyone's curious what maps like https://ddll.inf.tu-dresden.de/web/Wikidata/Maps-… would look like for mb, here's one: https://dl.dropboxusercontent.com/u/13195166/plac… :)
      • 2015-07-15 19659, 2015

      • Mineo
        https://github.com/mineo/ipython-notebooks/blob/m… is the notebook I used for making it
      • 2015-07-15 19655, 2015

      • johtso joined the channel
      • 2015-07-15 19603, 2015

      • KillDaBOB joined the channel
      • 2015-07-15 19619, 2015

      • djpretzel joined the channel
      • 2015-07-15 19606, 2015

      • kooimens joined the channel
      • 2015-07-15 19625, 2015

      • weeksio joined the channel
      • 2015-07-15 19632, 2015

      • kooimens
        Hello, guys I installed my own MB slave server with the github install.md instructions. All is working fine (including replication changes). However, I have some questions. 1. How can I disable the memory, time and data statistics when opening through the browser? 2. I'm trying to use the mbcontrol.sh startup script from this guide: http://www.tranquilbase.org/how-to-setup-your-own….
      • 2015-07-15 19611, 2015

      • kooimens
        The script is not working for me, only when I use "exec plackup -Ilib -r" instead of "exec plackup -Ilib -s FCGI -E deployment --listen $SOCKET --nproc $NPROC --pid fcgi.pid --keep-stderr=1". What do I have to change to make the last part work?
      • 2015-07-15 19616, 2015

      • diana_olhovik joined the channel
      • 2015-07-15 19642, 2015

      • rknLA joined the channel
      • 2015-07-15 19654, 2015

      • rknLA has left the channel
      • 2015-07-15 19618, 2015

      • rknLA joined the channel
      • 2015-07-15 19643, 2015

      • rknLA
        hi, i'm having some trouble figuring out the id spaces and data schemas... i'm trying to go from searching for a recording to getting information about a work
      • 2015-07-15 19600, 2015

      • rknLA
        but in the recording object, there are lots of ids, and none of them seem to resolve when i use them as work ids
      • 2015-07-15 19619, 2015

      • ruaok
        rknLA: hey.
      • 2015-07-15 19635, 2015

      • ruaok
        works are linked to recordings via what we call Advanced Relationships.
      • 2015-07-15 19644, 2015

      • ruaok
        they are not traditional SQL table relationships.
      • 2015-07-15 19611, 2015

      • ruaok
      • 2015-07-15 19613, 2015

      • rknLA
        ruaok: hm... ok.. so, is my approach even correct then?
      • 2015-07-15 19631, 2015

      • rknLA
        basically, i have a track name and artist name, and want to look up information about the track
      • 2015-07-15 19653, 2015

      • ruaok
      • 2015-07-15 19649, 2015

      • rknLA
        sorry, but i'm still super confused by these docs.. there's a lot there that looks vaguely relevant, but i don't understand how it all ties together
      • 2015-07-15 19602, 2015

      • ruaok
      • 2015-07-15 19626, 2015

      • ruaok
        using the advanced search you can construct a search with artist and track name to find a recording.
      • 2015-07-15 19637, 2015

      • ruaok
        you can send the same query to the web service as well.
      • 2015-07-15 19646, 2015

      • ruaok
        so, use the web search to hone your query first.
      • 2015-07-15 19605, 2015

      • rknLA
        ah, hm
      • 2015-07-15 19620, 2015

      • ruaok
        are you looking for a recording or a work?
      • 2015-07-15 19622, 2015

      • ruaok
      • 2015-07-15 19635, 2015

      • ruaok
        a work would be something like "beethoven's 5th".
      • 2015-07-15 19600, 2015

      • ruaok
        a recording would be "Beethoven's 5th conducted by Karajan, movement I."
      • 2015-07-15 19608, 2015

      • rknLA
        i'm looking for a work
      • 2015-07-15 19628, 2015

      • rknLA
        but the docs weren't really clear on how to search for works, and the python library had a way to search for recordings, so i figured there must be some way to go from recording to work
      • 2015-07-15 19635, 2015

      • ruaok
        this is how your search for work:
      • 2015-07-15 19636, 2015

      • ruaok
      • 2015-07-15 19646, 2015

      • ruaok
        alastairp: does the python bindings support searching works?
      • 2015-07-15 19655, 2015

      • rknLA
        there's a `get_work_by_id`, but no search
      • 2015-07-15 19601, 2015

      • alastairp
        huh
      • 2015-07-15 19606, 2015

      • alastairp
        if not, that's a bug
      • 2015-07-15 19610, 2015

      • rknLA
        it also looks like not every recording has a work associated with it?
      • 2015-07-15 19617, 2015

      • alastairp
        and a pretty big one at that
      • 2015-07-15 19619, 2015

      • alastairp
        rknLA: correct
      • 2015-07-15 19646, 2015

      • alastairp
        oh, there is a `search_works` method
      • 2015-07-15 19647, 2015

      • ruaok
        alastairp is the person to help you with the python bindings.
      • 2015-07-15 19628, 2015

      • alastairp
        however, perhaps you are after the browse methods
      • 2015-07-15 19642, 2015

      • rknLA
        alastairp: looks like it's not documented at https://python-musicbrainzngs.readthedocs.org/en/…
      • 2015-07-15 19651, 2015

      • alastairp
        which let you say "give me items of one type based on relationships to another type"
      • 2015-07-15 19646, 2015

      • rknLA
        it's there if i run `dir(musicbrainzngs)`, but i didn't think to do that
      • 2015-07-15 19628, 2015

      • alastairp
      • 2015-07-15 19629, 2015

      • rknLA
        so, at a high level, my goal is to find the songwriter of a recording.. is there any kind of convention for which recordings have works associated with them?
      • 2015-07-15 19632, 2015

      • alastairp
        I'll regenerate the docs
      • 2015-07-15 19651, 2015

      • rknLA
        :) glad to help!
      • 2015-07-15 19616, 2015

      • reosarevok
        ruaok: heh. that last email was... interesting :p
      • 2015-07-15 19618, 2015

      • alastairp
        the only convention is "if it exists and someone has added it"
      • 2015-07-15 19628, 2015

      • alastairp
        the important part being this "if someone has added it"
      • 2015-07-15 19648, 2015

      • rknLA
        word
      • 2015-07-15 19610, 2015

      • ruaok
        reosarevok: yep. lots of interesting stuff coming. :)
      • 2015-07-15 19643, 2015

      • darwin
        (I think what other people call Advanced Relationships is https://en.wikipedia.org/wiki/Entity%E2%80%93attr…)
      • 2015-07-15 19644, 2015

      • ruaok
        ok, I need to run off now. back online later to try and tame my inbox some more.
      • 2015-07-15 19655, 2015

      • rknLA
        completely off topic: once upon a time I read that reddit's entire database schema was EAV.
      • 2015-07-15 19655, 2015

      • alastairp
      • 2015-07-15 19606, 2015

      • ruaok
        alastairp: thanks for helping rknLA
      • 2015-07-15 19610, 2015

      • alastairp
        I think this is what you're trying to do?
      • 2015-07-15 19610, 2015

      • ruaok
        ttfn!
      • 2015-07-15 19624, 2015

      • alastairp
        however, you need to start somewhere I guess?
      • 2015-07-15 19644, 2015

      • alastairp
        I don't think there's a way of saying "give me all works which have a lyricist or composer set"
      • 2015-07-15 19650, 2015

      • rknLA
        alastairp: yeah, basically
      • 2015-07-15 19640, 2015

      • rknLA
        right now i'm looking at that like 'search works for: "we will rock you" artist:(queen)' and hoping to get the work directly?
      • 2015-07-15 19607, 2015

      • alastairp
        if you know the song name, work search is good
      • 2015-07-15 19615, 2015

      • rknLA
        yeah, i know the song name of the recording
      • 2015-07-15 19628, 2015

      • alastairp
        oh, perfect
      • 2015-07-15 19634, 2015

      • rknLA
        whether or not that's also the name of the original is a different question, but yeah
      • 2015-07-15 19639, 2015

      • alastairp
        ah
      • 2015-07-15 19659, 2015

      • alastairp
        well, you could always do a recording search, and then add the include=["work-rels"] parameter to get information about works
      • 2015-07-15 19629, 2015

      • rknLA
      • 2015-07-15 19634, 2015

      • rknLA
        yeah, i think recording search is the ticket
      • 2015-07-15 19653, 2015

      • rknLA
        also, it looks like the search method does its damndest to return you _something_ even when there's no real strong/exact match?
      • 2015-07-15 19636, 2015

      • rknLA
        also, search doesn't support `includes`, right? so there are at least 3 web calls per attempt here?
      • 2015-07-15 19637, 2015

      • alastairp
        correct, search doesn't support includes
      • 2015-07-15 19646, 2015

      • alastairp
        you could check for a score of 100 in the results
      • 2015-07-15 19604, 2015

      • rknLA
        ahhh score, perfect
      • 2015-07-15 19647, 2015

      • alastairp
        you'll probably find that many of the recordings in the search results will have the same work
      • 2015-07-15 19657, 2015

      • alastairp
        but I don't think you can find that out until you query each of them
      • 2015-07-15 19619, 2015

      • rknLA
        gotcha.
      • 2015-07-15 19626, 2015

      • rknLA
        another question, about `id`:
      • 2015-07-15 19609, 2015

      • rknLA
        what is the id in a `track-list` item? it didn't look like there was a concept of `track` in mb
      • 2015-07-15 19604, 2015

      • alastairp
        yes, tracks are not really exposed in the website much
      • 2015-07-15 19612, 2015

      • alastairp
        a track is "a recording in this specific release"
      • 2015-07-15 19621, 2015

      • alastairp
        because recordings can appear on many releases
      • 2015-07-15 19644, 2015

      • rknLA
        gotcha
      • 2015-07-15 19624, 2015

      • rknLA
        hmm... how is `ext:score` calculated? i just got a score of 100 when the artist matched correctly, but the track that i searched for was not in the system
      • 2015-07-15 19652, 2015

      • alastairp
        it's returned by lucene. I don't know how it's computed
      • 2015-07-15 19605, 2015

      • alastairp
        note that you can use the advanced search syntax and tell it to match only on the title field
      • 2015-07-15 19610, 2015

      • alastairp
      • 2015-07-15 19617, 2015

      • rknLA
        yeah, i saw that with the http requests... is that supported by the python lib?
      • 2015-07-15 19648, 2015

      • rknLA
        ah, strict=True
      • 2015-07-15 19600, 2015

      • alastairp
        great :)
      • 2015-07-15 19645, 2015

      • alastairp
        mb.search_recordings("title:we will rock you", strict=True)
      • 2015-07-15 19650, 2015

      • alastairp
        for example
      • 2015-07-15 19628, 2015

      • rknLA
        gotcha