15:08 PM
Pratha-Fish
return nan```
15:09 PM
lucifer
mayhem: not sure i understand what you mean. can you explain?
15:10 PM
btw the normalized tables just finished, its in `spotify_cache` schema on gaga if you want to look
15:23 PM
alastairp
yvanzo: keys are still at the office
15:26 PM
zas
yvanzo: come to the office first
15:30 PM
lucifer
mayhem: there's 145 rows at least where spotify artist id is same but the artist name is different. i guess artist ids are not unique across artist credits but also weird that there are only 145 such cases in the data.
https://www.irccloud.com/pastebin/58Td9YOk/
15:31 PM
yvanzo
zas, alastairp: Can anyone bring it to me at the station?
15:31 PM
lucifer
if its correct then the number is small enough to ignore i think. also many of these would go away with unidecode and lowercasing.
15:32 PM
alastairp
yvanzo: one sec, we're organising it
15:34 PM
mayhem
lucifer: tracks in Spotify have a list of artists, right? I just want to make sure that we keep them separate and not conflated them
15:34 PM
-d
15:35 PM
lucifer
mayhem: yes, i added a `rel_track_artist` table. which has a track_id and artist_id. so we can get the artists for each track separately.
15:35 PM
alastairp
yvanzo: aerozol is going directly to the lodging
15:35 PM
mayhem
Ah, yes, right. All good then.
15:35 PM
lucifer
if you have an example at hand where tracks from same album have different artist lists, i can check the tables to confirm
15:36 PM
yvanzo
Thanks
15:52 PM
agatzk has quit
15:54 PM
agatzk joined the channel
16:02 PM
lucifer
mayhem: takes 13mins to execute.
16:02 PM
16:03 PM
i guess may take 30mins if cache is not warm but probably not more. we'll see in due time anyways.
16:18 PM
mayhem
Wow, nice
16:22 PM
lucifer
i'll update the branch with this query and we can try running the PR then
16:24 PM
zas
for dinner tonight (for those interested) we meet at the office around 19:30
16:24 PM
mayhem
so, we've just spend the last hour talking about OAuth and we have a bit of a plan for tomorrow.
16:24 PM
are you available at 11am BCN time to join the "fun"?
16:25 PM
lucifer
yup i'll be around
16:25 PM
mayhem
the basic idea is that we'd update the OAuth lib in
meb.org and hard code a couple of user accounts with a couple of scopes.
16:25 PM
then setup a new VM with
meb.org on and another VM with an lb sandbox and then test that things work.
16:25 PM
then bring up an instance of MB and have it auth to the meb VM and slowly bring things into a prototype.
16:26 PM
I think it might be best to include you via zoom in our discussions in the morning.
16:26 PM
lucifer
16:27 PM
iirc its should be close but i never got around to test it.
16:27 PM
mayhem
oh great. I think the
meb.org work is going to fall on you and I anyway, so that should be fine.
16:27 PM
lucifer
makes sense
16:27 PM
mayhem
once we get the VM stood up, we can start the actual work on creating a new user table in
meb.org
16:28 PM
lucifer
there's a test.meb available which also runs a different database than prod so
meb.org side setup should be easy.
16:28 PM
for the VM, do we need it? we can just repurpose test.lb i think.
16:29 PM
zas
yvanzo: are you in?
16:41 PM
yvanzo
zas: yes
16:52 PM
yvanzo is heading to the HOLY now.
16:52 PM
s/HOLY/office/
16:57 PM
bitmap
yvanzo are you at the Airbnb ?
17:05 PM
yvanzo
bitmap: no, at the office
17:05 PM
lucifer
mayhem: huh there are apparently ~108,000,000 rows in track table.
17:06 PM
bitmap
Yeah I saw. Sorry I opened your bedroom door thinking it was a bathroom :)
17:06 PM
yvanzo
But I'm stuck in front of her door
17:06 PM
mayhem
lucifer: yeah, I knew the number had to be very big.
17:06 PM
lucifer
i wonder what's going on with that. that's 3-4x the number of MB tracks.
17:07 PM
bitmap
I’m on my way to the office again shortly
17:07 PM
mayhem
spotify and apple music are in a quantity arms race. apple just announced that they have 100m tracks.
17:07 PM
a vast amount of that are duplicates or listenable shit.
17:08 PM
lucifer
yeah indeed. 😞
17:09 PM
17:09 PM
anyways 2-3 hours it'll be done
17:09 PM
mayhem
noice!
17:09 PM
!m lucifer
17:09 PM
BrainzBot
You're doing good work, lucifer!
17:09 PM
yvanzo
bitmap: ok, waiting for you
17:09 PM
elgranRoble joined the channel
17:10 PM
BrainzGit
17:10 PM
lucifer
mayhem: another things, i was thinking to rework LB#2167 as a troi patch. thoughts?
17:10 PM
BrainzBot
17:12 PM
mayhem
to make playlists from collections? seems a good use yes.
17:13 PM
lucifer
yup
17:13 PM
👍
17:13 PM
reosarevok
Also, everyone's tiny project is by now in Spotify and iTunes
17:14 PM
lucifer
yeah, makes sense
17:15 PM
reosarevok
4 times the amount of tracks in MusicBrainz is actually a lot less than I would expect
17:16 PM
bitmap
Yvanzo: the rest of the group is supposed to meet back there at 7:30 I think?
17:16 PM
lucifer
but just 145 artists having multiple artist credits in 108M tracks is surely mind boggling.
17:19 PM
reosarevok
Wait, what is that supposed to mean?
17:19 PM
That only 145 appear in different combinations? then that cannot be right I don't think
17:20 PM
lucifer
17:20 PM
reosarevok
Oh, so like the same artist being mapped to two ways of writing it?
17:21 PM
lucifer
i mean same spotify id but different artist name on some tracks. iiuc i am trying to compare it to artist credits in MB
17:21 PM
reosarevok
That's still weird, but less weird than what I was thinking
17:21 PM
I didn't know that was a *thing* even
17:21 PM
Maybe it's the result of merging artists or something?
17:22 PM
lucifer
how an artist may be credited with different names on different tracks so we have artist credit and artist credit name tables.
17:23 PM
assuming spotify_id is analogous to artist.gid in MB then i'd expect a lot more results here.
17:23 PM
alastairp
lucifer: 11am in Barcelona we'll start our mini oauth hack day
17:23 PM
lucifer
sounds good alastairp. i'll be around
17:23 PM
alastairp
we wrote a task list, we'll share it tomorrow
17:23 PM
great, see you tomorrow!
17:24 PM
maybe we can put you on a video call to be along side us "in person"? :)
17:24 PM
lucifer
yes that sounds good.
17:25 PM
zas
I'm at the office
17:25 PM
darkstarx joined the channel
17:26 PM
darkstardevx has quit
17:31 PM
yvanzo
zas: bitmap and I are on your way :-)
17:46 PM
petitminion_ has quit
18:56 PM
agatzk has quit
18:56 PM
agatzk joined the channel
19:25 PM
v6lur joined the channel
19:49 PM
agatzk has quit
19:50 PM
agatzk joined the channel
20:27 PM
GibusWearingMann joined the channel
20:43 PM
GibusWearingMann has quit
20:58 PM
petitminion_ joined the channel
21:17 PM
Sophist-UK has quit
21:17 PM
Sophist-UK joined the channel
23:17 PM
agatzk has quit
23:18 PM
agatzk joined the channel
23:55 PM
elgranRoble has quit