Gentlecat: do you think we need schema changes for CB in order to improve the DB access?
MajorLurker has quit
reosarevok
alastairp: I know. I might, even, depending on whether I end up having an internship over the summer or not
alastairp
ruaok: I'm getting dmitry to review the content search proposal. plus that would be 7?
Gentlecat
no, I think schema is just fine
ruaok
that's what I thought too.
Gentlecat
it's the way the database accessed. it's a mess
ruaok
do you need me to chime in on that proposal at all?
ruaok nods
Gentlecat
partially my fault that I didn't notice it soon enough
alastairp
but that's 3 AB proposals. We'd need another mentor for AB
ruaok
we'll worry about the mentor/slot distribution later.
Gentlecat
sure, if you have something to comment on
alastairp
yeah, of course
Gentlecat
alastairp: I can try to help with something there
alastairp
đź‘Ť
Gentlecat
will probably be working on it during the summer anyway
would be nice to coordinate
alastairp
as ruaok says, let's see what happens on the 25th
Yo have 5 people working on ab over the summer would be amazing!!!!!!
To have
armalcolite has quit
ruaok
do we have some sort of penalty for cliches in proposals? :)
can you call pep8 a software requirement? :)
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
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?
reosarevok
ruaok: are you just salty because you got rickrolled?
chirlu
No, but it’s only an issue as long as someone insists on using the view.
ruaok
I'm not salty. I took a shower yesterday. :-p
chirlu
Execute the query directly, restricted to the areas that are of interest, and there is no issue.
reosarevok
Hmm. So it would not be a huge problem to display the containment for the relevant areas in WS results?
chirlu
Probably not (although everything making WS results larger could be problematic by itself).
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting [at 19 UTC] agenda: Reviews, MBS-8864 (zas)
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
(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)
adesh
where does Musicbrainz store data about events? in which relation? is it in "place"?
reosarevok
adesh: events have their own table
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.
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
You could answer at that guy from @AcousticBrainz like "you could come talk to us instead ;) " :p
alastairp
if the project is with c4dm, they'll be using sonic annotator
their framework for music analysis
"that guy" is chingwei, friend of musicbrainz and soundcloud guy
reosarevok
Heh
We have too many friends, I can't know them all! :)
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
alastairp
I suspect they've "just" run c4dm analysis tools over the audio
but it will be difficult to know if they've changed any of the algorithms
and so we're in the same position as MSD
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… :)
You know how musicbrainz IDs sometimes change/get removed?
reosarevok
No/yes :p
UmkaDK_
:D
reosarevok
(I guess I know what you mean with "change" though :p)
Go on :)
UmkaDK_
I mean change as in: they get removed :)
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.
reosarevok
UmkaDK_: Not only for an external client :(
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...
Hahaha! Awesome!! :D
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
Just the fact the MBID existed? The entity type too?
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.
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting [at 19 UTC] agenda: Reviews, MBS-8864 (zas), MBS-8380 (reo)
Jormangeud has quit
Jormangeud joined the channel
justharshal joined the channel
armalcolite joined the channel
Jormangeud has quit
Jormangeud joined the channel
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
that's why I don't like these huge monolithic test sql files
Gentlecat
hmm
adesh has quit
reosarevok
Do they *have* to be huge and monolithic?
Or is this a sign that we should be splitting them?
bitmap
reosarevok: re mbs-8380, it'd be easy to just add the tables, less so to populate it with old stuff
reosarevok
Table*s*? You mean you'd have one per entity type or?
(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)
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
bitmap
well,, you could probably just do with one table
Gentlecat
error message is not that helpful either :(
bitmap
paste?
we'd need some triggers to insert deleted stuff there too
maybe next schema change
the test sql doesn't have to be monolithic but it's very tedious to split at this point
since a lot of the rows reference eachother so you have to pick it apart by hand
