<outsidecontext[m> "zas: I fixed some Discourse..." <- Updates deployed, thanks!
2025-08-11 22326, 2025
rain0r has quit
2025-08-11 22340, 2025
petitminion joined the channel
2025-08-11 22319, 2025
lusciouslover has quit
2025-08-11 22341, 2025
lusciouslover joined the channel
2025-08-11 22349, 2025
lusciouslover has quit
2025-08-11 22306, 2025
mayhem[m] joined the channel
2025-08-11 22306, 2025
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | BookBrainz: #bookbrainz | Channel is logged and not empty as it is bridged to IRC; see https://musicbrainz.org/doc/ChatBrainz for details | Agenda: Reviews, Old MB Android App (mayhem), CAA cache (mayhem)
2025-08-11 22322, 2025
rayyan_seliya123 has quit
2025-08-11 22331, 2025
d4rk-ph0enix has quit
2025-08-11 22356, 2025
d4rk-ph0enix joined the channel
2025-08-11 22338, 2025
d4rkie has quit
2025-08-11 22304, 2025
d4rkie joined the channel
2025-08-11 22324, 2025
petitminion has quit
2025-08-11 22359, 2025
petitminion joined the channel
2025-08-11 22305, 2025
mayhem[m]
lucifer: remind me, in the cover_art_archive.cover_art there are 6M rows, but we have about 3M actual pieces of cover_art. I want a query so I can backup all the CAA images, so I just need caa_id/release_mbid.
2025-08-11 22314, 2025
mayhem[m]
SELECT r.gid AS release_mbid... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/hJRYDQwIwKDGtQaaNcOxdcNe>)
2025-08-11 22351, 2025
lucifer[m] joined the channel
2025-08-11 22352, 2025
lucifer[m]
mayhem: yes sounds right to me.
2025-08-11 22325, 2025
lucifer[m]
what do you mean by only 3M pieces but 6M rows in the cover art table?
2025-08-11 22341, 2025
mayhem[m]
musicbrainz_db=> select count(*) from cover_art_archive.cover_art;... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/aJmrHhnJtGISnNCJekdVZIkW>)
2025-08-11 22320, 2025
mayhem[m] uploaded an image: (15KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/qarepZGKCCQozJwjXJFSCeyZ/image.png >
2025-08-11 22336, 2025
mayhem[m]
off by a factor of 2. what am I missing?
2025-08-11 22346, 2025
reosarevok[m]
mayhem: isn't that releases with cover art rather than pieces?
2025-08-11 22306, 2025
reosarevok[m]
The 3m
2025-08-11 22326, 2025
mayhem[m]
maybe just ignore mbid in this case and just focus on caa_id ?
2025-08-11 22304, 2025
mayhem[m]
no, 6M distinct caa_ids.
2025-08-11 22312, 2025
reosarevok[m]
Yeah, I mean that the stats you shared are the amount of releases with a CAA front cover IIRC
2025-08-11 22338, 2025
reosarevok[m]
So we have almost 5 million releases, of which a bit over 3 million have cover art (or front cover art specifically)
2025-08-11 22309, 2025
reosarevok[m]
Having double that in images is a bit surprising (because I expect most releases have just a front) but not necessarily an error
2025-08-11 22311, 2025
mayhem[m]
in this care about all cover art, not just fronty
2025-08-11 22356, 2025
reosarevok[m]
Maybe we just do have a lot of backs and a fair amount of booklets with 40 images each :)
2025-08-11 22358, 2025
mayhem[m]
ok, I'll let this run and we'll see what happens.
2025-08-11 22304, 2025
mayhem[m]
possibly, yea
2025-08-11 22355, 2025
reosarevok[m]
julian45: you changed how the blog stuff works, right? What's the new system for posting?
2025-08-11 22308, 2025
julian45[m] joined the channel
2025-08-11 22308, 2025
julian45[m]
reosarevok[m]: not *really* changed much, but i'll need to set a new password for your account on the self-hosted instance since the data export from the WP.com-hosted blog didn't include passwords
2025-08-11 22332, 2025
julian45[m]
once you have a new password (which i'll DM to you shortly) it'll be the same old wordpress experience, at least for the time being
