New Music Database

Discussion in 'Listen Music' started by hwahrmann, September 27, 2007.

  1. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    rtv and me were working on a redesign of the music database over the last days.



    The old design was not flexible anymore and it resulted in to many joins to retrieve simple data.

    so we've decided to create a flat db style, with no normalisation.
    The result is of course a larger file, but this size is still less than an album ripped into mp3.

    The new design allows us to implement more things in th future.

    For the beginning you have now support for multiple artists, genres and albumartists.
    You could simply separate them by a semicolon (";") like WMP does.
    for example:
    U2;B.B. King

    the song / album will then appear for both artists.
    same goes for genre and album artists.

    There may be still some errors / incompatibilities´, which we will fix over the next days.

    needless to say, that a rescan of the shares is necessary.
    thx,

    Helmut
     
    • Like Like x 7
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. GoldenEye
    • Premium Supporter

    GoldenEye MP Donator

    Joined:
    October 26, 2005
    Messages:
    300
    Likes Received:
    21
    Location:
    Switzerland
    Ratings:
    +26 / 0
    Home Country:
    Switzerland Switzerland
    Show System Specs
    :D :D :D

    Thanks so much for this enhancement, which I was eagerly waiting for!

    G.
     
  4. zag2me

    zag2me Portal Pro

    Joined:
    April 11, 2006
    Messages:
    216
    Likes Received:
    35
    Ratings:
    +39 / 0
    Home Country:
    England England
    Great news about the re-design. How about making it flexible so that any fields can be created in the database by the user. So they could add their own tags like band, or composer.

    Also can other separators be recognised also? I know some other apps use the | to seperate multi items.

    I don't think the increased size is a problem at all.
     
  5. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    band (= albumartists) is already included
    composer is already delivered by the Tagreader, i just haven't added it to the db yet. simply forgot it

    the "|" is used as delimeter as well.

    Please be aware, that we're still facing some issues to display those multiple artists in the views.
    i hope we can fix that over the weekend.
     
  6. geov
    • Premium Supporter

    geov MP Donator

    Joined:
    November 1, 2006
    Messages:
    756
    Likes Received:
    38
    Gender:
    Male
    Occupation:
    Business & Solution Analyst
    Location:
    Cape Town
    Ratings:
    +38 / 0
    Home Country:
    South Africa South Africa
    Hi

    I dont know if the issue that I'm experiencing is related to your "artist view" problem but I had to roll back to the previous SVN. After rebuilding my database I'm seeing multiple album entries, its as if an album is displayed for every song. Usually when I'm in Album view I only see one album, now with the latest SVN I see multiple entries...
     
  7. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    already fixed it.
    is included in the next public svn build
     
  8. dicsv

    dicsv Portal Member

    Joined:
    August 7, 2007
    Messages:
    14
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Sweden Sweden
    With the new Database design, will it be possible to have Albums
    sorted by year for each artist. With the year listed in front of the album name.
    (and a YearIndex for multiple releases/year).
     
  9. geov
    • Premium Supporter

    geov MP Donator

    Joined:
    November 1, 2006
    Messages:
    756
    Likes Received:
    38
    Gender:
    Male
    Occupation:
    Business & Solution Analyst
    Location:
    Cape Town
    Ratings:
    +38 / 0
    Home Country:
    South Africa South Africa
    Thanks...
     
  10. Hawkeye

    Hawkeye Portal Pro

    Joined:
    January 29, 2005
    Messages:
    548
    Likes Received:
    60
    Gender:
    Male
    Occupation:
    digital media designer
    Location:
    Halle (Saale)
    Ratings:
    +89 / 1
    Home Country:
    Germany Germany
    Show System Specs
    Is this already implemented in yesterdays SVN (rev. 16049)? I ask because it adds the album (can see it in album view) but I cant see it in albumartist view... (example of albumartist/band: "Afrob|Samy Deluxe")
     
  11. wortelsoft

    wortelsoft Portal Pro

    Joined:
    May 13, 2005
    Messages:
    374
    Likes Received:
    1
    Location:
    Rotterdam, The Netherlands
    Ratings:
    +1 / 0
    Home Country:
    Netherlands Netherlands
    WoW! J
    Just tried it and the speed improvement is huge!
    Loading my playlist now took seconds instead of hanging MP for a minute.
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!