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?
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)
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 :)
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 :)