#musicbrainz-devel

/

      • VectorX joined the channel
      • 2011-07-21 20204, 2011

      • warp
        zazi: most of the links can be read in both directions. e.g. artist performed vocal on recording. recording has vocals by artist.
      • 2011-07-21 20229, 2011

      • warp
        zazi: but it is pointless to have both an l_artist_recording and an l_recording_artist in the database.
      • 2011-07-21 20230, 2011

      • zazi
        yes, they can always be read in both directions (I would say)
      • 2011-07-21 20200, 2011

      • zazi
        yeah, I know you just need them in one direction
      • 2011-07-21 20206, 2011

      • warp
        zazi: so we picked l_artist_recording, because alphabetically artist comes first, so the l_artist_* tables were made first.
      • 2011-07-21 20227, 2011

      • warp
        zazi: similarly l_url_work just happened to occur before l_work_url happened.
      • 2011-07-21 20234, 2011

      • zazi
        but it might be good (from my point of view) when the ordering might be consistent, i.e., entity to url
      • 2011-07-21 20238, 2011

      • zazi
        yeah, but url is somehow an alien concept re. your other music related concepts ;)
      • 2011-07-21 20245, 2011

      • warp
        well, you can't say that for example entities linking to recording should always have recording as the second slot
      • 2011-07-21 20205, 2011

      • zazi
        so I would treat music related concepts always first
      • 2011-07-21 20251, 2011

      • warp
        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.
      • 2011-07-21 20209, 2011

      • zazi
        hm
      • 2011-07-21 20229, 2011

      • warp
        in any case it's too late to change it now unless you have a very good reason :)
      • 2011-07-21 20231, 2011

      • zazi
        fortunately, your url table includes gids ;)
      • 2011-07-21 20249, 2011

      • zazi
        well, I tried to explained my point of view ...
      • 2011-07-21 20207, 2011

      • zazi
        -ed
      • 2011-07-21 20230, 2011

      • zazi
        i.e. I'll model the relation from work (an entry of database/website) to url (something from an external information service)
      • 2011-07-21 20214, 2011

      • zazi
        ... your database/website ...
      • 2011-07-21 20203, 2011

      • ianmcorvidae joined the channel
      • 2011-07-21 20244, 2011

      • luks
        zazi: you can't read the "l_x_y" tables as "from x to y"
      • 2011-07-21 20218, 2011

      • luks
        they are really just "relation between x and y"
      • 2011-07-21 20221, 2011

      • zazi
        I know, I have the read them in both directions
      • 2011-07-21 20203, 2011

      • luks
        must be hard coming from RDF where things are directional :)
      • 2011-07-21 20205, 2011

      • zazi
        however, I just have an issue with the constellation for work to url relations (i.e. how they stored in the table)
      • 2011-07-21 20226, 2011

      • luks
        yeah, they are just consistently alphabetically ordered
      • 2011-07-21 20241, 2011

      • luks
        if they weren't, the code you have to contain a lot of special cases
      • 2011-07-21 20256, 2011

      • zazi
        because this reflects another new case for, where I have to create another generic query for my test cases
      • 2011-07-21 20239, 2011

      • bitmap
        nikki: awesome, thanks for testing :)
      • 2011-07-21 20226, 2011

      • ocharles
        28618
      • 2011-07-21 20231, 2011

      • ocharles
        Does this number seem accurate?
      • 2011-07-21 20249, 2011

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

      • ocharles
        maybe I should also make sure the recording has no relationships?
      • 2011-07-21 20233, 2011

      • ocharles
        (this is just all recordings with no 'add standalone recording' or 'add track' edit in their history, and that appear on no tracklist)
      • 2011-07-21 20217, 2011

      • luks
        what are orphaned recordings?
      • 2011-07-21 20230, 2011

      • luks
        oh, /me should read first
      • 2011-07-21 20239, 2011

      • ocharles
        recordings created by an add release edit that got voted down
      • 2011-07-21 20243, 2011

      • ocharles
        at least that's what we're trying to clean up
      • 2011-07-21 20217, 2011

      • luks
        well, try to filter by date too, just in case
      • 2011-07-21 20237, 2011

      • ocharles
        which date? most seem to have null for last_updated
      • 2011-07-21 20250, 2011

      • ocharles
        hrm, my own standalone recordings show up, query must be wrong :)
      • 2011-07-21 20258, 2011

      • luks
        don't they have created data?
      • 2011-07-21 20217, 2011

      • luks
        ah, they don't
      • 2011-07-21 20221, 2011

      • ocharles
        nope
      • 2011-07-21 20229, 2011

      • ocharles
        oh, there are 3 edit types. With the other add track edit type, the count is 6330
      • 2011-07-21 20206, 2011

      • voiceinsideyou joined the channel
      • 2011-07-21 20224, 2011

      • voiceinsideyou1 joined the channel
      • 2011-07-21 20200, 2011

      • nikki
        those l_url_work tables drive me nuts :P
      • 2011-07-21 20222, 2011

      • VectorX
        didnt know you had them
      • 2011-07-21 20225, 2011

      • nikki already made a view for l_work_url
      • 2011-07-21 20258, 2011

      • voiceinsideyou joined the channel
      • 2011-07-21 20258, 2011

      • nikki
        VectorX: ?
      • 2011-07-21 20202, 2011

      • VectorX
        nuts
      • 2011-07-21 20223, 2011

      • nikki did not say 'my'
      • 2011-07-21 20204, 2011

      • VectorX
        just remembered an old joke
      • 2011-07-21 20210, 2011

      • VectorX
        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."
      • 2011-07-21 20227, 2011

      • nikki knows it
      • 2011-07-21 20237, 2011

      • nikki
        but I'm not a pirate today :P
      • 2011-07-21 20246, 2011

      • VectorX
        sign
      • 2011-07-21 20251, 2011

      • nikki
        :P
      • 2011-07-21 20210, 2011

      • VectorX
        well even if you were, i dont think you would fit the description anyway
      • 2011-07-21 20221, 2011

      • nikki does technically have nuts.... hazelnuts :P
      • 2011-07-21 20227, 2011

      • VectorX
        gsus
      • 2011-07-21 20253, 2011

      • VectorX
        im gonna go have some salted penuts
      • 2011-07-21 20220, 2011

      • outsidecontext joined the channel
      • 2011-07-21 20235, 2011

      • ruaok joined the channel
      • 2011-07-21 20202, 2011

      • reosarevok joined the channel
      • 2011-07-21 20207, 2011

      • ruaok joined the channel
      • 2011-07-21 20240, 2011

      • ruaok continues to work on a new VM
      • 2011-07-21 20250, 2011

      • reosarevok
        :)
      • 2011-07-21 20249, 2011

      • reosarevok
        ruaok: is the new macbook air worth the price then?
      • 2011-07-21 20255, 2011

      • reosarevok
        (not that I could pay for it right now, but still)
      • 2011-07-21 20200, 2011

      • ruaok
        so far, yes!
      • 2011-07-21 20217, 2011

      • ruaok
        the weight and the 7 hour promised battery time should make a drastic improvement over my macbook.
      • 2011-07-21 20210, 2011

      • nikki
        what's the difference between the macbook air and the macbook?
      • 2011-07-21 20217, 2011

      • nikki read something about the macbook vanishing
      • 2011-07-21 20242, 2011

      • ruaok
        the air is really thin and has an SSD, no hard drive.
      • 2011-07-21 20247, 2011

      • ruaok
        3 pounds is all it weighs.
      • 2011-07-21 20256, 2011

      • ruaok
        and for as much as I travel, that is key.
      • 2011-07-21 20206, 2011

      • ruaok
        long battery life for long flights and light to go anywhere.
      • 2011-07-21 20209, 2011

      • ruaok
        so far: <3
      • 2011-07-21 20231, 2011

      • MBChatLogger
        I hate the evil empire
      • 2011-07-21 20231, 2011

      • reosarevok
        To be honest, I'm kinda annoyed with Apple at the moment
      • 2011-07-21 20250, 2011

      • reosarevok
        CD drive stuck, back light flickering, I've had to change the power cable, and this macbook is less than 3 years old
      • 2011-07-21 20236, 2011

      • nikki
        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 >_<
      • 2011-07-21 20201, 2011

      • nikki is too indecisive
      • 2011-07-21 20215, 2011

      • reosarevok thinks he will do the same, except that he will import a 150€ netbook from Taiwan
      • 2011-07-21 20226, 2011

      • nikki
        but which one!? :P
      • 2011-07-21 20231, 2011

      • reosarevok
        (unless I magically find a job before the tragic day happens)
      • 2011-07-21 20242, 2011

      • reosarevok
        nikki: the cheapest one that can browse the internet
      • 2011-07-21 20254, 2011

      • reosarevok
        When it dies, repeat
      • 2011-07-21 20204, 2011

      • nikki is more ambitious and wants plenty of screen space
      • 2011-07-21 20214, 2011

      • nikki
        and the ability to play videos properly again...
      • 2011-07-21 20218, 2011

      • ianmcorvidae needs to purchase a new monitor at some point here
      • 2011-07-21 20226, 2011

      • reosarevok
        nikki could connect the crappy netbook to a monitor
      • 2011-07-21 20234, 2011

      • reosarevok thought she did that with the macbook anyway
      • 2011-07-21 20244, 2011

      • nikki
        or I could connect a not so crappy laptop to a monitor and have even more space!
      • 2011-07-21 20254, 2011

      • nikki
        and yes, I do
      • 2011-07-21 20212, 2011

      • reosarevok
        nikki: you could buy a THIRD monitor for much less than the difference! :D
      • 2011-07-21 20225, 2011

      • nikki
        how would I plug two monitors into a laptop?
      • 2011-07-21 20233, 2011

      • reosarevok is sure there's a way
      • 2011-07-21 20240, 2011

      • reosarevok
        Probably some adapter or whatever
      • 2011-07-21 20247, 2011

      • reosarevok
        The Chinese make *everything*!
      • 2011-07-21 20223, 2011

      • reosarevok
        (except democratic progress and all that)
      • 2011-07-21 20238, 2011

      • nikki
        but still, I want to be able to use the laptop elsewhere :P
      • 2011-07-21 20247, 2011

      • nikki
        if I wanted a tiny screen I'd just use my phone for stuff :P
      • 2011-07-21 20207, 2011

      • reosarevok does, but the difference for IRC and MB and a couple more things is kinda big between 3" and 9" :p
      • 2011-07-21 20219, 2011

      • ianmcorvidae
        totally possible to plug two in, but the video card could easily be the limitation there
      • 2011-07-21 20257, 2011

      • reosarevok
        Not that the video cards in (at least "cheap") macbooks are too good either…
      • 2011-07-21 20246, 2011

      • warp joined the channel
      • 2011-07-21 20258, 2011

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

      • ianmcorvidae
        also they disagree
      • 2011-07-21 20221, 2011

      • ianmcorvidae
        with the rates of change
      • 2011-07-21 20259, 2011

      • ianmcorvidae
        only on older data, looks like, though
      • 2011-07-21 20213, 2011

      • ianmcorvidae
        back when we could have non-monotonic vote counts
      • 2011-07-21 20221, 2011

      • ianmcorvidae
        for whatever reason :P
      • 2011-07-21 20235, 2011

      • ruaok
        ianmcorvidae: got link for your rate-of-change graphs?
      • 2011-07-21 20248, 2011

      • ruaok
        yay, the VM is now catching up on replication.
      • 2011-07-21 20204, 2011

      • ianmcorvidae
        ruaok: not right this second, I can give you one in a few minutes
      • 2011-07-21 20218, 2011

      • ruaok
        sweet, that would nice.
      • 2011-07-21 20200, 2011

      • ianmcorvidae watches it be super-duper slow as I try to make sure my SSH tunnel works
      • 2011-07-21 20221, 2011

      • ianmcorvidae
        okay, http://viriosus.ianmcorvidae.net:3000/statistics/… I'm heading out to pick up Batsy at work
      • 2011-07-21 20202, 2011

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