#musicbrainz-devel

zazi: most of the links can be read in both directions. e.g. artist performed vocal on recording. recording has vocals by artist.

zazi: but it is pointless to have both an l_artist_recording and an l_recording_artist in the database.

yes, they can always be read in both directions (I would say)

yeah, I know you just need them in one direction

zazi: so we picked l_artist_recording, because alphabetically artist comes first, so the l_artist_* tables were made first.

zazi: similarly l_url_work just happened to occur before l_work_url happened.

but it might be good (from my point of view) when the ordering might be consistent, i.e., entity to url

yeah, but url is somehow an alien concept re. your other music related concepts ;)

well, you can't say that for example entities linking to recording should always have recording as the second slot

so I would treat music related concepts always first

there just isn't that much logic which can be applied to it, you'll in most cases get conflicts. so someone just picked alphabetical.

hm

in any case it's too late to change it now unless you have a very good reason :)

fortunately, your url table includes gids ;)

well, I tried to explained my point of view ...

-ed

i.e. I'll model the relation from work (an entry of database/website) to url (something from an external information service)

... your database/website ...

zazi: you can't read the "l_x_y" tables as "from x to y"

they are really just "relation between x and y"

I know, I have the read them in both directions

must be hard coming from RDF where things are directional :)

however, I just have an issue with the constellation for work to url relations (i.e. how they stored in the table)

yeah, they are just consistently alphabetically ordered

if they weren't, the code you have to contain a lot of special cases

because this reflects another new case for, where I have to create another generic query for my test cases

nikki: awesome, thanks for testing :)

28618

Does this number seem accurate?

randomly picking some gids, I get stuff like http://musicbrainz.org/recording/a076dcf5-1d31-... so I think my query is accurate (off for review shortly)

maybe I should also make sure the recording has no relationships?

(this is just all recordings with no 'add standalone recording' or 'add track' edit in their history, and that appear on no tracklist)

what are orphaned recordings?

oh, /me should read first

recordings created by an add release edit that got voted down

at least that's what we're trying to clean up

well, try to filter by date too, just in case

which date? most seem to have null for last_updated

hrm, my own standalone recordings show up, query must be wrong :)

don't they have created data?

ah, they don't

nope

oh, there are 3 edit types. With the other add track edit type, the count is 6330

those l_url_work tables drive me nuts :P

didnt know you had them

VectorX: ?

nuts

just remembered an old joke

A pirate walks into a bar, and he's got a steering wheel sticking out of his pants. The bartender sees him and asks, "Hey, what's that steering wheel doing there?" The pirate says, "Aaarrrr, it's driving me nuts."

but I'm not a pirate today :P

sign

:P

well even if you were, i dont think you would fit the description anyway

gsus

im gonna go have some salted penuts

:)

ruaok: is the new macbook air worth the price then?

(not that I could pay for it right now, but still)

so far, yes!

the weight and the 7 hour promised battery time should make a drastic improvement over my macbook.

what's the difference between the macbook air and the macbook?

the air is really thin and has an SSD, no hard drive.

3 pounds is all it weighs.

and for as much as I travel, that is key.

long battery life for long flights and light to go anywhere.

so far: <3

I hate the evil empire

To be honest, I'm kinda annoyed with Apple at the moment

CD drive stuck, back light flickering, I've had to change the power cable, and this macbook is less than 3 years old

I want to get a new computer but I think I'll probably just sit here saying this until the macbook kicks the bucket, then just buy the cheapest mac laptop again >_<

but which one!? :P

(unless I magically find a job before the tragic day happens)

nikki: the cheapest one that can browse the internet

When it dies, repeat

and the ability to play videos properly again...

or I could connect a not so crappy laptop to a monitor and have even more space!

and yes, I do

nikki: you could buy a THIRD monitor for much less than the difference! :D

how would I plug two monitors into a laptop?

Probably some adapter or whatever

The Chinese make *everything*!

(except democratic progress and all that)

but still, I want to be able to use the laptop elsewhere :P

if I wanted a tiny screen I'd just use my phone for stuff :P

totally possible to plug two in, but the video card could easily be the limitation there

Not that the video cards in (at least "cheap") macbooks are too good either…

hm. now that I'm putting in a rate-of-change graph, {votes,edits} per {day,week} seem very silly

also they disagree

with the rates of change

only on older data, looks like, though

back when we could have non-monotonic vote counts

for whatever reason :P

ianmcorvidae: got link for your rate-of-change graphs?

yay, the VM is now catching up on replication.

ruaok: not right this second, I can give you one in a few minutes

sweet, that would nice.

okay, http://viriosus.ianmcorvidae.net:3000/statistic... I'm heading out to pick up Batsy at work

if it'll load for you in any reasonable time :P