#metabrainz

/

      • Tempest_ joined the channel
      • 2015-09-15 25830, 2015

      • Mineo
        it might be better to rename the everything called artist to artist_credit to avoid confusion
      • 2015-09-15 25840, 2015

      • Mineo
        although artist credits in mb don't have a gid
      • 2015-09-15 25802, 2015

      • alastairp
        ok, good idea
      • 2015-09-15 25825, 2015

      • alastairp
        to make sure that people don't confuse it with mb artists
      • 2015-09-15 25845, 2015

      • ruaok
        I'm confused by the FK comment on line 29.
      • 2015-09-15 25851, 2015

      • alastairp
        it has to be "artist credit", because the lowest common denominator is itunes
      • 2015-09-15 25858, 2015

      • ruaok
        you define no table called clusters
      • 2015-09-15 25825, 2015

      • alastairp
        ruaok: error in upgrading the schema, should be recording_cluster.cluster_id
      • 2015-09-15 25834, 2015

      • ruaok
        k
      • 2015-09-15 25841, 2015

      • alastairp
        fixed
      • 2015-09-15 25853, 2015

      • ruaok
        thx
      • 2015-09-15 25808, 2015

      • ruaok
        that simple schema blew up, didn't it?
      • 2015-09-15 25815, 2015

      • ruaok
        as it always does
      • 2015-09-15 25831, 2015

      • alastairp
        yeah
      • 2015-09-15 25842, 2015

      • alastairp
        "we just need a data table and a redirect table!"
      • 2015-09-15 25802, 2015

      • ruaok
        and it was never realized that way. ever.
      • 2015-09-15 25831, 2015

      • ruaok
        ok, I think that makes sense.
      • 2015-09-15 25854, 2015

      • ruaok
        Woot!
      • 2015-09-15 25804, 2015

      • ruaok
        The vote before the board passes unanimously!
      • 2015-09-15 25818, 2015

      • ruaok
        zas: expect a formal job offer letter tomorrow. :)
      • 2015-09-15 25801, 2015

      • alastairp
      • 2015-09-15 25830, 2015

      • diana_olhovik has quit
      • 2015-09-15 25816, 2015

      • ruaok
        another day...
      • 2015-09-15 25852, 2015

      • Gentlecat
        we also need to update old revision of metabrainz logo in which lines don't connect :)
      • 2015-09-15 25841, 2015

      • Bookzombie joined the channel
      • 2015-09-15 25818, 2015

      • alastairp
        any other takers on schema? if not, this is it
      • 2015-09-15 25824, 2015

      • ruaok
        go!
      • 2015-09-15 25846, 2015

      • alastairp
        ruaok: do you have a preference for me to do an upgrade script?
      • 2015-09-15 25857, 2015

      • alastairp
        or we just assume that currently running data is alpha
      • 2015-09-15 25802, 2015

      • ruaok
        skip it this early on.
      • 2015-09-15 25807, 2015

      • alastairp
        (y)
      • 2015-09-15 25836, 2015

      • Mineo
        alastairp: release_redirect.release_mbid is not unique (recording_redirect.recording_mbid is)
      • 2015-09-15 25809, 2015

      • alastairp
        I guess it should be?
      • 2015-09-15 25824, 2015

      • Mineo
        I don't know - artist_credit_redirect explicitly states there might be more than one mbid for a cluster, for recordings this doesn't seem to apply, which is confusing me a bit :)
      • 2015-09-15 25828, 2015

      • alastairp
        consider an artist credit “Queen & David Bowie"
      • 2015-09-15 25849, 2015

      • alastairp
        which is submitted as a single string
      • 2015-09-15 25858, 2015

      • alastairp
        we should map this to 2 artist mbids
      • 2015-09-15 25854, 2015

      • alastairp
        ah - I guess you’re possibly right - we could have the same recording on 2 releases with different mbids. But the fact that these are different is a musicbrainz problem, not a messybrainz problem
      • 2015-09-15 25828, 2015

      • Tempest_ has left the channel
      • 2015-09-15 25830, 2015

      • Mineo
        ok, after some more staring at it I see why the rel_redir.... is not unique
      • 2015-09-15 25844, 2015

      • alastairp
        cool, thanks.
      • 2015-09-15 25814, 2015

      • Freso
        Thunder storm! \o/
      • 2015-09-15 25846, 2015

      • chirlu`
        Freso: Under _German_ spelling rules, language names are not capitalized (unless they happen to be used as nouns). Nach den _deutschen_ Rechtschreibregeln werden Namen von Sprachen nicht großgeschrieben (es sei denn, sie werden als Substantive verwendet).
      • 2015-09-15 25821, 2015

      • alastairp
        spanish spelling rules are different enough from english to confuse me
      • 2015-09-15 25820, 2015

      • alastairp
        *capitilisation
      • 2015-09-15 25828, 2015

      • outsidecontext has quit
      • 2015-09-15 25845, 2015

      • guestABC joined the channel
      • 2015-09-15 25834, 2015

      • JesseW joined the channel
      • 2015-09-15 25844, 2015

      • jontyw joined the channel
      • 2015-09-15 25849, 2015

      • guestABC has quit
      • 2015-09-15 25849, 2015

      • wesleyc joined the channel
      • 2015-09-15 25850, 2015

      • github joined the channel
      • 2015-09-15 25850, 2015

      • github
        [listenbrainz-server] mayhem pushed 4 new commits to master: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25850, 2015

      • github
        listenbrainz-server/master 0ca7f7c Robert Kaye: Adding a data usage warning to the login screen.
      • 2015-09-15 25850, 2015

      • github
        listenbrainz-server/master 9d57af1 Robert Kaye: Adding more verbiage
      • 2015-09-15 25850, 2015

      • github
        listenbrainz-server/master a961296 Robert Kaye: Merge branch 'master' of github.com:metabrainz/listenbrainz-server...
      • 2015-09-15 25850, 2015

      • github has left the channel
      • 2015-09-15 25853, 2015

      • zas
        Fenikkusu: 1) i don't understand 2) yes, file operations are queued and executed in one thread (afair) 3) Just ask here about Picard, if you write a plugin you may create a PR @ https://github.com/musicbrainz/picard-plugins , discussion about it can take place in PR comments if needed
      • 2015-09-15 25812, 2015

      • wesleyc has quit
      • 2015-09-15 25828, 2015

      • alastairp
        ruaok: can you add messybrainz commit hook? and also disable issues for msb and lb?
      • 2015-09-15 25838, 2015

      • ruaok
        k
      • 2015-09-15 25828, 2015

      • alastairp
        RJ2 suggested running http://akrabat.com/changing-the-github-irc-hooks-… as well, which gets us notification of comments on irc too, but I don’t know if that’ll be too much noise in here
      • 2015-09-15 25841, 2015

      • alastairp
        we don’t have musicbrainz-server commits or jira comments
      • 2015-09-15 25815, 2015

      • russss
        I think issues in IRC is good, the rest of the stuff can get a little noisy
      • 2015-09-15 25856, 2015

      • alastairp
        we use jira for issues, so I guess github issue hooks are a bit of a moot point
      • 2015-09-15 25800, 2015

      • alastairp
        musicbrainz jira is *busy*
      • 2015-09-15 25816, 2015

      • Freso
        Yeah, we definitely don't want everything in Jira posted here.
      • 2015-09-15 25828, 2015

      • Freso
        That should have its own channel if anything.
      • 2015-09-15 25832, 2015

      • russss
        issues in github include PRs
      • 2015-09-15 25837, 2015

      • alastairp
        right
      • 2015-09-15 25841, 2015

      • ruaok
        alastairp: done.
      • 2015-09-15 25842, 2015

      • russss
        which are probably useful
      • 2015-09-15 25801, 2015

      • russss
        the comments I don't find terribly useful in IRC
      • 2015-09-15 25822, 2015

      • github joined the channel
      • 2015-09-15 25822, 2015

      • github
        [listenbrainz-server] gentlecat pushed 2 new commits to listens: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25822, 2015

      • github
        listenbrainz-server/listens 0d82a99 Roman Tsukanov: Need to parse other arguments in get_listens too.
      • 2015-09-15 25822, 2015

      • github
        listenbrainz-server/listens a548170 Roman Tsukanov: Add pagination to user page.
      • 2015-09-15 25822, 2015

      • github has left the channel
      • 2015-09-15 25858, 2015

      • alastairp
        russss: do you have 5 minutes to comment about your listenbrainz schema? specifically, we’re interested in knowing if we can use the messybrainz artist and release ids as-is now to get aggregate listens for a specific artist
      • 2015-09-15 25816, 2015

      • alastairp
        or is this conditional on something like the materialised views when they exist and are stable
      • 2015-09-15 25851, 2015

      • russss
        we need to do a little more work to do the aggregations
      • 2015-09-15 25818, 2015

      • russss
        basically, we need to create new tables for each grouping we want to aggregate against
      • 2015-09-15 25848, 2015

      • alastairp
        OK, we had a feeling that new tables were needed
      • 2015-09-15 25848, 2015

      • sampsyo joined the channel
      • 2015-09-15 25814, 2015

      • yeeeargh joined the channel
      • 2015-09-15 25824, 2015

      • github joined the channel
      • 2015-09-15 25824, 2015

      • github
        [listenbrainz-server] gentlecat pushed 2 new commits to listens: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25824, 2015

      • github
        listenbrainz-server/listens 622efc8 Roman Tsukanov: Remove unused LESS code.
      • 2015-09-15 25824, 2015

      • github
        listenbrainz-server/listens 76f8b73 Roman Tsukanov: Cleanup.
      • 2015-09-15 25824, 2015

      • github has left the channel
      • 2015-09-15 25835, 2015

      • Fenikkusu
        zas: 1) In order to develop my plugin, I've had make changes to the picard code base (Paticurally adding in hooks). Now that those changes are in place, I'm working on the plugin, but I want to make sure the IDE recogizes everything properly. I'm just wondering of there is a 'preferred' way of developing plugins such that you can have debug control, etc, while working on it.
      • 2015-09-15 25825, 2015

      • github joined the channel
      • 2015-09-15 25825, 2015

      • github
        [listenbrainz-server] gentlecat opened pull request #12: [WIP] Pagination on user page (master...listens) https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25825, 2015

      • github has left the channel
      • 2015-09-15 25800, 2015

      • Fenikkusu
        zas, this reminds me of another question (more python than picard I think), why is it that my hook is called with the truple (sp) rather than the individual object?
      • 2015-09-15 25818, 2015

      • adhawkins joined the channel
      • 2015-09-15 25829, 2015

      • JesseW
        BTW, the old chatlogs.musicbrainz.org logs are now archived at archive.org (or soon will be). You're welcome. :-)
      • 2015-09-15 25839, 2015

      • ruaok
        JesseW: THANK YOU!! :) :) :)
      • 2015-09-15 25816, 2015

      • JesseW
        ruaok: thank ArchiveTeam (and ArchiveBot, most specifically).
      • 2015-09-15 25829, 2015

      • ruaok nods
      • 2015-09-15 25827, 2015

      • github joined the channel
      • 2015-09-15 25827, 2015

      • github
        [listenbrainz-server] mayhem pushed 1 new commit to master: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25827, 2015

      • github
        listenbrainz-server/master c43400f Robert Kaye: Added the roadmap.
      • 2015-09-15 25827, 2015

      • github has left the channel
      • 2015-09-15 25846, 2015

      • JesseW has quit
      • 2015-09-15 25841, 2015

      • zas
        Fenikkusu: is your code visible somewhere ? i could check and comment directly on it (and others here may do too, ie. bitmap, mineo)
      • 2015-09-15 25819, 2015

      • Fenikkusu
      • 2015-09-15 25830, 2015

      • zas
        ok i'll have a look
      • 2015-09-15 25844, 2015

      • Fenikkusu
        The track-move-processor branch.
      • 2015-09-15 25817, 2015

      • zas
        yes, found it, i'll check later tonight.
      • 2015-09-15 25840, 2015

      • chirlu` has quit
      • 2015-09-15 25807, 2015

      • chirlu` joined the channel
      • 2015-09-15 25824, 2015

      • github joined the channel
      • 2015-09-15 25824, 2015

      • github
        [listenbrainz-server] mayhem pushed 1 new commit to master: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25824, 2015

      • github
        listenbrainz-server/master 12fa108 Robert Kaye: Whops, adding the missing html file
      • 2015-09-15 25824, 2015

      • github has left the channel
      • 2015-09-15 25832, 2015

      • alastairp
        :)
      • 2015-09-15 25830, 2015

      • Fenikkusu
        zas, okay, thank you. I've also gone ahead and forked the plugins repo and added the plugin file to that under the 'duplicates-processor' branch.
      • 2015-09-15 25802, 2015

      • ruaok
        RJ2, russss : am I doing this right?
      • 2015-09-15 25802, 2015

      • ruaok
      • 2015-09-15 25810, 2015

      • ruaok suspects not
      • 2015-09-15 25836, 2015

      • RJ2
        by default include_recipe "postgresql" just installs the client
      • 2015-09-15 25841, 2015

      • RJ2
        you need postgresql::server too i think
      • 2015-09-15 25853, 2015

      • ruaok
        ah
      • 2015-09-15 25807, 2015

      • ruaok
        ding. that and ::contrib and I get everything I want.
      • 2015-09-15 25818, 2015

      • ruaok
        and you also change pg_hba.conf settings this way?
      • 2015-09-15 25819, 2015

      • ruaok spots it in the docs
      • 2015-09-15 25803, 2015

      • regagain has quit
      • 2015-09-15 25859, 2015

      • regagain joined the channel
      • 2015-09-15 25800, 2015

      • diana_olhovik_ joined the channel
      • 2015-09-15 25819, 2015

      • ruaok
        everyone: I've heard from CallerNo6! He is having computer troubles and chatted with me on his mobile.
      • 2015-09-15 25847, 2015

      • github joined the channel
      • 2015-09-15 25847, 2015

      • github
        [listenbrainz-server] mayhem pushed 1 new commit to master: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25847, 2015

      • github
        listenbrainz-server/master c5af7bb Robert Kaye: Install the right postgres modules and then tweak pg_hba.conf to let everyone in.
      • 2015-09-15 25847, 2015

      • github has left the channel
      • 2015-09-15 25809, 2015

      • ruaok
        russss, RJ2: Next question. I'm working on an endpoint that will show a histogram of a users's listen history.
      • 2015-09-15 25805, 2015

      • ruaok
        we decided that it should output a list of days and the number of scobbles on those days.
      • 2015-09-15 25835, 2015

      • ruaok
        now that I am thinking about how to do that, it is dawning on me that we can't really do that with the listens table.
      • 2015-09-15 25839, 2015

      • ruaok
        we're need a new table, right?
      • 2015-09-15 25815, 2015

      • ruaok
        *we'd
      • 2015-09-15 25857, 2015

      • Freso
        JesseW: In case you read the logs too, MBChatLogger is still running, so chatlogs.mb.o will still update for a while longer. I would run ArchiveBot again once we've stopped the bot. ( http://tickets.musicbrainz.org/browse/OTHER-227 )
      • 2015-09-15 25847, 2015

      • Freso likes watching the list of people in here slowly increase
      • 2015-09-15 25806, 2015

      • Freso
        ruaok: I also heard from CallerNo6 :)
      • 2015-09-15 25827, 2015

      • ruaok
        Freso: yeah, I told him to give a sign of life. :)
      • 2015-09-15 25829, 2015

      • ruaok
        glad he did that.
      • 2015-09-15 25857, 2015

      • Freso
        Well, I had also e-mailed him asking about his whereabouts.
      • 2015-09-15 25850, 2015

      • github joined the channel
      • 2015-09-15 25850, 2015

      • github
        [listenbrainz-server] gentlecat force-pushed listens from 76f8b73 to 3af0f18: https://github.com/metabrainz/listenbrainz-server…
      • 2015-09-15 25850, 2015

      • github
        listenbrainz-server/listens 3af0f18 Roman Tsukanov: Cleanup.