15:08 PM
Pratha-Fish
return nan```
2022-10-05 27806, 2022
15:09 PM
lucifer
mayhem: not sure i understand what you mean. can you explain?
2022-10-05 27812, 2022
15:10 PM
lucifer
btw the normalized tables just finished, its in `spotify_cache` schema on gaga if you want to look
2022-10-05 27856, 2022
15:23 PM
alastairp
yvanzo: keys are still at the office
2022-10-05 27830, 2022
15:26 PM
zas
yvanzo: come to the office first
2022-10-05 27846, 2022
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/
2022-10-05 27811, 2022
15:31 PM
yvanzo
zas, alastairp: Can anyone bring it to me at the station?
2022-10-05 27843, 2022
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.
2022-10-05 27837, 2022
15:32 PM
alastairp
yvanzo: one sec, we're organising it
2022-10-05 27803, 2022
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
2022-10-05 27813, 2022
15:34 PM
mayhem
-d
2022-10-05 27815, 2022
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.
2022-10-05 27839, 2022
15:35 PM
alastairp
yvanzo: aerozol is going directly to the lodging
2022-10-05 27848, 2022
15:35 PM
mayhem
Ah, yes, right. All good then.
2022-10-05 27852, 2022
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
2022-10-05 27806, 2022
15:36 PM
yvanzo
Thanks
2022-10-05 27802, 2022
15:52 PM
agatzk has quit
2022-10-05 27840, 2022
15:54 PM
agatzk joined the channel
2022-10-05 27814, 2022
16:02 PM
lucifer
mayhem: takes 13mins to execute.
2022-10-05 27824, 2022
16:02 PM
lucifer
2022-10-05 27828, 2022
16:03 PM
lucifer
i guess may take 30mins if cache is not warm but probably not more. we'll see in due time anyways.
2022-10-05 27832, 2022
16:18 PM
mayhem
Wow, nice
2022-10-05 27827, 2022
16:22 PM
lucifer
i'll update the branch with this query and we can try running the PR then
2022-10-05 27817, 2022
16:24 PM
zas
for dinner tonight (for those interested) we meet at the office around 19:30
2022-10-05 27821, 2022
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.
2022-10-05 27837, 2022
16:24 PM
mayhem
are you available at 11am BCN time to join the "fun"?
2022-10-05 27805, 2022
16:25 PM
lucifer
yup i'll be around
2022-10-05 27807, 2022
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.
2022-10-05 27829, 2022
16:25 PM
mayhem
then setup a new VM with
meb.org on and another VM with an lb sandbox and then test that things work.
2022-10-05 27855, 2022
16:25 PM
mayhem
then bring up an instance of MB and have it auth to the meb VM and slowly bring things into a prototype.
2022-10-05 27817, 2022
16:26 PM
mayhem
I think it might be best to include you via zoom in our discussions in the morning.
2022-10-05 27840, 2022
16:26 PM
lucifer
2022-10-05 27812, 2022
16:27 PM
lucifer
iirc its should be close but i never got around to test it.
2022-10-05 27813, 2022
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.
2022-10-05 27814, 2022
16:27 PM
lucifer
makes sense
2022-10-05 27833, 2022
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
2022-10-05 27827, 2022
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.
2022-10-05 27848, 2022
16:28 PM
lucifer
for the VM, do we need it? we can just repurpose test.lb i think.
2022-10-05 27841, 2022
16:29 PM
zas
yvanzo: are you in?
2022-10-05 27840, 2022
16:41 PM
yvanzo
zas: yes
2022-10-05 27824, 2022
16:52 PM
yvanzo is heading to the HOLY now.
2022-10-05 27852, 2022
16:52 PM
yvanzo
s/HOLY/office/
2022-10-05 27853, 2022
16:57 PM
bitmap
yvanzo are you at the Airbnb ?
2022-10-05 27840, 2022
17:05 PM
yvanzo
bitmap: no, at the office
2022-10-05 27854, 2022
17:05 PM
lucifer
mayhem: huh there are apparently ~108,000,000 rows in track table.
2022-10-05 27802, 2022
17:06 PM
bitmap
Yeah I saw. Sorry I opened your bedroom door thinking it was a bathroom :)
2022-10-05 27831, 2022
17:06 PM
yvanzo
But I'm stuck in front of her door
2022-10-05 27835, 2022
17:06 PM
mayhem
lucifer: yeah, I knew the number had to be very big.
2022-10-05 27858, 2022
17:06 PM
lucifer
i wonder what's going on with that. that's 3-4x the number of MB tracks.
2022-10-05 27821, 2022
17:07 PM
bitmap
I’m on my way to the office again shortly
2022-10-05 27832, 2022
17:07 PM
mayhem
spotify and apple music are in a quantity arms race. apple just announced that they have 100m tracks.
2022-10-05 27857, 2022
17:07 PM
mayhem
a vast amount of that are duplicates or listenable shit.
2022-10-05 27841, 2022
17:08 PM
lucifer
yeah indeed. 😞
2022-10-05 27805, 2022
17:09 PM
lucifer
2022-10-05 27813, 2022
17:09 PM
lucifer
anyways 2-3 hours it'll be done
2022-10-05 27827, 2022
17:09 PM
mayhem
noice!
2022-10-05 27828, 2022
17:09 PM
mayhem
!m lucifer
2022-10-05 27829, 2022
17:09 PM
BrainzBot
You're doing good work, lucifer!
2022-10-05 27843, 2022
17:09 PM
yvanzo
bitmap: ok, waiting for you
2022-10-05 27846, 2022
17:09 PM
elgranRoble joined the channel
2022-10-05 27803, 2022
17:10 PM
BrainzGit
2022-10-05 27856, 2022
17:10 PM
lucifer
mayhem: another things, i was thinking to rework LB#2167 as a troi patch. thoughts?
2022-10-05 27856, 2022
17:10 PM
BrainzBot
2022-10-05 27852, 2022
17:12 PM
mayhem
to make playlists from collections? seems a good use yes.
2022-10-05 27805, 2022
17:13 PM
lucifer
yup
2022-10-05 27807, 2022
17:13 PM
lucifer
👍
2022-10-05 27855, 2022
17:13 PM
reosarevok
Also, everyone's tiny project is by now in Spotify and iTunes
2022-10-05 27856, 2022
17:14 PM
lucifer
yeah, makes sense
2022-10-05 27805, 2022
17:15 PM
reosarevok
4 times the amount of tracks in MusicBrainz is actually a lot less than I would expect
2022-10-05 27849, 2022
17:16 PM
bitmap
Yvanzo: the rest of the group is supposed to meet back there at 7:30 I think?
2022-10-05 27851, 2022
17:16 PM
lucifer
but just 145 artists having multiple artist credits in 108M tracks is surely mind boggling.
2022-10-05 27843, 2022
17:19 PM
reosarevok
Wait, what is that supposed to mean?
2022-10-05 27856, 2022
17:19 PM
reosarevok
That only 145 appear in different combinations? then that cannot be right I don't think
2022-10-05 27816, 2022
17:20 PM
lucifer
2022-10-05 27843, 2022
17:20 PM
reosarevok
Oh, so like the same artist being mapped to two ways of writing it?
2022-10-05 27807, 2022
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
2022-10-05 27809, 2022
17:21 PM
reosarevok
That's still weird, but less weird than what I was thinking
2022-10-05 27816, 2022
17:21 PM
reosarevok
I didn't know that was a *thing* even
2022-10-05 27834, 2022
17:21 PM
reosarevok
Maybe it's the result of merging artists or something?
2022-10-05 27818, 2022
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.
2022-10-05 27801, 2022
17:23 PM
lucifer
assuming spotify_id is analogous to artist.gid in MB then i'd expect a lot more results here.
2022-10-05 27816, 2022
17:23 PM
alastairp
lucifer: 11am in Barcelona we'll start our mini oauth hack day
2022-10-05 27828, 2022
17:23 PM
lucifer
sounds good alastairp. i'll be around
2022-10-05 27837, 2022
17:23 PM
alastairp
we wrote a task list, we'll share it tomorrow
2022-10-05 27844, 2022
17:23 PM
alastairp
great, see you tomorrow!
2022-10-05 27803, 2022
17:24 PM
alastairp
maybe we can put you on a video call to be along side us "in person"? :)
2022-10-05 27826, 2022
17:24 PM
lucifer
yes that sounds good.
2022-10-05 27805, 2022
17:25 PM
zas
I'm at the office
2022-10-05 27837, 2022
17:25 PM
darkstarx joined the channel
2022-10-05 27848, 2022
17:26 PM
darkstardevx has quit
2022-10-05 27856, 2022
17:31 PM
yvanzo
zas: bitmap and I are on your way :-)
2022-10-05 27854, 2022
17:46 PM
petitminion_ has quit
2022-10-05 27847, 2022
18:56 PM
agatzk has quit
2022-10-05 27853, 2022
18:56 PM
agatzk joined the channel
2022-10-05 27809, 2022
19:25 PM
v6lur joined the channel
2022-10-05 27833, 2022
19:49 PM
agatzk has quit
2022-10-05 27804, 2022
19:50 PM
agatzk joined the channel
2022-10-05 27857, 2022
20:27 PM
GibusWearingMann joined the channel
2022-10-05 27853, 2022
20:43 PM
GibusWearingMann has quit
2022-10-05 27809, 2022
20:58 PM
petitminion_ joined the channel
2022-10-05 27831, 2022
21:17 PM
Sophist-UK has quit
2022-10-05 27841, 2022
21:17 PM
Sophist-UK joined the channel
2022-10-05 27848, 2022
23:17 PM
agatzk has quit
2022-10-05 27834, 2022
23:18 PM
agatzk joined the channel
2022-10-05 27846, 2022
23:55 PM
elgranRoble has quit