New Music Database (1 Viewer)

hwahrmann

Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    • Thread starter
    • Moderator
    • #1
    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
     

    GoldenEye

    MP Donator
  • Premium Supporter
  • October 26, 2005
    300
    26
    Switzerland
    Switzerland Switzerland
    Country flag
    rtv and me were working on a redesign of the music database over the last days.

    [...]

    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.
    :D :D :D

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

    G.
     

    zag2me

    Portal Pro
    April 11, 2006
    216
    68
    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.
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    • Thread starter
    • Moderator
    • #4
    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.
     

    geov

    MP Donator
  • Premium Supporter
  • November 1, 2006
    756
    38
    Cape Town
    South Africa South Africa
    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.
    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...
     

    dicsv

    Portal Member
    August 7, 2007
    14
    0
    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).
     

    Hawkeye

    Portal Pro
    January 29, 2005
    548
    87
    Halle (Saale)
    Germany Germany
    Country flag
    the "|" is used as delimeter as well.
    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")
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    globaldonkey Music Database Error Listen Music 1
    horned_reaper [solved] When playing music Fanart does not shuffle Fanart Handler 20
    horned_reaper [solved] When playing music Fanart does not appear immediately after downloading Fanart Handler 272
    horned_reaper [Music] 5012: Start current music track from the beginning Improvement Suggestions 21
    horned_reaper [solved] 5012: Restart current music track General Support 13
    atlantic How to use Spotify inside Mediaportal? Listen Music 18
    horned_reaper [solved] Music playback hangs General Support 58
    joecrow Music on Headphones Listen Music 7
    2BitSculptor MP 1.23.. music stops playing General Support 6
    Sarxas What Music Are You Listening To? OffTopic 0
    Edwardfc [solved] Mp 2.2.1 Configuration Issues - Goes to Sleep while playing Music General 6
    G [fixed] [MP2-786] Party Music Player can only play playlists with less than 1000 items 2.2 Archive 7
    KlausWirn Music crash Bass crash no change to play music Installation, configuration support 2
    BlueMax1916 [confirm] Music: Every 2nd track skipped MediaPortal 2 30
    N Music player help Listen Music 4
    N How to shuffle all my music, and how to sort by album artist General 4
    R MP 2.2 client spielt audio-titel kurz an und springt dann zum nächten Allgemeines Support- und Diskussionsforum 9
    joecrow Music: Fade Out not working 1.20 Pre Release 0
    M Music playback stops after certain files 1.19 0
    E [Pending] Handling Multifile Cue Submit: code patches (MediaPortal/TV-Server/etc.) 56
    X Music : WASAPI only plays one track then stops General Support 1
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    Similar threads

























    Top Bottom