Database: Refactor MP1 database for multi seat usage (4 Viewers)

Anthony Vaughan

MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    Anyone who likes Gary Moore can't be all bad :) . I first saw him when he played with Thin Lizzie.

    I've a question about the actor table. I found the following in the supplied database:

    14075 Пётр Фёдоров nm7487818
    18179 Пётр Фёдоров nm1215228

    I see that there are two IMDBActorIDs. Is this the same actor or are they two different actors. Should the combination of actor name and IMDBActorID be unique?
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    I see that there are two IMDBActorIDs. Is this the same actor or are they two different actors. Should the combination of actor name and IMDBActorID be unique?
    These are different actors. There could be as many as 100 or more such actors. They may have different patronymics, or they may have the same patronymics. But the IMDBIDs will be different.

    It's the same for movie titles, they can be the same but the IMDBID is different. I've seen movies with the same title released in the same year. IMDB used to add /I, /II, /III etc. to their search. But grabber always ignored it and left only the title.
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    It's the same for movie titles, they can be the same but the IMDBID is different. I've seen movies with the same title released in the same year. IMDB used to add /I, /II, /III etc. to their search. But grabber always ignored it and left only the title.
    Good to know that. Not obvious otherwise.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    IMDBActorID the real key
    It's not that simple. In an ideal world, yes. But in the real world, IMDBID can be empty.
    IMDBID is a Unique key, but it can be empty and there can be many such empty entries. It depends on the grabber.
    Actor Title - I don't remember an occasion when this was blank.
    Actor Title + IMDBID - more like a unique key, but I'm afraid there may be variations.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    Why did I say it was so easy with the Movies database, and why saving the IMDBUrl from the grabber and trying to get information from it afterwards is a bad idea. :) :whistle: :coffee:
     

    Anthony Vaughan

    MP Donator
  • Premium Supporter
  • June 25, 2015
    474
    234
    Home Country
    United Kingdom United Kingdom
    It's not that simple. In an ideal world, yes. But in the real world, IMDBID can be empty.
    IMDBID is a Unique key, but it can be empty and there can be many such empty entries. It depends on the grabber.
    Actor Title - I don't remember an occasion when this was blank.
    Actor Title + IMDBID - more like a unique key, but I'm afraid there may be variations.
    Yes. I seem to remember seeing IMDBActorID being blank (unknown). But I've never seen the actor name being blank.

    So, I'll start out with the combination of actor name and IMDB as unique key and see if we get any exceptions.

    Why did I say it was so easy with the Movies database, and why saving the IMDBUrl from the grabber and trying to get information from it afterwards is a bad idea. :) :whistle: :coffee:
    Yes, but the IMDBUrl option for scanning is only an option available when it works - the IMDBUrl is valid. Otherwise the app defaults to the standard (i.e. the time-honored) way of doing scans.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    14,138
    8,690
    Kyiv
    Home Country
    Ukraine Ukraine
    Yes, but the IMDBUrl option for scanning is only an option available when it works - the IMDBUrl is valid.
    How do you check it? And why keep it when we have an IMDBID in the database - it's almost 100% guaranteed accurate identification of the film, IMDBURL is just unnecessary information that will clutter the database.
     

    Users who are viewing this thread

    Similar threads

    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes, there will be many things. Main reason is simply, that MP2 is not developed based on MP1. I for example never used MP1. I tried it lately to test voice control and was shocked about many inconsistancies in...
    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes...
    It´s been a while... :) Well, simply the reason is cause MP1 was working so well... :) Now I decided to upgrade my old servers and...
    Replies
    1
    Views
    242
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something stuck, it will try again on next server start and probably stuck again. But removing the media source also removes the associated queue. The server's TV plugin automatically creates the media sources for...
    Ok, the importer also remembers the queue of items that are still needed to be processed in settings file. If there is something...
    Hi, I’ve been struggling with MP 2 now for several weeks. Initially all was fine. Then in the client, the listings of recorded TV...
    Replies
    8
    Views
    911
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me over the edge for sure.;)
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me...
    We are proud to present MediaPortal 2.3 MediaPortal 2.3 is a full-blown media center software that addresses the most common user...
    Replies
    4
    Views
    3K
    MP1 MP2 MP2 DLNA status? DE
    What I meant is that we have a MP2 plugin called UPnP Render that can play media from DLNA servers if I remember correctly. I don't know the current state of the plugin though. That's why MP2 probably never will be certified. ;) Yes, that was also the idea, but it is a big job as all TV's, software etc. seems to not do everything...
    What I meant is that we have a MP2 plugin called UPnP Render that can play media from DLNA servers if I remember correctly. I don't...
    So I'm wondering what the state of play is with MP2 and DLNA functionality? When I started this post, I did see some posts...
    Replies
    10
    Views
    1K
    Thank you joecrow! It seems to resolve the problem I got since 1.22.
    Thank you joecrow! It seems to resolve the problem I got since 1.22.
    Hi Guys, Most times I have had an issue with MP1 it has been a platform/OS/finger-trouble issue that a re-install etc fixes...
    Replies
    9
    Views
    984
    Top Bottom