#musicbrainz

/

      • griff_ joined the channel
      • 2021-05-30 15053, 2021

      • griff has quit
      • 2021-05-30 15054, 2021

      • griff_ is now known as griff
      • 2021-05-30 15008, 2021

      • griff has quit
      • 2021-05-30 15016, 2021

      • killui has quit
      • 2021-05-30 15008, 2021

      • furq_ joined the channel
      • 2021-05-30 15024, 2021

      • furq has quit
      • 2021-05-30 15041, 2021

      • furq_ is now known as furq
      • 2021-05-30 15014, 2021

      • gioele has quit
      • 2021-05-30 15039, 2021

      • JesseW
        derwin: if you can figure out a SQL query, I'll run it on my local copy
      • 2021-05-30 15032, 2021

      • derwin
        hrm, yeah, I have the capability of doing that, but I'd have to understand the schema in question, and then look up some pgsql syntax
      • 2021-05-30 15034, 2021

      • griff joined the channel
      • 2021-05-30 15028, 2021

      • JesseW
        derwin: I may take a crack at it, but I'm rusty with the MB schema, still
      • 2021-05-30 15036, 2021

      • JesseW
        (or, once again)
      • 2021-05-30 15045, 2021

      • JesseW
        knew it pretty well a few years ago
      • 2021-05-30 15014, 2021

      • derwin
        if you paste the schema for the relevant tables, we could tag-team it a bit
      • 2021-05-30 15047, 2021

      • JesseW
        derwin: sure, coming right up
      • 2021-05-30 15041, 2021

      • JesseW
        https://minimalist.etherpad.com/p/j_d_mb_scratch -- this way we can actually work *together* on this
      • 2021-05-30 15035, 2021

      • JesseW
        Apparently there are at least 5 releases with 227 different release_country entries.
      • 2021-05-30 15056, 2021

      • JesseW
        derwin: Here's an example of an edit where someone added 227 (I think, all the possible countries): https://musicbrainz.org/edit/77644400
      • 2021-05-30 15010, 2021

      • JesseW
        This was on Feb 26, 2021
      • 2021-05-30 15033, 2021

      • JesseW
        This is one of the atisket edits
      • 2021-05-30 15001, 2021

      • JesseW
        OK, but you wanted ones with multiple release *dates*
      • 2021-05-30 15008, 2021

      • JesseW
        let me see about getting that
      • 2021-05-30 15055, 2021

      • kepstin
        hmm, releases which happened on different dates in different regions used to be fairly common, but in the modern internet and social media age i guess that's getting pretty rare
      • 2021-05-30 15023, 2021

      • JesseW
        derwin: OK, got the results. Yes, there are quite a few.
      • 2021-05-30 15005, 2021

      • JesseW
        Here's the one with the most different years: https://musicbrainz.org/release/9bb92953-39f8-45b…
      • 2021-05-30 15046, 2021

      • derwin
        awesome, thank you, sorry, busy irl :)
      • 2021-05-30 15006, 2021

      • JesseW
        no worries
      • 2021-05-30 15014, 2021

      • derwin
        wow, that's crazy!!!
      • 2021-05-30 15019, 2021

      • JesseW
        the suggestion to make a pastebin was a good idea
      • 2021-05-30 15004, 2021

      • derwin
        so.. it was added at 2020-08-21, but has grouped release dates from 2003, 2004 (2), 2005 (4), 2011 (2), 2012 (4), etc.
      • 2021-05-30 15028, 2021

      • derwin
        so the API returned those different dates, all on one date.
      • 2021-05-30 15039, 2021

      • derwin
        Kosovo
      • 2021-05-30 15039, 2021

      • derwin
        2020-04-21
      • 2021-05-30 15039, 2021

      • derwin
        Myanmar
      • 2021-05-30 15040, 2021

      • derwin
        2020-04-21
      • 2021-05-30 15043, 2021

      • derwin
        bleh, sorry paste
      • 2021-05-30 15059, 2021

      • derwin
        and then no release date for some countries?!?!?!
      • 2021-05-30 15016, 2021

      • JesseW
        that's indeed very werid
      • 2021-05-30 15015, 2021

      • JesseW
        There are only 32 releases with 3 or more different years.
      • 2021-05-30 15044, 2021

      • kepstin
        does anyone know if there is a way to find out when a particular release got added to spotify or itunes?
      • 2021-05-30 15044, 2021

      • kepstin has a release where his best guess for the digital streaming availability was sometime in 2018, but all the big online streaming sites list the original cd release date of 2013 :/
      • 2021-05-30 15033, 2021

      • aphelion has quit
      • 2021-05-30 15046, 2021

      • IroncladCorona has quit
      • 2021-05-30 15030, 2021

      • Hobbyboy has quit
      • 2021-05-30 15042, 2021

      • Hobbyboy joined the channel
      • 2021-05-30 15004, 2021

      • griff has quit
      • 2021-05-30 15011, 2021

      • Guest83 joined the channel
      • 2021-05-30 15049, 2021

      • Guest83 has quit
      • 2021-05-30 15006, 2021

      • CptViraj joined the channel
      • 2021-05-30 15059, 2021

      • griff joined the channel
      • 2021-05-30 15000, 2021

      • thomasross has quit
      • 2021-05-30 15030, 2021

      • griff has quit
      • 2021-05-30 15023, 2021

      • tigerman325 joined the channel
      • 2021-05-30 15001, 2021

      • tigerman325 has quit
      • 2021-05-30 15012, 2021

      • tigerman325 joined the channel
      • 2021-05-30 15033, 2021

      • tigerman325
        Hi! Not sure if this will work, but I see y'all are discussing some digital releases that I added with different dates, etc. There was a time when I was really trying to pay attention to the dates that Apple Music, iTunes, Deezer & Spotify all first were available in certain countries. I have created a Word file with all the dates first available.
      • 2021-05-30 15034, 2021

      • tigerman325
        I did this so that releases from 2004 that were on iTunes wouldn't show up in say Suriname as the same year. That Dave Brubeck release is a prime example of this. All those dates are earliest dates of the 3 linked sites for each country. It's very time consuming as you can imagine.
      • 2021-05-30 15009, 2021

      • tigerman325
        So, no. The dates are not from the API. The earliest date is from the API. All the dates after that are from first availability date of 1 of the major 3 sites. This still isn't 100% as it the releases may have been on services other than iTunes, Spotify or Deezer. This is evident by Jaxsta showing many of these as released in countries that
      • 2021-05-30 15010, 2021

      • tigerman325
        a-tisket is saying the 3 sites don't have the release.
      • 2021-05-30 15055, 2021

      • tigerman325
        Also, I don't 100% rely on the API as many dates are wrong there as well. I check Soundexchange against the barcode to see when a barcode was first made avaialable.
      • 2021-05-30 15011, 2021

      • navap
        Freso Will there be a separate link added to chatlogs.mb to make it easy to find the previous freenode chatlogs? i.e. https://chatlogs.metabrainz.org/brainzbot/musicbr…
      • 2021-05-30 15014, 2021

      • calcmandan_ joined the channel
      • 2021-05-30 15022, 2021

      • calcmandan_ is now known as calcmandan
      • 2021-05-30 15024, 2021

      • calcmandan
        greetings
      • 2021-05-30 15039, 2021

      • tigerman325
        Oh, the release dates not being on some countries is due to the fact that Deezer's API returned those counties as available, but those countries aren't listed on Deezer's availability list. So, it was released in those countries by Deezer according to their API, even though their website (https://developers.deezer.com/guidelines/countries) says
      • 2021-05-30 15040, 2021

      • tigerman325
        Deezer is not there.
      • 2021-05-30 15007, 2021

      • navap has quit
      • 2021-05-30 15059, 2021

      • texke has quit
      • 2021-05-30 15021, 2021

      • griff joined the channel
      • 2021-05-30 15051, 2021

      • tigerman325 has quit
      • 2021-05-30 15002, 2021

      • tigerman325 joined the channel
      • 2021-05-30 15042, 2021

      • ZaphodBeeblebrox joined the channel
      • 2021-05-30 15043, 2021

      • ZaphodBeeblebrox has quit
      • 2021-05-30 15043, 2021

      • ZaphodBeeblebrox joined the channel
      • 2021-05-30 15022, 2021

      • CatQuest has quit
      • 2021-05-30 15034, 2021

      • Toasty joined the channel
      • 2021-05-30 15046, 2021

      • CptViraj has quit
      • 2021-05-30 15042, 2021

      • tigerman325 has quit
      • 2021-05-30 15031, 2021

      • derwin
        19:18 < JesseW> There are only 32 releases with 3 or more different years.
      • 2021-05-30 15032, 2021

      • derwin
        !!!
      • 2021-05-30 15038, 2021

      • derwin
        that tigerman325 comment is :mind-blown:
      • 2021-05-30 15049, 2021

      • redbluescreen[m] joined the channel
      • 2021-05-30 15050, 2021

      • derwin
        "api is wrong, soundexchange says something different"
      • 2021-05-30 15028, 2021

      • derwin
        finalsummer: also, definitely perspective on "the API says" !
      • 2021-05-30 15024, 2021

      • ZaphodBeeblebrox
        https://beta.musicbrainz.org/edit/79970417 <-- as many eyes as possible please!
      • 2021-05-30 15034, 2021

      • ZaphodBeeblebrox is now known as CatQuest
      • 2021-05-30 15021, 2021

      • farn joined the channel
      • 2021-05-30 15051, 2021

      • farn has quit
      • 2021-05-30 15005, 2021

      • farn joined the channel
      • 2021-05-30 15019, 2021

      • farn has quit
      • 2021-05-30 15031, 2021

      • farn joined the channel
      • 2021-05-30 15051, 2021

      • killui joined the channel
      • 2021-05-30 15026, 2021

      • aphelion joined the channel
      • 2021-05-30 15041, 2021

      • farn has quit
      • 2021-05-30 15055, 2021

      • farn joined the channel
      • 2021-05-30 15016, 2021

      • farn has quit
      • 2021-05-30 15026, 2021

      • farn joined the channel
      • 2021-05-30 15002, 2021

      • aphelion has quit
      • 2021-05-30 15002, 2021

      • aphelion joined the channel
      • 2021-05-30 15005, 2021

      • MajorLurker joined the channel
      • 2021-05-30 15049, 2021

      • MajorLurker has quit
      • 2021-05-30 15007, 2021

      • MajorLurker joined the channel
      • 2021-05-30 15005, 2021

      • MajorLurker has quit
      • 2021-05-30 15030, 2021

      • MajorLurker joined the channel
      • 2021-05-30 15033, 2021

      • Major_Lurker joined the channel
      • 2021-05-30 15046, 2021

      • MajorLurker has quit
      • 2021-05-30 15055, 2021

      • MajorLurker joined the channel
      • 2021-05-30 15004, 2021

      • Major_Lurker has quit
      • 2021-05-30 15015, 2021

      • janl joined the channel
      • 2021-05-30 15053, 2021

      • janl has quit
      • 2021-05-30 15038, 2021

      • janl joined the channel
      • 2021-05-30 15037, 2021

      • farn has quit
      • 2021-05-30 15047, 2021

      • farn joined the channel
      • 2021-05-30 15016, 2021

      • janl has quit
      • 2021-05-30 15030, 2021

      • ev
        can somebody clarify something about atisket?
      • 2021-05-30 15057, 2021

      • ev
        as far as I understand, the big list is the current availablity. is that correct? or is it the availability on the date given?
      • 2021-05-30 15042, 2021

      • IroncladCorona joined the channel
      • 2021-05-30 15047, 2021

      • janl joined the channel
      • 2021-05-30 15053, 2021

      • janl46 joined the channel
      • 2021-05-30 15055, 2021

      • janl46 has quit
      • 2021-05-30 15035, 2021

      • elomatreb[m]
        ev: it reports the availability at the time the requests are made to the store APIs
      • 2021-05-30 15003, 2021

      • ev
        ok, so it's unrelated to the actual release date given. thanks.
      • 2021-05-30 15019, 2021

      • janl has quit
      • 2021-05-30 15027, 2021

      • CptViraj joined the channel
      • 2021-05-30 15048, 2021

      • thomasross joined the channel
      • 2021-05-30 15019, 2021

      • Erin has quit
      • 2021-05-30 15041, 2021

      • Erin joined the channel
      • 2021-05-30 15019, 2021

      • thomasross has quit
      • 2021-05-30 15036, 2021

      • otisolsen70 joined the channel
      • 2021-05-30 15003, 2021

      • ats_ joined the channel
      • 2021-05-30 15001, 2021

      • otisolsen70 has quit
      • 2021-05-30 15008, 2021

      • ats has quit
      • 2021-05-30 15056, 2021

      • otisolsen70 joined the channel
      • 2021-05-30 15014, 2021

      • ats_ is now known as ats
      • 2021-05-30 15057, 2021

      • CptViraj has quit
      • 2021-05-30 15033, 2021

      • ats has quit
      • 2021-05-30 15028, 2021

      • ats joined the channel
      • 2021-05-30 15005, 2021

      • gchound joined the channel
      • 2021-05-30 15004, 2021

      • theracermaster joined the channel
      • 2021-05-30 15056, 2021

      • gchound has quit
      • 2021-05-30 15049, 2021

      • griff has quit
      • 2021-05-30 15004, 2021

      • gchound joined the channel
      • 2021-05-30 15030, 2021

      • gchound has quit
      • 2021-05-30 15018, 2021

      • otisolsen70 has quit
      • 2021-05-30 15041, 2021

      • tigerman325 joined the channel
      • 2021-05-30 15052, 2021

      • tigerman325 has quit
      • 2021-05-30 15003, 2021

      • tigerman325 joined the channel
      • 2021-05-30 15020, 2021

      • tigerman325