julian45: hey! today is the day I check in with you about the test VM we made a few weeks back. still need it?
julian45[m] joined the channel
julian45[m]
<mayhem[m]> "julian45: hey! today is the..." <- hey! i think i need it for 1 more week, and then we can probably get rid of it. would that work for you?
suvid[m] has quit
lucifer[m] joined the channel
lucifer[m]
rayyan_seliya123, suvid, m.amanullah7 will answer your questions later today.
mayhem: gentle reminder about similarity data.
mayhem[m]
on it. (very soon anyways)
rostiku[m] joined the channel
rostiku[m]
Hey guys, I'm working on joining release_first_release_date on release to determine the earliest released track. This is what SQL script I have so far:... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)
s/released track/release/
Do the release ids have any significance? I am thinking to just stick to the one with the lowest release id. But to me that makes the whole join process irrelevant.
reosarevok[m]
If the date is the same, by definition any of them are equally earliest :)
Jade[m] joined the channel
Jade[m]
Heya, I won't be at the meeting today, being on holiday :)
reosarevok[m]
Release ids will just depend on what was added first, which has nothing to do with the actual date
If you don't really care about earliest as such but want a canonical release for each group, the LB people have code for that
mayhem: ^
But that's a different thing of course :)
Jade: enjoy!
Jade[m]
reosarevok[m]: Thank you ❤️
rostiku[m]
Yeah, I guess you're right, it's the "earliest" release and there can be multiple "earliest" releases. I am just trying to decide how to find the "best" earliest release.
I'm thinking if I combine the two processes, get the "earliest" releases, then see what was added first (by release ID), it'll be satisfactory. But I'll be happy to look into the "canonical release" determination code as well
