<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 ?
