Gentlecat: do you think we need schema changes for CB in order to improve the DB access?
2016-03-22 08212, 2016
MajorLurker has quit
2016-03-22 08213, 2016
reosarevok
alastairp: I know. I might, even, depending on whether I end up having an internship over the summer or not
2016-03-22 08226, 2016
alastairp
ruaok: I'm getting dmitry to review the content search proposal. plus that would be 7?
2016-03-22 08226, 2016
Gentlecat
no, I think schema is just fine
2016-03-22 08238, 2016
ruaok
that's what I thought too.
2016-03-22 08243, 2016
Gentlecat
it's the way the database accessed. it's a mess
2016-03-22 08248, 2016
ruaok
do you need me to chime in on that proposal at all?
2016-03-22 08251, 2016
ruaok nods
2016-03-22 08257, 2016
Gentlecat
partially my fault that I didn't notice it soon enough
2016-03-22 08257, 2016
alastairp
but that's 3 AB proposals. We'd need another mentor for AB
2016-03-22 08220, 2016
ruaok
we'll worry about the mentor/slot distribution later.
2016-03-22 08225, 2016
Gentlecat
sure, if you have something to comment on
2016-03-22 08227, 2016
alastairp
yeah, of course
2016-03-22 08247, 2016
Gentlecat
alastairp: I can try to help with something there
2016-03-22 08259, 2016
alastairp
đź‘Ť
2016-03-22 08202, 2016
Gentlecat
will probably be working on it during the summer anyway
2016-03-22 08207, 2016
Gentlecat
would be nice to coordinate
2016-03-22 08209, 2016
alastairp
as ruaok says, let's see what happens on the 25th
2016-03-22 08200, 2016
alastairp
Yo have 5 people working on ab over the summer would be amazing!!!!!!
2016-03-22 08204, 2016
alastairp
To have
2016-03-22 08217, 2016
armalcolite has quit
2016-03-22 08216, 2016
ruaok
do we have some sort of penalty for cliches in proposals? :)
2016-03-22 08258, 2016
ruaok
can you call pep8 a software requirement? :)
2016-03-22 08233, 2016
Mike_Aiir
sweet that fixed it, cron appears to be working correctly now, just getting messages saying can't download the packets but assuming that's because i'm already up to date
2016-03-22 08242, 2016
chirlu
[21:02:06] <reosarevok> bitmap: while I'm on the "probably repeated questions" topic, does the PG 9.5 thing help us at all wrt area containment queries and the ws?
2016-03-22 08204, 2016
reosarevok
ruaok: are you just salty because you got rickrolled?
2016-03-22 08216, 2016
chirlu
No, but it’s only an issue as long as someone insists on using the view.
2016-03-22 08231, 2016
ruaok
I'm not salty. I took a shower yesterday. :-p
2016-03-22 08249, 2016
chirlu
Execute the query directly, restricted to the areas that are of interest, and there is no issue.
2016-03-22 08223, 2016
reosarevok
Hmm. So it would not be a huge problem to display the containment for the relevant areas in WS results?
2016-03-22 08245, 2016
chirlu
Probably not (although everything making WS results larger could be problematic by itself).
2016-03-22 08214, 2016
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting [at 19 UTC] agenda: Reviews, MBS-8864 (zas)
2016-03-22 08200, 2016
reosarevok
Are we talking "serious chances of being problematic by itself" or "well, I guess if we pile a lot of these things it might be bad"? :p
2016-03-22 08239, 2016
reosarevok
(if the latter, I'd still want to go for this one because there's no great way to get them otherwise, but it could be a separate include so that it's only added when people actually require it)
2016-03-22 08255, 2016
adesh
where does Musicbrainz store data about events? in which relation? is it in "place"?
2016-03-22 08217, 2016
reosarevok
adesh: events have their own table
2016-03-22 08248, 2016
reosarevok
Where they took place is stored with a relationship, that'd be l_event_place (or l_area_event if only the city is known)
Omnifone also launches an innovative Music Information Retrieval platform, the Acoustic Lab, which promotes the analysis of the DNA of a digital music track, creating a library of audio and musical features that provide unique metadata sets. Omnifone offers customers the world leading audio analysis services, which scan across its 55 million track catalogue.
2016-03-22 08238, 2016
alastairp
The Acoustic Lab can be used to enrich a customer’s end user engagement by providing unique service functionality. The Acoustic Lab is partnered with Queen Mary University London’s Centre for Digital Music, and provides a unique source of music-based research information for academia.
Well I assume it is closed, it's a B2B and blah blah blah industry babble company :p
2016-03-22 08215, 2016
reosarevok
You could answer at that guy from @AcousticBrainz like "you could come talk to us instead ;) " :p
2016-03-22 08231, 2016
alastairp
if the project is with c4dm, they'll be using sonic annotator
2016-03-22 08242, 2016
alastairp
their framework for music analysis
2016-03-22 08200, 2016
alastairp
"that guy" is chingwei, friend of musicbrainz and soundcloud guy
2016-03-22 08232, 2016
reosarevok
Heh
2016-03-22 08240, 2016
reosarevok
We have too many friends, I can't know them all! :)
2016-03-22 08232, 2016
reosarevok
It's a shame Twitter didn't add a "Haha" reaction like FB, or I'd Haha the "sales" reply from the MB account :p
2016-03-22 08216, 2016
alastairp
I suspect they've "just" run c4dm analysis tools over the audio
2016-03-22 08230, 2016
alastairp
but it will be difficult to know if they've changed any of the algorithms
2016-03-22 08236, 2016
alastairp
and so we're in the same position as MSD
2016-03-22 08227, 2016
UmkaDK_
Guys, I've just had a very interesting conversation with the powers that be, which ended with: Could you find out if they could fix it? So, here is me finding out… :)
2016-03-22 08242, 2016
UmkaDK_
You know how musicbrainz IDs sometimes change/get removed?
2016-03-22 08251, 2016
reosarevok
No/yes :p
2016-03-22 08258, 2016
UmkaDK_
:D
2016-03-22 08220, 2016
reosarevok
(I guess I know what you mean with "change" though :p)
2016-03-22 08223, 2016
reosarevok
Go on :)
2016-03-22 08232, 2016
UmkaDK_
I mean change as in: they get removed :)
2016-03-22 08244, 2016
UmkaDK_
well, it appears that for an external client there is no way to differentiate between an ID that was never used and an ID that used but removed.
2016-03-22 08201, 2016
reosarevok
UmkaDK_: Not only for an external client :(
2016-03-22 08238, 2016
UmkaDK_
this leads to quite a few dead-end urls on google (for example) which end in 404
Just an idea but how about I add an "improvement" issue and you leave a few comments on that … and I'll cross-link it into our tracking system...
2016-03-22 08202, 2016
UmkaDK_
Hahaha! Awesome!! :D
2016-03-22 08243, 2016
reosarevok
Knowing someone has a direct, requested use of this should make it more interesting to work on... I wonder what we'd want to store in that table
2016-03-22 08256, 2016
reosarevok
Just the fact the MBID existed? The entity type too?
2016-03-22 08220, 2016
UmkaDK_
Ok, I've cross-referenced that ticket on our system, so it will get seen. But if at any point you want me to highlight something, ping me and I'll make it bold, red and flashing.
2016-03-22 08251, 2016
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting [at 19 UTC] agenda: Reviews, MBS-8864 (zas), MBS-8380 (reo)
2016-03-22 08240, 2016
Jormangeud has quit
2016-03-22 08222, 2016
Jormangeud joined the channel
2016-03-22 08230, 2016
justharshal joined the channel
2016-03-22 08251, 2016
armalcolite joined the channel
2016-03-22 08238, 2016
Jormangeud has quit
2016-03-22 08230, 2016
Jormangeud joined the channel
2016-03-22 08209, 2016
bitmap
Gentlecat: that stuff's broken :( and we've made tons of manual changes to webservice.sql for years so it's hardly automatically generated
2016-03-22 08237, 2016
bitmap
that's why I don't like these huge monolithic test sql files
2016-03-22 08254, 2016
Gentlecat
hmm
2016-03-22 08204, 2016
adesh has quit
2016-03-22 08225, 2016
reosarevok
Do they *have* to be huge and monolithic?
2016-03-22 08232, 2016
reosarevok
Or is this a sign that we should be splitting them?
2016-03-22 08214, 2016
bitmap
reosarevok: re mbs-8380, it'd be easy to just add the tables, less so to populate it with old stuff
2016-03-22 08240, 2016
reosarevok
Table*s*? You mean you'd have one per entity type or?
2016-03-22 08206, 2016
reosarevok
(I had thought of just one table because then we can fish for old MBIDs and add them all there without having to worry *what* they were, but dunno)
2016-03-22 08218, 2016
Gentlecat
the problem is that I'm trying to run these tests and it fails on one of those queries, but I'm not sure which one exactly
2016-03-22 08220, 2016
bitmap
well,, you could probably just do with one table
2016-03-22 08231, 2016
Gentlecat
error message is not that helpful either :(
2016-03-22 08251, 2016
bitmap
paste?
2016-03-22 08220, 2016
bitmap
we'd need some triggers to insert deleted stuff there too
2016-03-22 08243, 2016
bitmap
maybe next schema change
2016-03-22 08200, 2016
bitmap
the test sql doesn't have to be monolithic but it's very tedious to split at this point
2016-03-22 08236, 2016
bitmap
since a lot of the rows reference eachother so you have to pick it apart by hand
