ocharles: I don't have any objections to moving git to github (you'd need to add a commit hook thingy to post to mb-commits of course :P) my problem was with the code review stuff, there doesn't seem to be any way of saying I want to get emails for that
SexyKen joined the channel
ianmcorvidae|alt joined the channel
djce joined the channel
plaintext joined the channel
stefans joined the channel
ijabz joined the channel
djinni` joined the channel
bitmap
is mb not loading for anyone else? I can't connect to the main site or rika
nikkimini
seems to load fine for me
bitmap
can't connect to jira or anything else either
guess I'll just wait
ijabz joined the channel
ianmcorvidae
bitmap: seems to be working for me too, yeah, though it's been a bit now
bitmap
it started working again a few minutes ago. very strange
ianmcorvidae
who knows
networks be crazy stuff, I guess :P
ijabz joined the channel
bitmap
ianmcorvidae: were you doing anything with multiselects still? 'cause I started writing my own jquery plugin for the instrument tree
ianmcorvidae
I haven't looked at it, no
bitmap
ah, okay
ianmcorvidae
I'd still like to improve that interaction, but I haven't done the research into alternatives to chosen
could someone help me a bit with postgres permissions?
luks
maybe, what's the problem?
plaintext
I don't have permission for the schema musicbrainz
I'm connected to the database "musicbrainz_db_static" with my user
ianmcorvidae
plaintext: oh, yeah, meant to tell you about that
you want to connect as user musicbrainz
plaintext
ooh
thanks!
night199uk
ahh lukz
lukz: is this an appropriate place to ask about picard?
luks
yep
night199uk
lukz: nice. did freso already ping you? i was asking in #musicbrainz the other day. i'm working on the musicbrainz support for XBMC.
plaintext
ianmcorvidae: one more problem: now I don't have permission for the table I have created earlier
luks
I'm not sure, I wasn't on irc for a few days
plaintext
should I just delete it, and add it again with the user musicbrainz?
night199uk
xbmc recently got a musicbrainz scraper. I've just rewritten a lot of support for xbmc so it can fully utilise MBIDs
for artist, album lookups, etc etc
ianmcorvidae
plaintext: possibly, if that won't take too much effort -- the other option is to just change the owner on it, presumably
night199uk
lukz: but right now, we scan the tags, insert the items into the db and then go look up all the artist metadata afterwads
plaintext
ianmcorvidae: thanks
night199uk
that would be very difficult to change on the xbmc side.
so today we don't have anything good to insert for the artists
ianmcorvidae
plaintext: but I don't know if you can change the owner without superuser permissions, so if it's not troublesome to just delete/recreate I'd do that
plaintext
it's just test data, so I can simply drop the table
ty
night199uk
lukz: cut a long story short, what i'm looking to know is if there would be any way picard would implement a tag to store the individual artist names
i.e. a 1:1 mapping with TXXX:MusicBrainzArtistID
luks
night199uk: I'm not sure, but I'd definitely not want that to be enabled by default
night199uk
an add-on might be okay
luks
I actually think that looking up the MBIDs in the application is a better solution
night199uk
yeah, i agree
and we do that
but the problem is the architecture is scan the MP3s and then go look up the data
there is no way I'm going to be able to change that in the short or medium term
which means right now we inject a bunch of artists named by their MBIDs
luks
is that a problem though?
night199uk
yes and no
we've not released the feature yet
it will go in shortly, maybe next week
ianmcorvidae
I guess it depends how much time there is between the scan and the lookup steps where someone might accidentally see the not-actually-correct name
night199uk
i'm trying to anticipate the support load. also we're debating the right way to insert these artists into our db.
some folks want to see us insert the artists with multiple artists named the same… i.e. for 'Mark Knopfler & Chet Atkins', we'd end up with 2 artists called 'Mark Knopfler & Chet Atkins' until we can scrape and download the correct data
right now we just inject the artists named by their id, so 'xxxxxxx-xxxx-xxxx' and then the users can easily see whats scraped or not
so at this point i'm just fact finding, i wanted to see if there was any appetite to do anything on the MB side
luks
well, I'd guess that you don't have this problem for over 99% of cases
because there is only one artist
night199uk
yeah, maybe
but i need special case code to detect that now
is this possible with an add-on today?
luks
even if we add this to tags in picard, all existing files will not have the new artist tags and people using other applications to tag their files will not have them either
night199uk
yeah, i know
luks
yes, it's possible to write a plugin for picard to add the extra tags
night199uk
but i guess picard would set the benchmark other taggers would follow
luks
but it would be complicated
night199uk
yer?
erk :-(
luks
for example, if you have two MBIDs and two artist names, how do you know which one is which?
night199uk
i guess i want something i can point people too if they are concerned about the behaviour
luks
you won't need to create some hacks like prefixing the artist names with theMBIDs
night199uk
well we'd order the tags in the same orer
we always retrieve the MP3 tags in order
luks
I'm not sure you can depend on that
many tagging applications do crazy things
night199uk
so MusicBrainzArtistID[0] == MusicBrainzArtistName[0], etc
luks
not to mention, id3v2.3, which is a must for any windows user, does not support multiple values per field
night199uk
well yes. I can only speak for xbmc, i can rely on that
indeed. how do you write multiple artist IDs for v2.3 though?
with the " / " separator?
luks
I think so, yes
night199uk
yeah, so then we can still rely on the order
xbmc already supports separating tags by the " / "
luks
what if there is an artist with / in the name?
night199uk
i'm just in the process of converting us to use tag lib now
yeah, thats why i'm migrating to tag lib so we have v2.4 support
i mean there is nothing 'perfect' with ID3 tagging :-)
thats what i've learnt from this process
but i'm trying to get a good general case
luks
yeah, which is why I'd suggest to not use something else
er, *to use
night199uk
?
luks
as I said, for most cases you have only one artist
so you can safely insert that
in the cases when you have multiple artist IDs, why not use the combined name until you look up the IDs?
tags are really not reliable and picard is not the only musicbrainz-enabled tagging application
night199uk
well thats the recommendation from some folks. but then we end up with 2 artists called e.g. 'Chet Atkins & Mark Knopfler'
luks
and you need to handle the case when the user doesn't have the tags anyway
night199uk
well yeah. i have to start somewhere though :-)
and yeah… but i'm trying to reduce the number of special cases
luks
well, by adding this, you are increasing the number :)
night199uk
if picard were willing to support this, then it'd be at least something i can point users to that complain about one of those two previous options
nah. if you were willing to add this i can just point users to upgrade picard and retag :-)
ianmcorvidae
probably an addon is the way, then, I'd say
luks
can't scan the file and only insert the ids into the db after you have looked them up?
I definitely do not want this in picard by default, because it solves a very specific problem that most poeple do not have
night199uk
luks: i will look at that over the longer term, but thats not the way its architected today
i can understand your case
okay, maybe i will look into an addon
you think an add-on for this would be complicated though?
i'm hoping we don't get too many complaints, i don't think users will notice if our scrapes work fine. but i just want to pre-empt the users that moan about it, i'm sure there will be some.
Leftmost joined the channel
luks
night199uk: I think the add-on should be pretty easy
kepstin-laptop joined the channel
night199uk
okay
thanks for looking
:-)
stefans joined the channel
plaintext
when looking up an mbid in the database, do I have to know what entity it is?
or is there an easier way than lookin in all possible tables (artist, release, etc)?
ocharles
you have to know the entity type
plaintext
oh
since we can't really tell by the splunk query, the script might have to look in all tables then
or we can pass some additional info in the YAML file, telling the script which table to look in