they’re really closed. I’ll see if I can bear to wear them for more than 2 or 3 hours
2016-02-04 03515, 2016
alastairp
though the reviews I read seem to say that people can wear them all day for studio work
2016-02-04 03518, 2016
ruaok
or in the summer
2016-02-04 03540, 2016
alastairp
ahh, true
2016-02-04 03547, 2016
alastairp
damn barcelona
2016-02-04 03506, 2016
alastairp moves to canada again
2016-02-04 03535, 2016
ruaok
ha.
2016-02-04 03551, 2016
ruaok
did you check their current weather. :)
2016-02-04 03553, 2016
ruaok
?
2016-02-04 03512, 2016
alastairp
I’m scared to
2016-02-04 03522, 2016
ruaok
heh.
2016-02-04 03544, 2016
alastairp
hey, it’s >0C in montreal at the moment!
2016-02-04 03554, 2016
ruaok
today a friend introduced us to her friend: "I'm moving to barcelona. I got a plane ticket and selling all my belongings!"
2016-02-04 03559, 2016
ruaok
do you have a visa?
2016-02-04 03505, 2016
ruaok
no, but I have a mastercard!
2016-02-04 03508, 2016
ruaok
#facepalm
2016-02-04 03513, 2016
darwin
grooooooooaaan
2016-02-04 03527, 2016
ruaok
ok, maybe not *that* bad, but close.
2016-02-04 03505, 2016
UmkaDK_
Guys, a bit of a random question but how would I go about working out what artists are updated by a replication packet?
2016-02-04 03530, 2016
ruaok
UmkaDK_: the last_updated field is your friend.
2016-02-04 03551, 2016
UmkaDK_
ok, thanks ruaok!
2016-02-04 03557, 2016
ruaok
np
2016-02-04 03525, 2016
ruaok
now mind you, that tells you what artist table rows have changed.
2016-02-04 03547, 2016
kartikgupta0909
alastairp: Yes I plan to
2016-02-04 03553, 2016
ruaok
the artist last_updated field does NOT get changed when any of the data that belongs to that artist has changed.
2016-02-04 03559, 2016
kartikgupta0909
rather planning my masters in this field
2016-02-04 03537, 2016
UmkaDK_
Hmm … ok, may be I've started at the wrong end …
2016-02-04 03501, 2016
alastairp
kartikgupta0909: perfect. Ask me any questions you have about the different schools. I did my masters at McGill, and I know about many of the other ones. Gentlecat is doing his masters here at UPF
2016-02-04 03530, 2016
UmkaDK_
what I'm trying to do is verify that our cache entities are getting invalidated when replication updates an artist.
2016-02-04 03507, 2016
UmkaDK_
So i figured the easiest way to do that would be to take any replication packet, find one of the artists it updates, and compare it before and after the replication is applied.
2016-02-04 03512, 2016
kartikgupta0909
alastairp: actually I am bound to do my masters here because I was enrolled in a Btech/Ms Dual degree, But I have liberty of working with people outside my college.
2016-02-04 03527, 2016
alastairp
right
2016-02-04 03555, 2016
darwin
in mysql row based replication, you could do that... dunno re postgres.
2016-02-04 03558, 2016
kartikgupta0909
I did send proffessor Xavier Serra a mail for an internship under him, but didnt get a reply
2016-02-04 03538, 2016
UmkaDK_
The bit that I can't seem to work out is how to find an artist gid from the replication
2016-02-04 03554, 2016
alastairp
ah. He did ask me if you were interested in working with the CompMusic project when I told him that you were working with AcousticBrainz
2016-02-04 03507, 2016
alastairp
perhaps he got too many emails :) it would have been nice to have had you here
2016-02-04 03527, 2016
kartikgupta0909
alastairp: I agree, he is one of the tobmost names in machine learning in Music. And so is Dr Tillman weyde
2016-02-04 03518, 2016
kartikgupta0909
*topmost
2016-02-04 03525, 2016
ruaok
UmkaDK_: replication is keyed off artist row id, since it is internal.
2016-02-04 03545, 2016
ruaok
lookup the GID (MBID) from the artist table
2016-02-04 03552, 2016
UmkaDK_
So, for a replication record that looks like this: 232270470 f "id"='171042' "artist"='1325999' "name"='五十嵐孝司'
2016-02-04 03510, 2016
UmkaDK_
(that's just the start of the record)
2016-02-04 03527, 2016
UmkaDK_
artist id would be 171042
2016-02-04 03545, 2016
yeeeargh has quit
2016-02-04 03516, 2016
UmkaDK_
and `SELECT name FROM artist WHERE id = '171042';` should return that artist's name, right?
2016-02-04 03547, 2016
opatel99 has quit
2016-02-04 03532, 2016
ruaok
in theory yes, but I dont have a DB to hand to check.
2016-02-04 03554, 2016
UmkaDK_
ok, no worries, I'm sure I'll work it out from here. Thanks again ruaok!
2016-02-04 03513, 2016
milomak joined the channel
2016-02-04 03529, 2016
kartikgupta0909 has quit
2016-02-04 03519, 2016
JonnyJD_ joined the channel
2016-02-04 03538, 2016
milomak
i am running debian and am having problems making unaccent in /opt/musicbrainz-server/postgresql-musicbrainz-unaccent
2016-02-04 03552, 2016
milomak
/usr/bin/install: will not overwrite just-created '/usr/share/postgresql/9.5/extension/musicbrainz_unaccent--1.0.0.sql' with 'sql/musicbrainz_unaccent--1.0.0.sql'
2016-02-04 03554, 2016
chirlu`
Sounds like the file is already there?
2016-02-04 03559, 2016
milomak
yes it is
2016-02-04 03512, 2016
milomak
but that happens when i run make install
2016-02-04 03554, 2016
chirlu`
I mean, the file seems to be in /usr/share/postgresql/9.5/extension already; i.e. it seems to be installed.
reosarevok: No ideas for a name I haven't uttered already. And yes, please do a PR yourself. I don't have any more rights to the meb.o repository than you do.
2016-02-04 03536, 2016
JonnyJD_ has quit
2016-02-04 03504, 2016
ruaok
Freso: that book will get published after you write it. :)
