11:48 AM
CatQuest
reosarevok: come over here and we can have a lan party when the gameLan is Game(lan)Over
11:48 AM
:D
11:49 AM
CatQuest regrets nothing
11:53 AM
pristine__
CatQuest: hey, all this while I realised that you have so many listens in LB
11:53 AM
<3
11:53 AM
CatQuest
:D
11:53 AM
:)
11:56 AM
pristine__
alastairp: nice. I didn't think in that dir. You mean bad strings given to queries leading to crashes?
12:06 PM
Mr_Monkey
ruaok: Maybe later this afternoon
13:08 PM
elomatreb[m] has quit
13:08 PM
sagar-kohli[m] has quit
13:08 PM
Nemo157 has quit
13:08 PM
ccheckk[m] has quit
13:08 PM
samj1912[m] has quit
13:08 PM
MagnusSvensson[m has quit
13:08 PM
jee[m] has quit
13:08 PM
dns[m] has quit
13:08 PM
chaban has quit
13:08 PM
reg[m] has quit
13:27 PM
BrainzGit
13:54 PM
pristine__
ruaok: ^
14:03 PM
ruaok
wooo! exciting!
14:04 PM
14:07 PM
pristine__
ruaok: I will push changes file by file so that it is not difficult for the reviewers.
14:08 PM
Right now create_dataframes has been altered
14:08 PM
ruaok
do you want new JSON base data sets?
14:08 PM
I have them ready, I think.
14:08 PM
pristine__
I have the data in HDFS but you can put them on leader. I will host on williams soon
14:09 PM
ruaok
I'm more thinking about having an up to date PR that uses JSON going forward...
14:09 PM
bitmap
yvanzo: I found the issue with the Tags string; my local statistics_event table was incomplete so it wasn't finding the entry for DB:statistics.statistic_event/title:2007-10-17
14:10 PM
and normally I revert any DB deletions from the commit since I know I'm missing them
14:11 PM
so I ended up keeping the existing entry for DB + stats.js it removed, and also keeping the new one for just stats.js it added
14:11 PM
my fault anyway, I'll fix
14:15 PM
yvanzo
thank you!
14:18 PM
ruaok
pristine__: the .bz2 files in your dir have been updated to be the JSON version.
14:18 PM
+s
14:19 PM
alastairp
hello
14:19 PM
ruaok waves
14:20 PM
ruaok
long time no see!
14:20 PM
alastairp
pristine__: not just crashes, there's a risk of malicious users being able to delete data or steal private data
14:21 PM
SQL client libraries have been aware of this for 20 years, I have no idea why spark decided that it didn't apply to them
14:22 PM
ruaok
possibly because spark is not meant to be used in a live environment?
14:22 PM
not that I am defending that argument...
14:22 PM
14:23 PM
the mood_happy is rather quite different for that same radiohead track. :(
14:23 PM
alastairp
the possible argument is that in java there's a defined way of doing sql query arguments which happens outside of the interface to the database
14:24 PM
(use a query builder, get a string, pass that to the query method)
14:24 PM
but I'm not convinced. no one on the internet sees this as a bad thing
14:24 PM
ruaok: right, but this could just as easily be a bad duplicate submission
14:25 PM
ruaok
ah, right.
14:25 PM
I'll filter that out anyway. I'll have to listen to the track to see which is a better fit...
14:29 PM
alastairp
we have enough data with this index to actually filter out bad submissions now
14:29 PM
ruaok
how do I go about choosing the right version of that duplicate pair?
14:29 PM
alastairp
simple answer for now: you don't
14:30 PM
because we don't know which one is correct
14:30 PM
ruaok
so the filtering needs to be done on the AB level and not ANNOY?
14:30 PM
annoy informs the filtration process?
14:30 PM
alastairp
if you have 3 or more submissions for an MBID
14:31 PM
pristine__
alastairp: oooo... I want to read more about it. Do share any resource if you have
14:31 PM
alastairp
you can see if they're all close to each other, or if there is a cluster all the same, with some others with a much larger distance away
14:31 PM
weirditude has quit
14:31 PM
14:31 PM
pristine__
ruaok: sounds good. I will host that on williams and open a PR so that users and get the dumps from FTP and upload to hdfs
14:32 PM
ruaok
14:32 PM
pristine__
alastairp: phew..... Wikipedia is never a resource I look up to....
14:32 PM
Isn't it boring kinda?
14:33 PM
ruaok
remember to add the needed license files and such. I should add that to the mapping process.
14:33 PM
pristine__
ruaok: Lord, I cannot stop laughing
14:33 PM
Umm.... Did you see the test dump?
14:33 PM
I included the copy license file there
14:33 PM
The same, no?
14:33 PM
ruaok
I haven't. should I download it?
14:34 PM
yea, should be.
14:34 PM
pristine__
You can... It is 1MB
14:34 PM
The license in Listenbrainz full dump
14:34 PM
Took it from there.
14:34 PM
ruaok downloads
14:40 PM
ruaok
pristine__: the TIMESTAMP file has a second accurate timestamp -- is that what the LB files have?
14:40 PM
the live data feed files from MB have subsecond accuracy and timezone.
14:40 PM
2011-05-17 17:00:15.816041+00
14:40 PM
vs
14:40 PM
2019-10-15 10:37:48
14:42 PM
pristine__
Shit. Sorry :(
14:42 PM
ruaok
no need to be sorry. :)
14:43 PM
pristine__
😞
15:04 PM
I like it when someone says it is a very good start
15:04 PM
ruaok: alastairp <3
15:04 PM
amCap1712
hi all
15:04 PM
how long does it take the my listens page to update?
15:06 PM
i fixed the json error i was facing yesterday
15:06 PM
it was due to incorrect content type header
15:07 PM
yvanzo
Matthew_: your workaround to the lack of support for pg_amqp looks good, but how are you doing without musicbrainz_collate extension?
15:08 PM
amCap1712
pristine__: iliekcomputers ^^
15:08 PM
weirditude joined the channel
15:08 PM
it got updated now
15:08 PM
and it works
15:10 PM
the vlc plugin is now working. is anyone interested in testing it?
15:10 PM
ruaok, rdswift , CatQuest, Pac23 , alastairp : ^
15:13 PM
ruaok
how do we test it? which platforms?
15:28 PM
weirditude has quit
15:29 PM
weirditude joined the channel
15:29 PM
weirditude has quit
15:29 PM
amCap1712
i think it should work on all desktop platforms
15:30 PM
for now, i'll build and share the executables
15:30 PM
once the plugin is tested properly, we can submit to vlc for inclusion in central repo and future builds
15:32 PM
ruaok
great! do you have a mac build yet?
15:32 PM
weirditude joined the channel
15:38 PM
chaban joined the channel
15:44 PM
amCap1712
at the moment i have linux builds
15:45 PM
i need to install the windows and mac toolchains to build for those os
15:45 PM
once i do that i'll let you know
15:47 PM
CatQuest
hm. I have sadly an old mac though
15:47 PM
mac os 10.7.11
15:47 PM
but I also have windows 7 so i guess i can test it there too
15:48 PM
🤔 did i uninstall vlc on android? it was kidna dumb so i think i did , but i can see about re-installing it and trying it there
15:48 PM
weirditude has quit
15:58 PM
amCap1712
i am not sure about vlc-android CatQuest
15:59 PM
thats why i wrote desktop platforms above
15:59 PM
CatQuest
hm
15:59 PM
amCap1712
as far as i know vlc android is the only exception
15:59 PM
CatQuest
yea i think that makes sence, vlc android is kidna crap :D
16:00 PM
weirditude joined the channel
16:10 PM
weirditude has quit
16:34 PM
16:35 PM
cd track lsit ends oddly
16:35 PM
reosarevok
Seems normal to me?
16:35 PM
CatQuest
hmm
16:35 PM
should there be a singleborder at the end?
16:36 PM
reosarevok
That's how it is elsewhere too :)
16:36 PM
(just that it might look different for one-track releases because you're used to a lot more rows there?)
16:36 PM
CatQuest
hm
16:36 PM
several row other eleases end with a last border i thoguh..
16:37 PM
let me loo at osme releases
16:37 PM
16:37 PM
chhavi_ joined the channel
16:37 PM
reosarevok
But this has a border too?
16:38 PM
CatQuest
not at the bottom!
16:38 PM
not for me atleast
16:38 PM
hm
16:38 PM
reosarevok
... it does for me?
16:38 PM
reosarevok is confused
16:39 PM
CatQuest
huh i refreshed and it's still not there
16:39 PM
weird
16:41 PM
weirditude joined the channel
16:43 PM
reosarevok
CatQuest: screenshot maybe?
16:43 PM
CatQuest
hmm yea maybe. after dinner and stuff :D
16:46 PM
weirditude has quit
16:51 PM
yvanzo
16:52 PM
ruaok
<3
17:17 PM
weirditude joined the channel