11:48 AM
CatQuest
reosarevok: come over here and we can have a lan party when the gameLan is Game(lan)Over
2019-10-22 29542, 2019
11:48 AM
CatQuest
:D
2019-10-22 29500, 2019
11:49 AM
CatQuest regrets nothing
2019-10-22 29533, 2019
11:53 AM
pristine__
CatQuest: hey, all this while I realised that you have so many listens in LB
2019-10-22 29538, 2019
11:53 AM
pristine__
<3
2019-10-22 29558, 2019
11:53 AM
CatQuest
:D
2019-10-22 29559, 2019
11:53 AM
CatQuest
:)
2019-10-22 29505, 2019
11:56 AM
pristine__
alastairp: nice. I didn't think in that dir. You mean bad strings given to queries leading to crashes?
2019-10-22 29504, 2019
12:06 PM
Mr_Monkey
ruaok: Maybe later this afternoon
2019-10-22 29529, 2019
13:08 PM
elomatreb[m] has quit
2019-10-22 29530, 2019
13:08 PM
sagar-kohli[m] has quit
2019-10-22 29530, 2019
13:08 PM
Nemo157 has quit
2019-10-22 29530, 2019
13:08 PM
ccheckk[m] has quit
2019-10-22 29530, 2019
13:08 PM
samj1912[m] has quit
2019-10-22 29530, 2019
13:08 PM
MagnusSvensson[m has quit
2019-10-22 29530, 2019
13:08 PM
jee[m] has quit
2019-10-22 29530, 2019
13:08 PM
dns[m] has quit
2019-10-22 29530, 2019
13:08 PM
chaban has quit
2019-10-22 29530, 2019
13:08 PM
reg[m] has quit
2019-10-22 29550, 2019
13:27 PM
BrainzGit
2019-10-22 29509, 2019
13:54 PM
pristine__
ruaok: ^
2019-10-22 29528, 2019
14:03 PM
ruaok
wooo! exciting!
2019-10-22 29555, 2019
14:04 PM
ruaok
2019-10-22 29557, 2019
14:07 PM
pristine__
ruaok: I will push changes file by file so that it is not difficult for the reviewers.
2019-10-22 29511, 2019
14:08 PM
pristine__
Right now create_dataframes has been altered
2019-10-22 29514, 2019
14:08 PM
ruaok
do you want new JSON base data sets?
2019-10-22 29524, 2019
14:08 PM
ruaok
I have them ready, I think.
2019-10-22 29555, 2019
14:08 PM
pristine__
I have the data in HDFS but you can put them on leader. I will host on williams soon
2019-10-22 29517, 2019
14:09 PM
ruaok
I'm more thinking about having an up to date PR that uses JSON going forward...
2019-10-22 29551, 2019
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
2019-10-22 29540, 2019
14:10 PM
bitmap
and normally I revert any DB deletions from the commit since I know I'm missing them
2019-10-22 29537, 2019
14:11 PM
bitmap
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
2019-10-22 29552, 2019
14:11 PM
bitmap
my fault anyway, I'll fix
2019-10-22 29539, 2019
14:15 PM
yvanzo
thank you!
2019-10-22 29505, 2019
14:18 PM
ruaok
pristine__: the .bz2 files in your dir have been updated to be the JSON version.
2019-10-22 29507, 2019
14:18 PM
ruaok
+s
2019-10-22 29551, 2019
14:19 PM
alastairp
hello
2019-10-22 29559, 2019
14:19 PM
ruaok waves
2019-10-22 29503, 2019
14:20 PM
ruaok
long time no see!
2019-10-22 29540, 2019
14:20 PM
alastairp
pristine__: not just crashes, there's a risk of malicious users being able to delete data or steal private data
2019-10-22 29524, 2019
14:21 PM
alastairp
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
2019-10-22 29534, 2019
14:22 PM
ruaok
possibly because spark is not meant to be used in a live environment?
2019-10-22 29545, 2019
14:22 PM
ruaok
not that I am defending that argument...
2019-10-22 29553, 2019
14:22 PM
ruaok
2019-10-22 29530, 2019
14:23 PM
ruaok
the mood_happy is rather quite different for that same radiohead track. :(
2019-10-22 29555, 2019
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
2019-10-22 29509, 2019
14:24 PM
alastairp
(use a query builder, get a string, pass that to the query method)
2019-10-22 29524, 2019
14:24 PM
alastairp
but I'm not convinced. no one on the internet sees this as a bad thing
2019-10-22 29547, 2019
14:24 PM
alastairp
ruaok: right, but this could just as easily be a bad duplicate submission
2019-10-22 29500, 2019
14:25 PM
ruaok
ah, right.
2019-10-22 29532, 2019
14:25 PM
ruaok
I'll filter that out anyway. I'll have to listen to the track to see which is a better fit...
2019-10-22 29522, 2019
14:29 PM
alastairp
we have enough data with this index to actually filter out bad submissions now
2019-10-22 29546, 2019
14:29 PM
ruaok
how do I go about choosing the right version of that duplicate pair?
2019-10-22 29557, 2019
14:29 PM
alastairp
simple answer for now: you don't
2019-10-22 29502, 2019
14:30 PM
alastairp
because we don't know which one is correct
2019-10-22 29522, 2019
14:30 PM
ruaok
so the filtering needs to be done on the AB level and not ANNOY?
2019-10-22 29534, 2019
14:30 PM
ruaok
annoy informs the filtration process?
2019-10-22 29543, 2019
14:30 PM
alastairp
if you have 3 or more submissions for an MBID
2019-10-22 29505, 2019
14:31 PM
pristine__
alastairp: oooo... I want to read more about it. Do share any resource if you have
2019-10-22 29520, 2019
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
2019-10-22 29527, 2019
14:31 PM
weirditude has quit
2019-10-22 29539, 2019
14:31 PM
alastairp
2019-10-22 29558, 2019
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
2019-10-22 29513, 2019
14:32 PM
ruaok
2019-10-22 29520, 2019
14:32 PM
pristine__
alastairp: phew..... Wikipedia is never a resource I look up to....
2019-10-22 29527, 2019
14:32 PM
pristine__
Isn't it boring kinda?
2019-10-22 29513, 2019
14:33 PM
ruaok
remember to add the needed license files and such. I should add that to the mapping process.
2019-10-22 29525, 2019
14:33 PM
pristine__
ruaok: Lord, I cannot stop laughing
2019-10-22 29533, 2019
14:33 PM
pristine__
Umm.... Did you see the test dump?
2019-10-22 29544, 2019
14:33 PM
pristine__
I included the copy license file there
2019-10-22 29554, 2019
14:33 PM
pristine__
The same, no?
2019-10-22 29558, 2019
14:33 PM
ruaok
I haven't. should I download it?
2019-10-22 29502, 2019
14:34 PM
ruaok
yea, should be.
2019-10-22 29509, 2019
14:34 PM
pristine__
You can... It is 1MB
2019-10-22 29534, 2019
14:34 PM
pristine__
The license in Listenbrainz full dump
2019-10-22 29539, 2019
14:34 PM
pristine__
Took it from there.
2019-10-22 29550, 2019
14:34 PM
ruaok downloads
2019-10-22 29532, 2019
14:40 PM
ruaok
pristine__: the TIMESTAMP file has a second accurate timestamp -- is that what the LB files have?
2019-10-22 29548, 2019
14:40 PM
ruaok
the live data feed files from MB have subsecond accuracy and timezone.
2019-10-22 29550, 2019
14:40 PM
ruaok
2011-05-17 17:00:15.816041+00
2019-10-22 29551, 2019
14:40 PM
ruaok
vs
2019-10-22 29557, 2019
14:40 PM
ruaok
2019-10-15 10:37:48
2019-10-22 29518, 2019
14:42 PM
pristine__
Shit. Sorry :(
2019-10-22 29543, 2019
14:42 PM
ruaok
no need to be sorry. :)
2019-10-22 29506, 2019
14:43 PM
pristine__
😞
2019-10-22 29529, 2019
15:04 PM
pristine__
I like it when someone says it is a very good start
2019-10-22 29544, 2019
15:04 PM
pristine__
ruaok: alastairp <3
2019-10-22 29544, 2019
15:04 PM
amCap1712
hi all
2019-10-22 29559, 2019
15:04 PM
amCap1712
how long does it take the my listens page to update?
2019-10-22 29500, 2019
15:06 PM
amCap1712
i fixed the json error i was facing yesterday
2019-10-22 29519, 2019
15:06 PM
amCap1712
it was due to incorrect content type header
2019-10-22 29506, 2019
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?
2019-10-22 29519, 2019
15:08 PM
amCap1712
pristine__: iliekcomputers ^^
2019-10-22 29543, 2019
15:08 PM
weirditude joined the channel
2019-10-22 29545, 2019
15:08 PM
amCap1712
it got updated now
2019-10-22 29549, 2019
15:08 PM
amCap1712
and it works
2019-10-22 29527, 2019
15:10 PM
amCap1712
the vlc plugin is now working. is anyone interested in testing it?
2019-10-22 29557, 2019
15:10 PM
amCap1712
ruaok, rdswift , CatQuest, Pac23 , alastairp : ^
2019-10-22 29525, 2019
15:13 PM
ruaok
how do we test it? which platforms?
2019-10-22 29548, 2019
15:28 PM
weirditude has quit
2019-10-22 29502, 2019
15:29 PM
weirditude joined the channel
2019-10-22 29513, 2019
15:29 PM
weirditude has quit
2019-10-22 29545, 2019
15:29 PM
amCap1712
i think it should work on all desktop platforms
2019-10-22 29519, 2019
15:30 PM
amCap1712
for now, i'll build and share the executables
2019-10-22 29551, 2019
15:30 PM
amCap1712
once the plugin is tested properly, we can submit to vlc for inclusion in central repo and future builds
2019-10-22 29503, 2019
15:32 PM
ruaok
great! do you have a mac build yet?
2019-10-22 29529, 2019
15:32 PM
weirditude joined the channel
2019-10-22 29501, 2019
15:38 PM
chaban joined the channel
2019-10-22 29559, 2019
15:44 PM
amCap1712
at the moment i have linux builds
2019-10-22 29519, 2019
15:45 PM
amCap1712
i need to install the windows and mac toolchains to build for those os
2019-10-22 29530, 2019
15:45 PM
amCap1712
once i do that i'll let you know
2019-10-22 29512, 2019
15:47 PM
CatQuest
hm. I have sadly an old mac though
2019-10-22 29524, 2019
15:47 PM
CatQuest
mac os 10.7.11
2019-10-22 29547, 2019
15:47 PM
CatQuest
but I also have windows 7 so i guess i can test it there too
2019-10-22 29519, 2019
15:48 PM
CatQuest
🤔 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
2019-10-22 29524, 2019
15:48 PM
weirditude has quit
2019-10-22 29552, 2019
15:58 PM
amCap1712
i am not sure about vlc-android CatQuest
2019-10-22 29509, 2019
15:59 PM
amCap1712
thats why i wrote desktop platforms above
2019-10-22 29511, 2019
15:59 PM
CatQuest
hm
2019-10-22 29533, 2019
15:59 PM
amCap1712
as far as i know vlc android is the only exception
2019-10-22 29550, 2019
15:59 PM
CatQuest
yea i think that makes sence, vlc android is kidna crap :D
2019-10-22 29551, 2019
16:00 PM
weirditude joined the channel
2019-10-22 29539, 2019
16:10 PM
weirditude has quit
2019-10-22 29552, 2019
16:34 PM
CatQuest
2019-10-22 29507, 2019
16:35 PM
CatQuest
cd track lsit ends oddly
2019-10-22 29528, 2019
16:35 PM
reosarevok
Seems normal to me?
2019-10-22 29533, 2019
16:35 PM
CatQuest
hmm
2019-10-22 29547, 2019
16:35 PM
CatQuest
should there be a singleborder at the end?
2019-10-22 29512, 2019
16:36 PM
reosarevok
That's how it is elsewhere too :)
2019-10-22 29535, 2019
16:36 PM
reosarevok
(just that it might look different for one-track releases because you're used to a lot more rows there?)
2019-10-22 29544, 2019
16:36 PM
CatQuest
hm
2019-10-22 29559, 2019
16:36 PM
CatQuest
several row other eleases end with a last border i thoguh..
2019-10-22 29503, 2019
16:37 PM
CatQuest
let me loo at osme releases
2019-10-22 29516, 2019
16:37 PM
CatQuest
2019-10-22 29534, 2019
16:37 PM
chhavi_ joined the channel
2019-10-22 29536, 2019
16:37 PM
reosarevok
But this has a border too?
2019-10-22 29506, 2019
16:38 PM
CatQuest
not at the bottom!
2019-10-22 29532, 2019
16:38 PM
CatQuest
not for me atleast
2019-10-22 29535, 2019
16:38 PM
CatQuest
hm
2019-10-22 29556, 2019
16:38 PM
reosarevok
... it does for me?
2019-10-22 29557, 2019
16:38 PM
reosarevok is confused
2019-10-22 29506, 2019
16:39 PM
CatQuest
huh i refreshed and it's still not there
2019-10-22 29520, 2019
16:39 PM
CatQuest
weird
2019-10-22 29552, 2019
16:41 PM
weirditude joined the channel
2019-10-22 29522, 2019
16:43 PM
reosarevok
CatQuest: screenshot maybe?
2019-10-22 29545, 2019
16:43 PM
CatQuest
hmm yea maybe. after dinner and stuff :D
2019-10-22 29551, 2019
16:46 PM
weirditude has quit
2019-10-22 29507, 2019
16:51 PM
yvanzo
2019-10-22 29555, 2019
16:52 PM
ruaok
<3
2019-10-22 29555, 2019
17:17 PM
weirditude joined the channel