#musicbrainz

/

      • matitaccia
        I have seen it's possible to bind it to tags, but I haven't suceeded in downloading it yet (from musicbrainz DB), otherwise there are other sites, I know.
      • docAdams
        there is a plugin you have to download first and some options to enable I think
      • matitaccia
        docAdams, thank you.
      • docAdams
        np
      • I made a bit of a mess, I have a 27-track compilation that is listed with only 20 tracks arranged alphabetically.
      • I fixed the track numbers and added the new tracks but got some sort of error.
      • I don't remember what it was but I added the release again separately. Anybody know what I should do?
      • matitaccia
        If I move the files to an other support will the pictures of webart be moved along?
      • *albumart
      • docAdams
        there is an option to move files matching an extension under file renaming or something like that
      • matitaccia
      • I had to manually change the artist tag via magic mp3 tagger because it was full of ?????????
      • and such. Now I get this as a result.
      • Lol.
      • Who knows what a standard mp3 player will ever read.
      • Jormangeud joined the channel
      • Milosz joined the channel
      • Milosz joined the channel
      • herojoker joined the channel
      • dinog joined the channel
      • STalKer-Y joined the channel
      • docAdams has left the channel
      • _Tsk_ joined the channel
      • v6lur joined the channel
      • ddaydj joined the channel
      • ddaydj joined the channel
      • _bibi joined the channel
      • arturo joined the channel
      • arturo
        Hi guys, I am doing some work on the NGS database...
      • Is there a place where I can find info on what each table is for? Wiki doesn't really say... (or I haven't found it)
      • nikki
        http://wiki.musicbrainz.org/Next_Generation_Schema is pretty much all we've got at the moment
      • feel free to ask in here though
      • arturo
        @nikki, yeah, I'm on that. Question: What does l_*_* tables *really* contain?
      • @nikki, is it to keep a history of the actual links?
      • nikki
        those are the actual links
      • so if I link an artist to their myspace page, there'll be a row in l_artist_url
      • arturo
        @nikki: or many? depending on the dates? (just making sure I'm getting it right)
      • nikki
        it should be just one row for each relationship
      • link points to the link table, which has the dates
      • and I'm not sure how attributes are linked right now
      • nikki has a look
      • arturo
        Mmm... I feel I'm lost with that l_*_* tables and the *link* table....
      • Jormangeud joined the channel
      • @nikki, ok, thx, will keep looking into that.
      • nikki isn't very good at explaining things :/
      • nikki
        the l_*_* ones are closest to what you see on the website, so when someone adds foo has an official homepage at foo.com, a row is added l_artist_url, when someone adds bar has an official homepage at bar.com another row is added to l_artist_url...
      • however, since they're both official homepage relationships with no dates set, there would only be one row in the link table, which would have link_type pointing to the official homepage relationship type and no dates set
      • but if someone then adds asdf has an official homepage at asdf.com until 2009 as a relationship, we get a new row in l_artist_url *and* a new row in the link table because this time one of the dates is set
      • arturo
        @nikki: O_O
      • @nikki: Ok, I see. Now, when I search, then I should always join through the link table I guess
      • @nikki: to get proper info.
      • nikki nods
      • @nikki: I'm staring at it hoping the knowledge will permeate through my skull...
      • nikki
        I usually find that the best way to understand it is to find an example I recognise and try selecting it from the database
      • arturo
        @nikki: yeah, I've mirrored it and i'm trying to get a hint of the actual data
      • nikki
        particularly the relationships... for a long time I ignored them because I couldn't be bothered to figure out how they worked :P
      • and now I have to learn how to select everything from the ngs database...
      • arturo
        @nikki, yeah, it feels a bit too much trying to put this info on a relational model. But *hey*
      • nikki wonders if luks is around
      • v6lur joined the channel
      • exit
      • arturo joined the channel
      • Hi again guys! Where can I find a sample hourly replication file for the NGS database?
      • KRSCuan joined the channel
      • G-Bleezy joined the channel
      • kurtjx joined the channel
      • chrisb joined the channel
      • ruaok joined the channel
      • Mineo joined the channel
      • murdos
        arturo: what would you do with this replication file?
      • nikki
        apparently he's doing stuff for the bbc so they're ready for ngs
      • and murdos, do you know if we have a ticket for adding relationships to all recordings/works on a release? I thought we did but I can't find one
      • murdos
        nikki: I don't think there's a ticket for that yet
      • but we need one ;)
      • nikki
        indeed!
      • STalKer-X joined the channel
      • v6lur joined the channel
      • Milosz joined the channel
      • Milosz joined the channel
      • nikki wonders if she can get the bitrate for mp3s in picard
      • outsidecontext joined the channel
      • KRSCuan
        What do you need it for, nikki? Just for naming files?
      • nikki
        yes
      • KRSCuan
        Looks like there isn't a Picard tag for that yet. But even then, writing a plugin should hopefully be trivial.
      • FauxFaux
        I just class anything that's mp3 as inferior and anything that's in ogg/vorbis or flac as superior. :)
      • KRSCuan
        The bitrate information is available to Picard after all
      • nikki
        I do too, FauxFaux
      • KRSCuan
        Most of my Vorbis files are encoded with 112bps, so most of them are probably worse than my mp3s.
      • Plus, I'd have to transcode them before they could be played on my Nokia.
      • FauxFaux really needs to bother transcoding stuff for portable players.
      • That's why I switched back to mp3s (and flac for stuff I really care for)
      • Also, Picard does some odd stuff to ogg files which makes (or made) them unusable in Amarok.
      • nikki
        my main problem with trying to switch to using only flac/ogg is stupid digital releases
      • KRSCuan
        Though this only happens when I embed cover art.
      • FauxFaux
        Sounds like a raisable bug in at least one of them.
      • KRSCuan
        I had that problem with Amarok 1.4, so I'd doubt their devs would care to fix it. If it was their fault in the first place.
      • Milosz joined the channel
      • Milosz joined the channel
      • outsidecontext has left the channel
      • luks
        KRSCuan: Amarok uses TagLib, which is maintained by me, and I'm supposed to be maintaining Picard, so filling a bug in either bug tracker is fine :)
      • KRSCuan
        I'll check whether it still affects current versions.
      • If an ogg file had an image embedded, Amarok couldn't read some of its tags, e.g. the track title.
      • If I tried to fill in the tags within Amarok, it would break the ogg file.
      • But I don't remember the details right now.
      • [1]matitaccia joined the channel
      • enjayhch joined the channel
      • ruaok joined the channel
      • caller_6 joined the channel
      • outsidecontext joined the channel
      • Milosz joined the channel
      • BurgessShale joined the channel
      • gekl joined the channel
      • ijabz joined the channel
      • Milosz joined the channel
      • Milosz joined the channel
      • tori joined the channel
      • praest76 joined the channel
      • PasNox joined the channel
      • matitaccia
        Hello everyone. I have a question: when you have a compilation with various artists how do you tag the artist field? As various artists or do you put the real artist?
      • luks
        use the real artist
      • xlotlu joined the channel
      • matitaccia
        luks, and then I end up having lots of artist having just one song or so.
      • luks
        is that a problem?
      • if you are using a tagger like Picard, you can set the artist field to VA
      • but in the MB database, it should be the real artist
      • matitaccia
        Oh, I have to introduce the fact that I'm not talking about the online DB. I'm trying to find the best solution for use on one ipod.
      • KRSCuan
        Whatever suits you best :)
      • luks
        doesn't it use the same concept of "Compilations" as iTunes?
      • KRSCuan
        But I have terrible experiences at least with the way iTunes handles compilations…
      • matitaccia
        Oh, lol. I'm not using itunes right now... I'll use it just to transfer the files.
      • Or... at least I would like to use it just for that. Lol.
      • luks
        maybe I remember it wrong, but I think it groups VA albums under Compilations, so you don't have artists from VA releases in the artist list
      • KRSCuan
        Does Picard set the compilation tag that iTunes uses?
      • matitaccia
        Yeah, I think this is the second option I have: to tag them all as VA and remember that under VA I have all the compitlations.
      • KRSCuan
        When I tried iTunes with my tagged files, it stumbled horribly over compilations like this: http://musicbrainz.org/release/cfa63f73-fdc4-49...
      • matitaccia
        fuckit.
      • luks
        KRSCuan: yes, everything with multiple artists should have the Compilation flag set
      • matitaccia
        luks, when I do that on Magic MP3 Tagger though, it will force me to rename files in his order which puts the album first. And I don't want that to happen.
      • luks
        I have no idea about Magic MP3 Tagger
      • I've never even seen it actually :)
      • matitaccia
        What do you use to tag? Something that keeps compilations files together? :-)
      • luks
        Picard, but I'm obviously biased :)
      • KRSCuan
        Hehe.
      • Muz joined the channel
      • matitaccia
        But picard permits to tag? I have used to get information from the web but to actually tag?
      • KRSCuan
        You can tag individual files by right-clicking them and selecting "Details".
      • Or you can modify the "New Metadata" on the right hand side of the window.
      • But for large amounts of files, Picard is cumbersome IMO,
      • Though its script support rocks.