#metabrainz

/

      • alastairp
      • CatQuest
        what wil default order be?
      • reosarevok
        bitmap: is the overview tab not having issues with RG sort then?
      • CatQuest
        alphanumeric?
      • reosarevok
        CatQuest: ID, probably, so when they got added
      • (since I guess the issue is *any* sort is super slow because there's so many of them)
      • bitmap
        reosarevok: yes, that's pretty darn slow too in that it frequently spams the PG logs, but not slow enough that it causes load spikes like the VA case
      • reosarevok
        Is the issue specifically with date/country or any sort?
      • Oh, I see you suggested sorting by name
      • We could even special case the VA page to browse by first letter (like our old browse page) then paginate
      • If it's too slow
      • CatQuest
        ooh i like that idea actually
      • i like it a lot
      • reosarevok
        Although that should still allow filtering by type and whatnot
      • CatQuest
        bring bakc "browse" !
      • yep
      • but I was wondering, could we group by "type" first also?
      • reosarevok
        So click "Album" and then find by first letter?
      • CatQuest
        incase wanted to go thought again things liek singles and ep's and what not wich might shoudl be moved
      • also "remix" wich very well may have the artist changed too
      • reosarevok
        I mean, if we made such a change, that step wouldn't be too hard
      • CatQuest
        yea
      • or revers. first a letter thne group per type
      • reosarevok
        For now that still loads though so that'd be more of a longer-term issue, but I think special-casing VA more makes sense
      • CatQuest
        whatever people like
      • bitmap
        any ORDER BY that isn't backed by an index is going to be pretty slow but depends on the query/size of the table
      • CatQuest
        anything thna by id imho
      • reosarevok
        bitmap: can't we index the date?
      • CatQuest
        +1
      • reosarevok
        (and skip the country order)
      • CatQuest
        a nother idea for browsing is to have "by date" (you cna chose a year or yea range" and it only shows thos) but letter liek old browse, or by country, and it only show that country. etc
      • bitmap
        it wouldn't help in this case since it's filtering by artist
      • but an index on the date might help for the filtering
      • (filtering by date I mean)
      • just not for improving the sort performance
      • reosarevok
        I see
      • CatQuest
        lol look at this weird release i found on amazon https://www.amazon.co.uk/dp/B00DHQ51Z8
      • reosarevok
        Any ideas on what might improve the sort performance at all longer term?
      • CatQuest: πŸ™„
      • Seems legit
      • CatQuest
        ikr?
      • bitmap
        probably caching the page offsets somewhere
      • reosarevok
        But wouldn't that need to be redone every time someone added a new VA release anyway?
      • Invalidating the old cache I mean
      • bitmap
        yup
      • CatQuest
        πŸ€” the edits I want to do is going to move releases *away* from VA though...
      • so that will reduce
      • reosarevok
        haha
      • Sadly, I suspect more VA releases get added than moved away even with help
      • CatQuest
        but having a sort of "by letter" browse on VA doesnt bother me at all. it seems lie ka really good idea
      • yea I guess :(
      • reosarevok
        Although I should check VA at some point for stuff that should be classical-styled
      • CatQuest
        +100
      • reosarevok
        Maybe there's a ton
      • CatQuest
        i bet there is
      • reosarevok
        Not that I need *more* crap to fix
      • But eh
      • CatQuest
        oh no.
      • I mean i cna help?
      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | GSoC students start here: https://bit.ly/2NUaxgb | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Meeting agenda: Reviews
      • jmp_music has quit
      • Freso
        <BANG>
      • It’s International Kissing Monday!
      • I have received one mailed in review, so: ishaanshah, go!
      • ishaanshah says…
      • """
      • Last week I worked on completion of Listening Activity frontend and writing tests for it. Other than that worked on the issue of request consumer dropping some messages. Completed my first evaluation. I had lots of fun the last 2 months, have learnt a lot. I would like to thank iliekcomputers and the whole MeB community for giving me such a wonderful opportunity. Thats all for me. Fin!
      • """
      • Other people up for reviews today: zas, yvanzo, Mr_Monkey, Freso, alastairp, reosarevok, ruaok, pristine__, bitmap, diru1100, jmp_music, prabal, Cyna[m], _lucifer, CatQuest, shivam-kapila – anyone else who wants to give review, let me know ASAP!
      • zas: Go!
      • Ping zas?
      • CatQuest
        :(
      • Freso
        yvanzo: Go!
      • yvanzo
        Hi!
      • zas
        hey
      • CatQuest
        on no.
      • yvanzo
        Last week, I released a new version of MusicBrainz Server.
      • I fixed small issues and worked on unlisting unrelated edits.
      • zas
        sorry, late by one minute ;), I'll go after yvanzo
      • CatQuest
        !m yvanzo
      • BrainzBot
        You're doing good work, yvanzo!
      • yvanzo
        Not much to report actually, so it's your turn zas!
      • zas
        Among news, we released Picard 2.4.0beta1 and beta2
      • reosarevok
        Thanks for fixing my mess, yvanzo! :)
      • zas
        only few bugs reported, it seems pretty good, we expect to release final by the end of this month
      • apart that, upgraded grafana to latest version
      • CatQuest
      • zas
        plus usual maintenance, upgrades, service restarts, and yes fixed discourse ;)
      • CatQuest
        \o/
      • zas
        fin. Mr_Monkey?
      • Mr_Monkey
        Hi !
      • CatQuest
        hi!
      • Mr_Monkey
        Last week worked on PR reviews and GSoC evaluation
      • Also continued work with shivam-kapila on LB's design. Looking nice and clean!
      • jmp_music joined the channel
      • I also started work on reworking pagination in LB's listens page (currently clicking next loads a new page instead of having in-page pagination). Still have one more improvement I want to add before the PR is ready
      • That's it for me ! Freso go !
      • Freso
        o/
      • My keyboard is being wonky under Firefox lately. :|
      • Anyway.
      • Really not much of anything to report, skulking about mostly and doing summer stuff and studying Python comp sci.
      • alastairp: Go!
      • alastairp
        good evening
      • last week I spent a day at the metabrainz office, it was great to get out of the house and see Mr_Monkey and ruaok in person
      • I had a good discussion with ruaok about his recommendation systems pipeline. I also continued some work with the model training submission interface in AB
      • I also had an interesting discussion with an ex-workmate who is currently working on a metadata matching project, much like what ruaok has been doing. He is going to use the messybrainz data to evaluate his machine-learning-based method and see if we can improve the matching percentage. I spent a bit of time over the last few days talking to him about the messybrainz server and process
      • hopefully some results in the next few weeks
      • also spent some time with jmp_music.
      • that's me, reosarevok next
      • reosarevok
        Hi!
      • I did some code review, and was otherwise busy with home (hopefully-)improvement and a small, 500-people-max festival on the weekend
      • It feels weird to have live music even if it's limited to 500 people
      • CatQuest
        reosarevok: be careful!
      • reosarevok
        Today I've been trying to look into some more bugs caused by converting TT code (which just laughs if something is missing from the data and prints everything else anyway) to React (which screams at you because the data isn't there)
      • Every day I'm reminded of how shit our historic edit data is, oh well
      • I'll try to keep up with my programming in between the home stuff
      • fin. CatQuest?
      • CatQuest
        Meow! `😺`
      • Been working on BB-514, including adding blurbs to every relationship also to explain what it does - that'll go into documentation
      • BrainzBot
        BB-514: Add missing, and improve current relationships https://tickets.metabrainz.org/browse/BB-514
      • Freso
        (People still up: ruaok, pristine__, bitmap, diru1100, jmp_music, prabal, Cyna[m], _lucifer, shivam-kapila – anyone else who wants to give review, let me know ASAP!)
      • CatQuest
        Finished work-work (almost) now working on author-work, which is also coming along nicely, next will be author-edition!
      • Also finally got access to community.meb again! all hail zas!
      • So I've replied to some posts there
      • β™Š
      • fin, go prabal
      • prabal
        Hi
      • Freso
        Or maybe... go, ruaok!
      • Oh, nvm.
      • CatQuest
        freso jump the gun
      • prabal
        XD
      • Freso
        CatQuest: I've said before that I'd wait 40 seconds before calling a new one out, I gave 50 seconds here.
      • prabal
        Delete collections and Add Entity To Collection PR got merged last week
      • CatQuest
        relax freso it wasn't meant as an attac k :P
      • prabal
        The project is going nicely
      • CatQuest
        prabal: looking forward to testing it!
      • prabal
        Also passed gsoc first evaluation :P
      • ruaok
        stupid fail all button.
      • prabal
        Haahaa :p
      • Mr_Monkey
        I'll add that the project is really moving along and there is now a working full workflow of creating/adding & removing/editing/viewing/deleting collections !
      • CatQuest
        πŸ‘ Mr_Monkey and prabal working hard!
      • prabal
        Also worked of collection view payees last week
      • This week will be about writing tests and documentation
      • Pages*
      • That's it for me
      • ruaok: go
      • ruaok
        ok
      • last week was busy!