#musicbrainz

/

      • aliamo has quit
      • D4RK-PH0ENiX has quit
      • BCMM has quit
      • CallerNo6
        hi nelgin. what you're looking for is recordings.
      • D4RK-PH0ENiX joined the channel
      • JoeLlama joined the channel
      • Nyanko-sensei joined the channel
      • D4RK-PH0ENiX has quit
      • aliamo joined the channel
      • aliamo has quit
      • xplt has quit
      • Nyanko-sensei has quit
      • D4RK-PH0ENiX joined the channel
      • nelgin
        CallerNo6 oh ok. I'll revisit and take a look.
      • Tho I'm not sure I'm going to be able to easily get what I'm after. I'm trying to get the original release date of particuar songs. I guess I can parse through the results and get the easlist date.
      • Wizzup has quit
      • Wizzup joined the channel
      • balrog has quit
      • balrog joined the channel
      • CallerNo6
        nelgin, can you give more context? like, are you running sql queries against your local db? are you using the web service? are you working with already-tagged-with-MBID files?
      • pawalls joined the channel
      • you're right that recordings/tracks don't themselves have release dates. only the releases that they appear on have release dates.
      • and yes, you often need to filter the results on your end
      • Vacuity joined the channel
      • Vacuity_ has quit
      • Jinx has quit
      • pawalls has left the channel
      • Jinx joined the channel
      • jwf has quit
      • Slurpee has quit
      • Jybz joined the channel
      • Jybz has quit
      • Jybz joined the channel
      • nelgin
        No, I have no MBIDs. let's say I ripped a compilation CD and it only has the date the CD was released in the year, rather than the original release date of the song. So I have an artist and title only.
      • I want to tag the files with original release date rather than some arbitary date of a compilation release.
      • and maybe genre :)
      • Jybz has quit
      • Jybz joined the channel
      • CatQuest
        that sounds a bit like what I want with classical music - I want to tag the dateof composition on the music, not the release's date (so if it was composed in 1930, I want that as a date)
      • I feel like it should be possibleto do this witch picard.. atleast with a plugin made?
      • with*
      • reosarevok
        CatQuest: the composition date is easier, if we have a work linked you have it, if not you don't
      • There's the question of whether you'd want, say, arrangement date or original work date for arrangements, but still
      • Recordings is trickier just because there's a lot of unmerged ones. But I guess it depends what the original release of the song means, whether the first release of any version (so work) or the first release of *this* version...
      • JoeLlama has quit
      • aliamo joined the channel
      • aliamo has quit
      • nelgin
        I don't want to use a client because then it's going to make changes. I just want to write to a file so I can vet the results before applying them to the file.
      • Let's say the compilation album "Private Investigations" by Dire Straits has the song "Sultans of Swing" - I want to find the original release year of Sultans of Swing by Dire Straits (not by any other artist).
      • So all I really care about are artist and song title and I guess, I just shove those into a query and find all the years that come back, the earliest *should* be what I'm looking for? Maybe I could query the database directly but if the track doesn't have a date linked to it but it's linked to a release with a date, that is just more work. :)
      • reosarevok
        nelgin: what would you expect for a live version of Sultans of Swing? The year the song was originally released, or the year this live recording was originally released?
      • If the first, then yes, what you propose might be the simplest way :)
      • nelgin
        I'm trying not to think of live versions :) I actually don't have many so I can ignore those.
      • reosarevok
        (of course, we might be missing the original 10" vinyl release of some song from the 50s or whatever, so it's not completely certain to work - but then that also wouldn't work with any other way, if the data is missing :) )
      • nelgin
        True, so my Frank Sinatra stuff is screwed then :)
      • I thought this was going to be an easy task. Wish I had thought ahead when I ripped compilation stuff.
      • Jybz has quit
      • Jybz joined the channel
      • Khalifa joined the channel
      • Khalifa has quit
      • Jybz has quit
      • timbl joined the channel
      • timbl has quit
      • Jybz joined the channel
      • timbl joined the channel
      • shiv6146 joined the channel
      • D4RK-PH0ENiX has quit
      • BCMM joined the channel
      • shiv6146 has quit
      • D4RK-PH0ENiX joined the channel
      • G0re has quit
      • Gore|work joined the channel
      • aliamo joined the channel
      • Khalifa joined the channel
      • Lotheric has quit
      • Lotheric joined the channel
      • aliamo_ joined the channel
      • aliamo has quit
      • Khalifa_ joined the channel
      • Khalifa has quit
      • Khalifa_ has quit
      • Toast joined the channel
      • timbl has quit
      • Khalifa joined the channel
      • Khalifa has quit
      • timbl joined the channel
      • timbl has quit
      • I'm running bin/turn-port db but pgsql doesn't seem to listen on port 15432 - am I missing something?
      • vagrant@musicbrainz:~$ bin/turn-port db on
      • Starting musicbrainzdocker_db_1 ... done
      • vagrant@musicbrainz:~$ sudo netstat -anp|grep 15432
      • vagrant@musicbrainz:~$
      • antlarr
        I have a problem with a spanish release of https://musicbrainz.org/release/9f91e472-2618-4... I got my hands on
      • Track 4 in side A is supposed to be Axel F (also it's said that in the back cover), but once you hear it, it seems the vinyl pressing was wrong and you can hear like 10 seconds of the beginning of Axel F and suddenly it changes to Pulstar (which is track 5 in side B)
      • sorry, I meant a spanish release of https://musicbrainz.org/release/bd27905c-4eba-4...
      • and then, track 5 in side B is actually Axel F
      • Also, the tracks are correctly specified in the sticker on each side of the vinyl (except for the 10 seconds of Axel F)
      • When I add this release, I guess I should put the tracklist in the medium and just ignore the error, right? (maybe put it in the annotation field)
      • rdswift
        antlarr, sounds right to me. You should also include something in the edit note explaining what's happening.
      • nelgin
        The feckin' documentation is wrong on the webpage
      • antlarr
        rdswift: ok, thanks
      • reosarevok
        nelgin: where exactly? We could fix it (docs are a wiki anyway)
      • antlarr: well, those 10 seconds are... odd. It'd make it either a separate recording, or if Pulstar is there entirely, you could add a short track before it for those 10 seconds (that way the recording can still be reused)
      • antlarr
        the thing is... it's not a separate track, somehow they added those 10 seconds into the Pulstar track (and yes, Pulstar is complete)
      • reosarevok
        I mean, if it's a vinyl, are there really "tracks"? I thought vinyl tracks were a bit of an abstraction :)
      • nelgin
      • It says port is 15432 but it should be 5432
      • At least that's what works for me
      • yvanzo
        hi nelgin: it is 5432 within the guest but 15432 from the host
      • nelgin
        Anyone an expert with the backend database? given a song and artist, I want to pull back the year and album (if any) it was released on
      • antlarr
        reosarevok: hehe, well, let's say those 10 seconds are not separated from next song so I wouldn't count it as a separate "track" :) Also, if you count the number of tracks in the release, it would be odd to see one more (which is actually 10 seconds long)
      • nelgin
        Oh
      • It doesn't say that.
      • reosarevok
        antlarr: well, then it should probably be a separate recording, with an annotation and disambiguation
      • antlarr
        reosarevok: ok, I'll add the release then in the following days when I have some time to do it right
      • thanks for the clarification on how to do it
      • nelgin
        I need to get back to work, I'll check on an answer for my question shortly or I'll reask later.
      • yvanzo
        nelgin: it was intended to say that with “you can do this (from the host)” but phrasing improvements are welcome :)
      • reosarevok
        bitmap: I thought https://github.com/metabrainz/musicbrainz-serve... wasn't needed as an import anymore?
      • yvanzo
        nelgin: you should probably ask on #metabrainz (development channel) instead
      • reosarevok
        Oh, yea, wrong channel, was confused by the tech talk :D
      • yvanzo
      • timbl joined the channel
      • timbl has quit
      • timbl joined the channel
      • madmouser1 has quit
      • madmouser1 joined the channel
      • nelgin
        Ok cheers.
      • Jybz has quit
      • Jybz joined the channel
      • Khalifa joined the channel
      • Khalifa has quit
      • aliamo_ has quit
      • Khalifa joined the channel
      • Khalifa has quit
      • aliamo joined the channel
      • Jinx has quit
      • aliamo has quit
      • Jinx joined the channel
      • timbl has quit
      • Khalifa joined the channel
      • xplt joined the channel
      • aliamo joined the channel
      • aliamo has quit
      • aliamo joined the channel
      • bemeurer joined the channel
      • kieto joined the channel
      • Khalifa has quit
      • albertus1 joined the channel
      • SunsetSnakeEyes joined the channel