#metabrainz

/

      • shawnsblog joined the channel
      • 2023-05-26 14655, 2023

      • rdswift
        You beat me to it. I was just going to mention those links. :-) I think that's about all we have so far.
      • 2023-05-26 14611, 2023

      • shawnsblog
        Good afternoon all. Is this the channel where Development questions are OK?
      • 2023-05-26 14649, 2023

      • CatQuest
        yes!
      • 2023-05-26 14612, 2023

      • bitmap
        yvanzo: for aretha, we should stop any cron jobs that sync to ftp first...which is a lot of cron jobs
      • 2023-05-26 14651, 2023

      • bitmap
        just judging by all the volumes on the sshd-musicbrainz-fullexport container, I think we'll need a doc listing all these services and how to stop them/check if they're active
      • 2023-05-26 14643, 2023

      • yvanzo
        bitmap: as in PR #17?
      • 2023-05-26 14614, 2023

      • shawnsblog
        When we run a query, do we need to specify explicit requirements for returns? For example, if I want to search for a release, with a country:us do I need to do NOT country:wx?
      • 2023-05-26 14636, 2023

      • bitmap
        yeah, ideally with more details on which containers are implicated and how to stop cron in each of them and check if there are active processes syncing data
      • 2023-05-26 14644, 2023

      • bitmap
        re: the pink/floyd database switchover, there are some docs at https://github.com/metabrainz/syswiki/blob/master…
      • 2023-05-26 14659, 2023

      • bitmap
        last few times we did this we took all projects down on the gateway, so will require some coordination
      • 2023-05-26 14603, 2023

      • petitminion_ has quit
      • 2023-05-26 14611, 2023

      • yvanzo
        Thanks, I could not find those back, but it would still be better to have you around just in case.
      • 2023-05-26 14606, 2023

      • yvanzo
        rdswift: The idea of having a wiki page for each project is to include them in a central page for translators.
      • 2023-05-26 14611, 2023

      • bitmap
        I'll definitely be around & can execute the steps if needed
      • 2023-05-26 14638, 2023

      • yvanzo
        rdswift: like we have a central page for editor resources
      • 2023-05-26 14616, 2023

      • yvanzo
        bitmap: Monday? (we have no MB release)
      • 2023-05-26 14611, 2023

      • bitmap
        monday works for me, maybe we can do it before the meeting. zas?
      • 2023-05-26 14634, 2023

      • yvanzo
        shawnsblog: Can you give an example?
      • 2023-05-26 14644, 2023

      • rdswift
        yvanzo, I think I understand. As I get some time, I'll start drafting something to include for the Picard User Guide that you can work with as a possible starting point.
      • 2023-05-26 14654, 2023

      • yvanzo
      • 2023-05-26 14638, 2023

      • zas
        bitmap: ok
      • 2023-05-26 14607, 2023

      • rdswift
        Perfect! I'll try to follow the same style for consistency.
      • 2023-05-26 14609, 2023

      • yvanzo
        bitmap, zas: ok too
      • 2023-05-26 14630, 2023

      • yvanzo
        rdswift: thanks, then likely under https://wiki.musicbrainz.org/MusicBrainz_Picard/I…
      • 2023-05-26 14606, 2023

      • rdswift
        Will do. Thanks.
      • 2023-05-26 14605, 2023

      • yvanzo
        I will try to split https://wiki.musicbrainz.org/Internationalization into separate pages and turn it into a central page.
      • 2023-05-26 14637, 2023

      • shawnsblog
        yvanzo I can't find my example now, lol... I was running into an issue where querying a release, it was returning WX, along with US records....
      • 2023-05-26 14659, 2023

      • shawnsblog
        I'm not going to disappear though, cause I know I'll run around it.
      • 2023-05-26 14615, 2023

      • reosarevok
        shawnsblog: in theory you shouldn't need to, so yeah, if you find the example do let us know :)
      • 2023-05-26 14626, 2023

      • shawnsblog
        So, I will ask, is there a good example of more complicated examples for indepth queries? I'm building URIs like... "https://musicbrainz.org/ws/2/release/?query=format:%22CD%22%20AND%20release:\"Before+These+Crowded+Streets\"%20AND%20artist:\"Dave+Matthews+Band\"%20AND%20country:US%20AND%20status:%22official%22&fmt=json&limit=1" and it seems
      • 2023-05-26 14626, 2023

      • shawnsblog
        between the URL encoding and the character escaping I have to be doing something wrong here, lol.
      • 2023-05-26 14641, 2023

      • shawnsblog
        Sorry if URLs in the chat are discouraged...
      • 2023-05-26 14616, 2023

      • yvanzo
        shawnsblog: You can test the syntax in the advanced search form too: https://musicbrainz.org/search?query=format:%22CD…
      • 2023-05-26 14643, 2023

      • yvanzo
        The problem seems to be with wrongly escaped double quotes.
      • 2023-05-26 14602, 2023

      • yvanzo
        And also I was not searching for artist instead of release; All fixed: https://musicbrainz.org/search?query=format%3A%22…
      • 2023-05-26 14621, 2023

      • Sophist_UK joined the channel
      • 2023-05-26 14640, 2023

      • yvanzo
        shawnsblog: To answer your initial question: No XW doesn't include US.
      • 2023-05-26 14611, 2023

      • Sophist-UK has quit
      • 2023-05-26 14628, 2023

      • shawnsblog
        OK....So, I have to be fair, I was using ChatGPT for some syntax help...which honestly seems to butcher some things.
      • 2023-05-26 14600, 2023

      • shawnsblog
        But it seems like should stick with urlEncode....vs escaping
      • 2023-05-26 14613, 2023

      • dseomn has quit
      • 2023-05-26 14613, 2023

      • yvanzo
        shawnsblog: Note also that XW releases are generally available from the US too.
      • 2023-05-26 14636, 2023

      • yvanzo
        XW is used for online releases mostly.
      • 2023-05-26 14622, 2023

      • yvanzo
        And I don’t understand what are "explicit requirements for returns".
      • 2023-05-26 14600, 2023

      • bitmap
        zas: I'd like to try out some changes to our postgres architecture to make switchover easier using haproxy. is it alright if I start some additional pg/pgbouncer/haproxy containers on a couple hosts to experiment? they should use almost no resources
      • 2023-05-26 14625, 2023

      • zas
        yup, no pb
      • 2023-05-26 14641, 2023

      • dseomn joined the channel
      • 2023-05-26 14654, 2023

      • bitmap
        thx
      • 2023-05-26 14645, 2023

      • pprkut has quit
      • 2023-05-26 14641, 2023

      • pprkut joined the channel
      • 2023-05-26 14620, 2023

      • shawnsblog
        yvanzo I was meaning, that if I query for US, it shouldn't return CA....(Canada)
      • 2023-05-26 14651, 2023

      • shawnsblog
        I've queried for format:"CD" and it's returned Digital Media as well before.
      • 2023-05-26 14650, 2023

      • yvanzo
        Some releases have several media in several formats.
      • 2023-05-26 14607, 2023

      • yvanzo
        IIUC you want CD only.
      • 2023-05-26 14612, 2023

      • reosarevok
        shawnsblog: what is your current URL that returns CA?
      • 2023-05-26 14633, 2023

      • yvanzo
      • 2023-05-26 14609, 2023

      • reosarevok
        Well, that is correct, that *is* a US release - it's just *also* a Canadian release, like many North American releases
      • 2023-05-26 14629, 2023

      • shawnsblog
        So, releases aren't isolated to market? (I assumed a release was correlated with an ISBN/registration of some type)
      • 2023-05-26 14631, 2023

      • yvanzo
      • 2023-05-26 14620, 2023

      • yvanzo
        But I agree that US releases can also be available in other countries.
      • 2023-05-26 14615, 2023

      • yvanzo
        Should probably use ZZ instead fo Z to exclude South Africa too.
      • 2023-05-26 14650, 2023

      • outsidecontext
        yvanzo, rdswift: Picard and docs should be separate projects. As picard-docs consists of many separate translation components it would be otherwise hard to manage
      • 2023-05-26 14654, 2023

      • outsidecontext is on the road and AFK again
      • 2023-05-26 14614, 2023

      • rdswift
        yvanzo, outsidecontext: Here is the DRAFT of the wiki page as a starting point. Feel free to edit as appropriate.
      • 2023-05-26 14634, 2023

      • rdswift
      • 2023-05-26 14650, 2023

      • yvanzo
        Thanks. Is there any specific syntax? See for example https://wiki.musicbrainz.org/Server_International…
      • 2023-05-26 14611, 2023

      • shawnsblog has quit
      • 2023-05-26 14616, 2023

      • rdswift
        The only thing that comes to mind is that it is important to retain (and not translate) the Sphinx roles and directives in the Picard User Guide. I guess I should include something about that.
      • 2023-05-26 14609, 2023

      • yvanzo
        bitmap, reosarevok: I’d like to replace our Jira "Internationlization" component with a label, because it allows to search cross-project. And also this isn’t really an isolated component.
      • 2023-05-26 14611, 2023

      • yvanzo
        215 tickets ^ won't do that today :D
      • 2023-05-26 14645, 2023

      • yvanzo
        (even using batch because it's flooding activity dashboard)
      • 2023-05-26 14659, 2023

      • Sophist_UK has quit
      • 2023-05-26 14620, 2023

      • CatQuest
        iirc, there is a setting inside batch that lets you select to *not* mail people about *these changes*
      • 2023-05-26 14653, 2023

      • yvanzo
        yes it still shows up in activity dashboard
      • 2023-05-26 14612, 2023

      • yvanzo
        will wait for a more quiet period of time
      • 2023-05-26 14606, 2023

      • yvanzo
        and for others to answer first
      • 2023-05-26 14632, 2023

      • bitmap
        yvanzo: fine with me 👍
      • 2023-05-26 14601, 2023

      • Maxr1998 has quit
      • 2023-05-26 14616, 2023

      • Maxr1998 joined the channel
      • 2023-05-26 14633, 2023

      • shawnsblog joined the channel
      • 2023-05-26 14601, 2023

      • v6lur joined the channel
      • 2023-05-26 14648, 2023

      • shawnsblog has quit
      • 2023-05-26 14650, 2023

      • yvanzo
        Ok, not as much activity now, doing the change.
      • 2023-05-26 14657, 2023

      • v6lur has quit
      • 2023-05-26 14658, 2023

      • shawnsblog joined the channel
      • 2023-05-26 14620, 2023

      • shawnsblog has quit
      • 2023-05-26 14655, 2023

      • shawnsblog joined the channel
      • 2023-05-26 14605, 2023

      • shawnsblog
        OK, so I'm querying for an album, and want a single result, HOWEVER, the first result lacks Artwork, and has a disabiguation. I tried adding AND comment:"" (and also comment:" ") but it's still returning that result. Additionally I tried NOT comment but was't able to get what I was looking for until I tried NOT comment:" ". Is there a way I could
      • 2023-05-26 14605, 2023

      • shawnsblog
        avoid releases with a disambiguation?
      • 2023-05-26 14658, 2023

      • yvanzo
        disambiguation comment has nothing to do with cover art
      • 2023-05-26 14635, 2023

      • shawnsblog
        Agreed...
      • 2023-05-26 14624, 2023

      • yvanzo
        if still needed for another reason, the trick would be to add AND -comment:*
      • 2023-05-26 14636, 2023

      • shawnsblog
        I guess I was trying to solve an edge case.... There's not really a way to query for the album artwork existing according to the API then?
      • 2023-05-26 14654, 2023

      • shawnsblog
        I'm not seeing it as a field in the release portion
      • 2023-05-26 14611, 2023

      • BrainzGit
        [listenbrainz-android] 14akshaaatt opened pull request #158 (03main…additions): Improved Profile Screen, Added a dummy Explore Screen and Bumped dependencies https://github.com/metabrainz/listenbrainz-androi…
      • 2023-05-26 14632, 2023

      • yvanzo
        no, indeed, you have to combine MB API and CAA API.
      • 2023-05-26 14639, 2023

      • yvanzo
      • 2023-05-26 14658, 2023

      • shawnsblog
        Yeah, I do that later on based on the CAA MB release...however in instances where MBAPI doesn't have the cover art, I was hoping to skip a call to CAA....just to get a no MBID found error
      • 2023-05-26 14632, 2023

      • yvanzo
        in such case, you can try to get a cover art from the same release group: https://musicbrainz.org/doc/Cover_Art_Archive/API…
      • 2023-05-26 14602, 2023

      • shawnsblog
        I see.
      • 2023-05-26 14614, 2023

      • akshaaatt
        Hi lucifer!
      • 2023-05-26 14617, 2023

      • akshaaatt
        Is there a cool endpoint on LB using which we can get the users’ profile details by providing their user token?
      • 2023-05-26 14636, 2023

      • lucifer
        akshaaatt: profile details as in?
      • 2023-05-26 14641, 2023

      • akshaaatt
        Username, listens count, number of followers, following, dob(if we have) or whatever could be extra
      • 2023-05-26 14606, 2023

      • akshaaatt
        I am fine with a separate endpoint for the followers list btw
      • 2023-05-26 14608, 2023

      • lucifer
        nope, each will have to be a separate api call.
      • 2023-05-26 14614, 2023

      • akshaaatt
        Right
      • 2023-05-26 14621, 2023

      • lucifer
        we don't have dob fwiw.
      • 2023-05-26 14643, 2023

      • akshaaatt
        Can we make a consolidated endpoint which just gives me the basic details of the user?
      • 2023-05-26 14611, 2023

      • akshaaatt
        It’s not good to call multiple apis for small data like the profile
      • 2023-05-26 14614, 2023

      • lucifer
        the listen count is expensive and slow to calculate, a consolidated endpoint would prevent you from rendering the entire screen until listen count is done.
      • 2023-05-26 14649, 2023

      • akshaaatt
        Doesn’t redis help with such stuff. Like I don’t want the exact listen count always
      • 2023-05-26 14654, 2023

      • akshaaatt
        ?*
      • 2023-05-26 14626, 2023

      • akshaaatt
        I’m fine if it only updates once every 2 hours also
      • 2023-05-26 14630, 2023

      • lucifer
        If you don't want exact counts then it should be quick.
      • 2023-05-26 14638, 2023

      • akshaaatt
        Right
      • 2023-05-26 14656, 2023

      • lucifer
        probably would want to show to a disclaimer to the user because the website always shows exact counts.
      • 2023-05-26 14637, 2023

      • lucifer
        but yes a consolidated endpoint is doable.
      • 2023-05-26 14647, 2023

      • akshaaatt
        I mean.. if it’s expensive then even the website shouldn’t put too much pressure on it I feel.
      • 2023-05-26 14648, 2023

      • lucifer
        let me know the exact list of data you want.
      • 2023-05-26 14654, 2023

      • akshaaatt
        Thanks lucifer
      • 2023-05-26 14649, 2023

      • akshaaatt
        Is there a user model somewhere in the db lucifer? I could have a look at what all data we have available to decide what we could use for the ui
      • 2023-05-26 14633, 2023

      • lucifer
        not really. because most of this stuff lives in different tables.
      • 2023-05-26 14635, 2023

      • lucifer
      • 2023-05-26 14648, 2023

      • akshaaatt
        Interesting
      • 2023-05-26 14654, 2023

      • lucifer
        i think you want the data in the right column.
      • 2023-05-26 14631, 2023

      • akshaaatt
        Yeah, but again, I’m fine with those being separate apis.
      • 2023-05-26 14647, 2023

      • akshaaatt
        Just the count and stuff in consolidated
      • 2023-05-26 14616, 2023

      • akshaaatt
        I might be interested in listens submitted today for the profile endpoint
      • 2023-05-26 14626, 2023

      • akshaaatt
        Just the count
      • 2023-05-26 14609, 2023

      • lucifer
        there's a distinction between the listens submitted today and the listens listened today.
      • 2023-05-26 14612, 2023

      • akshaaatt
        How easy would it be to cherry pick the BEST results in the api response, lucifer? Your best artist, best song, etc
      • 2023-05-26 14619, 2023

      • lucifer
        because you can submit listens in the past.
      • 2023-05-26 14623, 2023

      • akshaaatt
        Makes sense lucifer
      • 2023-05-26 14603, 2023

      • lucifer
        for the backend, it would incur the same cost as individual calls.
      • 2023-05-26 14614, 2023

      • akshaaatt
        Right
      • 2023-05-26 14658, 2023

      • akshaaatt
        Let me get back to you by tomorrow on this then
      • 2023-05-26 14613, 2023

      • lucifer
        sure sounds good.
      • 2023-05-26 14614, 2023

      • akshaaatt
        We do need a profile picture for the user somehow lucifer
      • 2023-05-26 14636, 2023

      • lucifer
        we currently don't have that in any MeB service.
      • 2023-05-26 14642, 2023

      • akshaaatt
        I was thinking if letting the user select an album cover as their profile picture could be a good idea
      • 2023-05-26 14604, 2023

      • akshaaatt
        This could be MeB wide if accepted
      • 2023-05-26 14631, 2023

      • akshaaatt
        But the UX has to appeal to the user and we can’t always give a blank face to the user
      • 2023-05-26 14635, 2023

      • lucifer
        yup it should be MeB wide but comes with its own challenges so a whole different discussion.
      • 2023-05-26 14647, 2023

      • lucifer
        best to bring up in next meeting.
      • 2023-05-26 14655, 2023

      • akshaaatt
        Awesome!
      • 2023-05-26 14604, 2023

      • lucifer
        regarding album cover, that could be a good alternative.
      • 2023-05-26 14617, 2023

      • akshaaatt
        Yus
      • 2023-05-26 14624, 2023

      • lucifer
        maybe the album cover of their latest pinned recording?