#musicbrainz

+9000000001

ianweller_: in some cases, digital has a bonus track.

Plus, if I rip the CD I may end up with very very similar files

you could think of the downloadable version as a pre-ripped copy of the cd.

err, hawke_1

derwin: you must like making my irc client beep

:)

hawke_1: anyway, how i've always done it is have two releases in the same release group with basically the same exact info, except one is a CD and the other is digital media.

it comes with these benefits:

- for the CD, you can do the physical scan of the cover art, and for the digital release you can just upload what came with it.

ianweller_: only do that if the digital media version is available on its own, of course.

kepstin-work: yes.

Which it is.

- you can add the disc ID to the CD release and the digital media can be left aloe.

alone*

hmm, I guess then you think of the online store as offering a two-for-one deal where you get both the cd and the digital release together in a bundle?

yeah

i.e. the same thing as if a store shrinkwrapped a vinyl and a cd together and stuck a single pricetag on them?

The digital release even comes with art for what would be the disc itself (and presumably will be on the physical CD)

yeah, that happens a lot too.

Does that count as “medium”?

hard to say. i'd have to look at the page again

Well, in your opinion. :-)

hawke_1: I wouldn't say that's a medium. I suppose the idea is that you could burn the digital release to cd and print out a label for it?

i'd call it "other"

hawke_1: I'd just mark it other, yeah

the only time i would upload a "medium" art for a digital release is if i got it on a USB drive or something

and i (attempted to) scan the artwork on the side of it or whatnot

I have no idea what the idea is. if I had to guess I would say that it’s just for the sake of completeness.

you could turn the bytes of the zip file download into a bitmap image and call that the medium picture.

i.e. the artist had the artwork handy, why deprive people who bought the digital release?

jpg compression would corrupt it, tho ;)

kepstin-work: well, but if you converted the bits to an image, you would be distributing the music, not just the artwork

if you take a high-enough resolution image of a vinyl, you'd be distributing the music :)

so I guess downscale it.

i can't wait until artists distribute their music as input files for 3-D printers.

ianweller_: You’d be waiting a long time.

ianweller_: technically, you can convert pcm audio into instructions for carving a vinyl disc such that it could be played back in a record player to reproduce the music.

so, yeah.

what's the simplest way to get a release ASIN directly from the database?

roosoft: you have to go through the advanced relationships tables - see the bottom of http://musicbrainz.org/doc/MusicBrainz_Database...

i'm using l_release_url and I got an URL... do I have to extract ASIN from it?

in particular, you're looking for a release-url relationship named 'amazon asin'

yup... got this: "http://www.amazon.com/gp/product/B006M4RN3U"

i was wondering if there was a way to get B006M4RN3U directly

no, you have to extract the asin from the url.

okay thanks...

(it'll always be the string after the last '/')

do you think that most release groups include an ASIN in at least one of its releases^

?

roosoft: it's pretty likely, at least for larger artists.

how about release_meta.amazon_asin field?

interesting...

Jokipii: I don't see such a thing as a 'release_meta' table?

am I missing something

got it here

real*

huh. I guess that table must be used internally by the website, to optimize checks for cover art

got it!

1126264;"2012-02-19 15:34:50.768752+00";"http://www.amazon....;

well, it mentions that the cover art is absent, which is false... here it is: http://ecx.images-amazon.com/images/I/51dInddPi...

roosoft: I think the cover_art_presence refers to whether there's cover art at coverartarchive.org

okay! the cover art retrieval is getting simpler now...

yeah, I wonder why that table's not shown on the picture at http://musicbrainz.org/doc/MusicBrainz_Database...

those pictures are deliberately incomplete

very much so :/

they're designed to give you an overview, not a complete picture

oh well

if you want a complete picture, look at admin/sql/CreateTables.sql :)

:)

< kepstin-work> hmm, I guess then you think of the online store as offering a two-for-one deal where you get both the cd and the digital release together in a bundle?

+1

I wonder whether back+spine makes sense for a digital release, too.

I mean, it’s obviously artwork designed for a CD…but again, digital release → doesn’t have spine any more than it has a medium

well, 'back' probably still makes sense

dunno about spine :)

exactly.

I meant specifically the common “back+spine” that you get scanning the entire back sheet for a CD, or artwork intended for printing the same.

is it better to use acoustid or amplifind?

Anoia: given that amplifind is slow, unreliable, and is difficult to add new fingerprints to, we generally recommend acoustid :)

http://www.youtube.com/watch?v=VfbbSCFRsEE fannnntastic

kepstin-work: ok

a new install of picard seemed to defalt to amplifind

kepstin-work: sounded impressive to me on laptop speakers

I suppose I could plug in the decent headphones that I keep handy at all times.

warp: you can have a play with my synth when you're over

lots of lights :)

:D

Hmm, interesting…you can override front cover art immediately by putting it ahead of existing cover art, it seems.

hawke_1: that overrides the previous front even when the edit is still pending?

(and the old front isn't pending?)

looks like.

Well, that I’m not sure about

that sounds likely, yes.

it overrides the previous front even when the edit is pending, but I’m not sure if it remains so when the old front is accepted.

the ideal solution would be to use the frontiest accepted image if there is one; otherwise use the frontiest non-accepted image.

“frontiest” meaning the first one in the list that has the front attribute?

... "frontiest"

loool

it sounded better than 'frontest' to me, but either is acceptable.

It’s the technical term. :-)

I suppose that an image that has front in its list of types is 'fronty'

"this release has two fronty images, but the first one is the frontiest"

And the degree of frontiness is determined by where in the list it is. :-)

still a bit odd to have pending edits work like that

a reorder edit wouldn’t do that, for example

hawke_1: that's because the image position isn't changed until after the reorder edit passes, I suppose.

but when adding a new image, the position is set right away.

How does that work, anyway? (Given that the positions of the other ones presumably can’t be changed until the add edit passes either?

does the new one get position "1.1" or something?

the position numbers are all hidden internal detail

I know that…

as long as the order is correct, it doesn't matter if the numbers change

I’m just trying to figure out how it would work.

so it might just renumber everything right away to leave space for the new image.

1 2 3 → [new 1] 2 3 4 … cancel edit, positions are now just 2 3 4?

or we could look at the source code and know for sure - but really, who does that :)

people who don’t like to speculate of course!

is anyone using picrd 1.0 and has noticed locks while using the album list?

I;ve had it lock (no CPU) 3 times now when doing nothing much more than "selecting multiple albums"

I haven’t.

If I can pin it down, I'll submit a bug report

I hate vague "it crashes" reports :(

Anoia: what os, filesystem?

Windows 8, accessing a network share on a samba server

there was someone in earlier saying they were having issues with running picard on windows computers against a network filesystem.

hmmm

hmm.

0.16 didn;t seem to do it

sounds suspiciously similar.

I'll try and get a call stack next time

I'll boot up one of my windows boxes when I get home and give it a try, I guess.

I wonder why someone put their email address in the ID3 tag

Anoia: I used to do that, about 15 years ago.