#metabrainz

/

      • CatQuest
        reosarevok: come over here and we can have a lan party when the gameLan is Game(lan)Over
      • 2019-10-22 29542, 2019

      • CatQuest
        :D
      • 2019-10-22 29500, 2019

      • CatQuest regrets nothing
      • 2019-10-22 29533, 2019

      • pristine__
        CatQuest: hey, all this while I realised that you have so many listens in LB
      • 2019-10-22 29538, 2019

      • pristine__
        <3
      • 2019-10-22 29558, 2019

      • CatQuest
        :D
      • 2019-10-22 29559, 2019

      • CatQuest
        :)
      • 2019-10-22 29505, 2019

      • pristine__
        alastairp: nice. I didn't think in that dir. You mean bad strings given to queries leading to crashes?
      • 2019-10-22 29504, 2019

      • Mr_Monkey
        ruaok: Maybe later this afternoon
      • 2019-10-22 29529, 2019

      • elomatreb[m] has quit
      • 2019-10-22 29530, 2019

      • sagar-kohli[m] has quit
      • 2019-10-22 29530, 2019

      • Nemo157 has quit
      • 2019-10-22 29530, 2019

      • ccheckk[m] has quit
      • 2019-10-22 29530, 2019

      • samj1912[m] has quit
      • 2019-10-22 29530, 2019

      • MagnusSvensson[m has quit
      • 2019-10-22 29530, 2019

      • jee[m] has quit
      • 2019-10-22 29530, 2019

      • dns[m] has quit
      • 2019-10-22 29530, 2019

      • chaban has quit
      • 2019-10-22 29530, 2019

      • reg[m] has quit
      • 2019-10-22 29550, 2019

      • BrainzGit
        [listenbrainz-labs] vansika opened pull request #60 (master…mbid-msid-mapping): Use mbid->msid mapping to get mbid for every listen https://github.com/metabrainz/listenbrainz-labs/p…
      • 2019-10-22 29509, 2019

      • pristine__
        ruaok: ^
      • 2019-10-22 29528, 2019

      • ruaok
        wooo! exciting!
      • 2019-10-22 29555, 2019

      • ruaok
      • 2019-10-22 29557, 2019

      • pristine__
        ruaok: I will push changes file by file so that it is not difficult for the reviewers.
      • 2019-10-22 29511, 2019

      • pristine__
        Right now create_dataframes has been altered
      • 2019-10-22 29514, 2019

      • ruaok
        do you want new JSON base data sets?
      • 2019-10-22 29524, 2019

      • ruaok
        I have them ready, I think.
      • 2019-10-22 29555, 2019

      • pristine__
        I have the data in HDFS but you can put them on leader. I will host on williams soon
      • 2019-10-22 29517, 2019

      • ruaok
        I'm more thinking about having an up to date PR that uses JSON going forward...
      • 2019-10-22 29551, 2019

      • bitmap
        yvanzo: I found the issue with the Tags string; my local statistics_event table was incomplete so it wasn't finding the entry for DB:statistics.statistic_event/title:2007-10-17
      • 2019-10-22 29540, 2019

      • bitmap
        and normally I revert any DB deletions from the commit since I know I'm missing them
      • 2019-10-22 29537, 2019

      • bitmap
        so I ended up keeping the existing entry for DB + stats.js it removed, and also keeping the new one for just stats.js it added
      • 2019-10-22 29552, 2019

      • bitmap
        my fault anyway, I'll fix
      • 2019-10-22 29539, 2019

      • yvanzo
        thank you!
      • 2019-10-22 29505, 2019

      • ruaok
        pristine__: the .bz2 files in your dir have been updated to be the JSON version.
      • 2019-10-22 29507, 2019

      • ruaok
        +s
      • 2019-10-22 29551, 2019

      • alastairp
        hello
      • 2019-10-22 29559, 2019

      • ruaok waves
      • 2019-10-22 29503, 2019

      • ruaok
        long time no see!
      • 2019-10-22 29540, 2019

      • alastairp
        pristine__: not just crashes, there's a risk of malicious users being able to delete data or steal private data
      • 2019-10-22 29524, 2019

      • alastairp
        SQL client libraries have been aware of this for 20 years, I have no idea why spark decided that it didn't apply to them
      • 2019-10-22 29534, 2019

      • ruaok
        possibly because spark is not meant to be used in a live environment?
      • 2019-10-22 29545, 2019

      • ruaok
        not that I am defending that argument...
      • 2019-10-22 29553, 2019

      • ruaok
      • 2019-10-22 29530, 2019

      • ruaok
        the mood_happy is rather quite different for that same radiohead track. :(
      • 2019-10-22 29555, 2019

      • alastairp
        the possible argument is that in java there's a defined way of doing sql query arguments which happens outside of the interface to the database
      • 2019-10-22 29509, 2019

      • alastairp
        (use a query builder, get a string, pass that to the query method)
      • 2019-10-22 29524, 2019

      • alastairp
        but I'm not convinced. no one on the internet sees this as a bad thing
      • 2019-10-22 29547, 2019

      • alastairp
        ruaok: right, but this could just as easily be a bad duplicate submission
      • 2019-10-22 29500, 2019

      • ruaok
        ah, right.
      • 2019-10-22 29532, 2019

      • ruaok
        I'll filter that out anyway. I'll have to listen to the track to see which is a better fit...
      • 2019-10-22 29522, 2019

      • alastairp
        we have enough data with this index to actually filter out bad submissions now
      • 2019-10-22 29546, 2019

      • ruaok
        how do I go about choosing the right version of that duplicate pair?
      • 2019-10-22 29557, 2019

      • alastairp
        simple answer for now: you don't
      • 2019-10-22 29502, 2019

      • alastairp
        because we don't know which one is correct
      • 2019-10-22 29522, 2019

      • ruaok
        so the filtering needs to be done on the AB level and not ANNOY?
      • 2019-10-22 29534, 2019

      • ruaok
        annoy informs the filtration process?
      • 2019-10-22 29543, 2019

      • alastairp
        if you have 3 or more submissions for an MBID
      • 2019-10-22 29505, 2019

      • pristine__
        alastairp: oooo... I want to read more about it. Do share any resource if you have
      • 2019-10-22 29520, 2019

      • alastairp
        you can see if they're all close to each other, or if there is a cluster all the same, with some others with a much larger distance away
      • 2019-10-22 29527, 2019

      • weirditude has quit
      • 2019-10-22 29539, 2019

      • alastairp
      • 2019-10-22 29558, 2019

      • pristine__
        ruaok: sounds good. I will host that on williams and open a PR so that users and get the dumps from FTP and upload to hdfs
      • 2019-10-22 29513, 2019

      • ruaok
        pristine__: and of course: https://xkcd.com/327/
      • 2019-10-22 29520, 2019

      • pristine__
        alastairp: phew..... Wikipedia is never a resource I look up to....
      • 2019-10-22 29527, 2019

      • pristine__
        Isn't it boring kinda?
      • 2019-10-22 29513, 2019

      • ruaok
        remember to add the needed license files and such. I should add that to the mapping process.
      • 2019-10-22 29525, 2019

      • pristine__
        ruaok: Lord, I cannot stop laughing
      • 2019-10-22 29533, 2019

      • pristine__
        Umm.... Did you see the test dump?
      • 2019-10-22 29544, 2019

      • pristine__
        I included the copy license file there
      • 2019-10-22 29554, 2019

      • pristine__
        The same, no?
      • 2019-10-22 29558, 2019

      • ruaok
        I haven't. should I download it?
      • 2019-10-22 29502, 2019

      • ruaok
        yea, should be.
      • 2019-10-22 29509, 2019

      • pristine__
        You can... It is 1MB
      • 2019-10-22 29534, 2019

      • pristine__
        The license in Listenbrainz full dump
      • 2019-10-22 29539, 2019

      • pristine__
        Took it from there.
      • 2019-10-22 29550, 2019

      • ruaok downloads
      • 2019-10-22 29532, 2019

      • ruaok
        pristine__: the TIMESTAMP file has a second accurate timestamp -- is that what the LB files have?
      • 2019-10-22 29548, 2019

      • ruaok
        the live data feed files from MB have subsecond accuracy and timezone.
      • 2019-10-22 29550, 2019

      • ruaok
        2011-05-17 17:00:15.816041+00
      • 2019-10-22 29551, 2019

      • ruaok
        vs
      • 2019-10-22 29557, 2019

      • ruaok
        2019-10-15 10:37:48
      • 2019-10-22 29518, 2019

      • pristine__
        Shit. Sorry :(
      • 2019-10-22 29543, 2019

      • ruaok
        no need to be sorry. :)
      • 2019-10-22 29506, 2019

      • pristine__
        😞
      • 2019-10-22 29529, 2019

      • pristine__
        I like it when someone says it is a very good start
      • 2019-10-22 29544, 2019

      • pristine__
        ruaok: alastairp <3
      • 2019-10-22 29544, 2019

      • amCap1712
        hi all
      • 2019-10-22 29559, 2019

      • amCap1712
        how long does it take the my listens page to update?
      • 2019-10-22 29500, 2019

      • amCap1712
        i fixed the json error i was facing yesterday
      • 2019-10-22 29519, 2019

      • amCap1712
        it was due to incorrect content type header
      • 2019-10-22 29506, 2019

      • yvanzo
        Matthew_: your workaround to the lack of support for pg_amqp looks good, but how are you doing without musicbrainz_collate extension?
      • 2019-10-22 29519, 2019

      • amCap1712
        pristine__: iliekcomputers ^^
      • 2019-10-22 29543, 2019

      • weirditude joined the channel
      • 2019-10-22 29545, 2019

      • amCap1712
        it got updated now
      • 2019-10-22 29549, 2019

      • amCap1712
        and it works
      • 2019-10-22 29527, 2019

      • amCap1712
        the vlc plugin is now working. is anyone interested in testing it?
      • 2019-10-22 29557, 2019

      • amCap1712
        ruaok, rdswift , CatQuest, Pac23 , alastairp : ^
      • 2019-10-22 29525, 2019

      • ruaok
        how do we test it? which platforms?
      • 2019-10-22 29548, 2019

      • weirditude has quit
      • 2019-10-22 29502, 2019

      • weirditude joined the channel
      • 2019-10-22 29513, 2019

      • weirditude has quit
      • 2019-10-22 29545, 2019

      • amCap1712
        i think it should work on all desktop platforms
      • 2019-10-22 29519, 2019

      • amCap1712
        for now, i'll build and share the executables
      • 2019-10-22 29551, 2019

      • amCap1712
        once the plugin is tested properly, we can submit to vlc for inclusion in central repo and future builds
      • 2019-10-22 29503, 2019

      • ruaok
        great! do you have a mac build yet?
      • 2019-10-22 29529, 2019

      • weirditude joined the channel
      • 2019-10-22 29501, 2019

      • chaban joined the channel
      • 2019-10-22 29559, 2019

      • amCap1712
        at the moment i have linux builds
      • 2019-10-22 29519, 2019

      • amCap1712
        i need to install the windows and mac toolchains to build for those os
      • 2019-10-22 29530, 2019

      • amCap1712
        once i do that i'll let you know
      • 2019-10-22 29512, 2019

      • CatQuest
        hm. I have sadly an old mac though
      • 2019-10-22 29524, 2019

      • CatQuest
        mac os 10.7.11
      • 2019-10-22 29547, 2019

      • CatQuest
        but I also have windows 7 so i guess i can test it there too
      • 2019-10-22 29519, 2019

      • CatQuest
        🤔 did i uninstall vlc on android? it was kidna dumb so i think i did , but i can see about re-installing it and trying it there
      • 2019-10-22 29524, 2019

      • weirditude has quit
      • 2019-10-22 29552, 2019

      • amCap1712
        i am not sure about vlc-android CatQuest
      • 2019-10-22 29509, 2019

      • amCap1712
        thats why i wrote desktop platforms above
      • 2019-10-22 29511, 2019

      • CatQuest
        hm
      • 2019-10-22 29533, 2019

      • amCap1712
        as far as i know vlc android is the only exception
      • 2019-10-22 29550, 2019

      • CatQuest
        yea i think that makes sence, vlc android is kidna crap :D
      • 2019-10-22 29551, 2019

      • weirditude joined the channel
      • 2019-10-22 29539, 2019

      • weirditude has quit
      • 2019-10-22 29552, 2019

      • CatQuest
        is it me or is something odd bout the formatting on this page https://beta.musicbrainz.org/release/35372aaa-0f9…
      • 2019-10-22 29507, 2019

      • CatQuest
        cd track lsit ends oddly
      • 2019-10-22 29528, 2019

      • reosarevok
        Seems normal to me?
      • 2019-10-22 29533, 2019

      • CatQuest
        hmm
      • 2019-10-22 29547, 2019

      • CatQuest
        should there be a singleborder at the end?
      • 2019-10-22 29512, 2019

      • reosarevok
        That's how it is elsewhere too :)
      • 2019-10-22 29535, 2019

      • reosarevok
        (just that it might look different for one-track releases because you're used to a lot more rows there?)
      • 2019-10-22 29544, 2019

      • CatQuest
        hm
      • 2019-10-22 29559, 2019

      • CatQuest
        several row other eleases end with a last border i thoguh..
      • 2019-10-22 29503, 2019

      • CatQuest
        let me loo at osme releases
      • 2019-10-22 29516, 2019

      • CatQuest
      • 2019-10-22 29534, 2019

      • chhavi_ joined the channel
      • 2019-10-22 29536, 2019

      • reosarevok
        But this has a border too?
      • 2019-10-22 29506, 2019

      • CatQuest
        not at the bottom!
      • 2019-10-22 29532, 2019

      • CatQuest
        not for me atleast
      • 2019-10-22 29535, 2019

      • CatQuest
        hm
      • 2019-10-22 29556, 2019

      • reosarevok
        ... it does for me?
      • 2019-10-22 29557, 2019

      • reosarevok is confused
      • 2019-10-22 29506, 2019

      • CatQuest
        huh i refreshed and it's still not there
      • 2019-10-22 29520, 2019

      • CatQuest
        weird
      • 2019-10-22 29552, 2019

      • weirditude joined the channel
      • 2019-10-22 29522, 2019

      • reosarevok
        CatQuest: screenshot maybe?
      • 2019-10-22 29545, 2019

      • CatQuest
        hmm yea maybe. after dinner and stuff :D
      • 2019-10-22 29551, 2019

      • weirditude has quit
      • 2019-10-22 29507, 2019

      • yvanzo
        Fwd jonatoni@telegram: Chrome extension using MB API coded at a hacking event: https://twitter.com/codekiwicom/status/1184801276…
      • 2019-10-22 29555, 2019

      • ruaok
        <3
      • 2019-10-22 29555, 2019

      • weirditude joined the channel