#metabrainz

/

      • rexwilliams1234[
        <rexwilliams1234[> "Thank you. Much appreciated..." <- Thanks for the query on genres. One thing I am curious about is entity_tag. I can’t find it as a table or view. Would it be some kind of legacy reference or some type of generalized tag placeholder meant to refer to different tag tables? I substituted artist_tag for entity_tag. and saw that the query worked. Appreciate any information on where entity_tag comes
      • 2025-04-08 09814, 2025

      • rexwilliams1234[
        from.
      • 2025-04-08 09857, 2025

      • \- joined the channel
      • 2025-04-08 09819, 2025

      • function1 has quit
      • 2025-04-08 09838, 2025

      • function1 joined the channel
      • 2025-04-08 09839, 2025

      • aerozol[m]
        Thanks bitmap, it’s all good, it’s usually just a few accounts/not thousands!
      • 2025-04-08 09848, 2025

      • aerozol[m]
        Otherwise I’ll let you or reo know
      • 2025-04-08 09858, 2025

      • bitmap[m]
        <rexwilliams1234[> "Thanks for the query on genres...." <- the `FROM artist_tag entity_tag` part just creates a [table alias](https://www.postgresql.org/docs/16/sql-sel…, and yes, it was copied from the server code where it was primarily used to avoid having to interpolate the specific table name many times :) if you're only working with artists it serves no real purpose
      • 2025-04-08 09843, 2025

      • Kladky has quit
      • 2025-04-08 09847, 2025

      • Kladky_ joined the channel
      • 2025-04-08 09856, 2025

      • Kladky_ is now known as Kladky
      • 2025-04-08 09821, 2025

      • Kladky has quit
      • 2025-04-08 09806, 2025

      • HSOWA joined the channel
      • 2025-04-08 09852, 2025

      • LupinIII joined the channel
      • 2025-04-08 09825, 2025

      • ApeKattQuest has quit
      • 2025-04-08 09840, 2025

      • Zenigata has quit
      • 2025-04-08 09818, 2025

      • salaxceitor[m] has quit
      • 2025-04-08 09810, 2025

      • minimal has quit
      • 2025-04-08 09827, 2025

      • pite has quit
      • 2025-04-08 09837, 2025

      • Kladky joined the channel
      • 2025-04-08 09806, 2025

      • Kladky has quit
      • 2025-04-08 09838, 2025

      • Kladky joined the channel
      • 2025-04-08 09839, 2025

      • Kladky has quit
      • 2025-04-08 09804, 2025

      • Kladky joined the channel
      • 2025-04-08 09835, 2025

      • Kladky has quit
      • 2025-04-08 09819, 2025

      • Kladky joined the channel
      • 2025-04-08 09820, 2025

      • Kladky has quit
      • 2025-04-08 09832, 2025

      • Kladky joined the channel
      • 2025-04-08 09833, 2025

      • Kladky has quit
      • 2025-04-08 09837, 2025

      • Kladky joined the channel
      • 2025-04-08 09855, 2025

      • Kladky has quit
      • 2025-04-08 09821, 2025

      • BrainzGit
        [listenbrainz-server] 14MonkeyDo opened pull request #3247 (03master…thank-you-feed-events-improvements): UserFeed: improve missing "thank you" events preview (Part II) https://github.com/metabrainz/listenbrainz-server…
      • 2025-04-08 09832, 2025

      • allen has quit
      • 2025-04-08 09845, 2025

      • dvirtz[m] joined the channel
      • 2025-04-08 09846, 2025

      • dvirtz[m]
        Hello. I'd like to try working on SEARCH-434 and would love some pointers on where to start.
      • 2025-04-08 09846, 2025

      • dvirtz[m]
        Should the changes be done in mbsssss?
      • 2025-04-08 09847, 2025

      • BrainzBot
        SEARCH-434: Work attribute search https://tickets.metabrainz.org/browse/SEARCH-434
      • 2025-04-08 09851, 2025

      • pite joined the channel
      • 2025-04-08 09842, 2025

      • DarthGandalf has quit
      • 2025-04-08 09800, 2025

      • bitmap[m]
        hi dvirtz, you'll certainly need some mbsssss changes to add the necessary fields to the work core, and also some [sir](https://github.com/metabrainz/sir) changes to post those fields to solr when the database changes
      • 2025-04-08 09804, 2025

      • dvirtz[m]
        Would it require a schema change?
      • 2025-04-08 09832, 2025

      • bitmap[m]
        we already support work attribute lists in the mmd-schema, so I don't think so, unless you had some other addition in mind
      • 2025-04-08 09855, 2025

      • dvirtz[m]
        no, I just saw database changes and was afraid you meant a schema change
      • 2025-04-08 09802, 2025

      • bitmap[m]
        ah, I meant: when a work attribute value in the database changes, sir sends those changes to solr
      • 2025-04-08 09851, 2025

      • bitmap[m]
        here's an example of a new search field being added: https://github.com/metabrainz/sir/pull/102
      • 2025-04-08 09814, 2025

      • Kladky joined the channel
      • 2025-04-08 09849, 2025

      • Kladky has quit
      • 2025-04-08 09804, 2025

      • Kladky joined the channel
      • 2025-04-08 09811, 2025

      • pite_ joined the channel
      • 2025-04-08 09819, 2025

      • pite has quit
      • 2025-04-08 09840, 2025

      • Kladky has quit
      • 2025-04-08 09851, 2025

      • Kladky joined the channel
      • 2025-04-08 09806, 2025

      • mayhem has quit
      • 2025-04-08 09801, 2025

      • mayhem joined the channel
      • 2025-04-08 09810, 2025

      • BrainzGit
        [musicbrainz-server] 14mwiencek opened pull request #3514 (03schema-change-2025-q2…mbs-13322): MBS-13322: Fix race condition in `delete_unused_url` https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09854, 2025

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #3510 (03master…info_bubbles): MBS-5944: Rework doc bubbles for release editor info tab https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09845, 2025

      • BrainzGit
        [musicbrainz-server] 14yvanzo opened pull request #3515 (03production…solrcloud7backups): Separate SolrCloud 7 key https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09838, 2025

      • pite joined the channel
      • 2025-04-08 09837, 2025

      • pite_ has quit
      • 2025-04-08 09820, 2025

      • yvanzo[m]
        bitmap: Thanks!
      • 2025-04-08 09800, 2025

      • yvanzo[m]
        bitmap: By the way, your syswiki PR is still pending.
      • 2025-04-08 09833, 2025

      • bitmap[m]
        yvanzo: thanks for the reminder, I did forget about that :) will make a note to check it again after schema change tickets
      • 2025-04-08 09837, 2025

      • minimal joined the channel
      • 2025-04-08 09803, 2025

      • DarthGandalf joined the channel
      • 2025-04-08 09813, 2025

      • SigHunter has quit
      • 2025-04-08 09802, 2025

      • SigHunter joined the channel
      • 2025-04-08 09813, 2025

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #2804 (03master…MBS-2349): MBS-2349: Allow merging RGs when merging releases https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09810, 2025

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #3491 (03master…MBS-13957): MBS-13957: Add a report for duplicate items in series https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09842, 2025

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #1717 (03master…MBS-11129): MBS-11129: Display mediums as Medium # (Format) https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09801, 2025

      • BrainzGit
        [listenbrainz-server] 14Aerozol merged pull request #3246 (03master…add-home-assistant-to-add-data): Update AddData.tsx https://github.com/metabrainz/listenbrainz-server…
      • 2025-04-08 09815, 2025

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #3482 (03master…punish-bad-children): Don't ignore disallowed children HTML errors https://github.com/metabrainz/musicbrainz-server/…
      • 2025-04-08 09826, 2025

      • aerozol[m]
        Don’t ignore disallowed children 🙏
      • 2025-04-08 09805, 2025

      • reosarevok[m]
        But punish the bad ones
      • 2025-04-08 09834, 2025

      • Kladky has quit
      • 2025-04-08 09817, 2025

      • Maxr1998_ joined the channel
      • 2025-04-08 09823, 2025

      • Maxr1998 has quit
      • 2025-04-08 09857, 2025

      • Jade[m]
        The children need attention 😔
      • 2025-04-08 09854, 2025

      • minimal has quit
      • 2025-04-08 09812, 2025

      • minimal joined the channel