[WiP] Centralised database in My Video, My Pictures and folder settings (2 Viewers)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    You can try it. The installer is attached to the 1st post.
    What is the difference from the previous one? Added a username and password? Changes in the configuration?

    I still can not make up my mind to go to this version, due to the fact that I have to clean fanarthandler database.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    What is the difference from the previous one?

    The old one was based on MP 1.10 Final, the new one based one 1.11 Pre Release.

    Added a username and password?

    Yes. Please read the 1st post. ;)

    Code:
      <section name="mpdatabase">
        <entry name="hostname">localhost</entry>
        <entry name="username">root</entry>
        <entry name="password">MediaPortal</entry>
      </section>
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    Yes. Please read the 1st post
    :whistle: Oh, went to read :D


    <entry name="username">root</entry>
    If another user is, what the right cut? Same as in Kodi?
    Code:
    Enter the following commands:
    * Type in: CREATE USER 'mediaportal' IDENTIFIED BY 'mediaportal'; and press return
    * Type in: GRANT ALL ON *.* TO 'mediaportal'; and press return
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    @regeszter
    Long lists the contents of the folder with movies about 2-3 times longer.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    @regeszter
    Long lists the contents of the folder with movies about 2-3 times longer.
    Yes, a service based database is slower than a file based like sqlite but there are many advantage. You can access, write(!) same tables at same time from clients without database corruption. The database server will handle the lock.

    You may go back the sqlite database and try a plugin based syncronisation. [emoji2]

    But I do not know if they can handle if you will use more than one client at same time.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    Yes, a service based database is slower than a file based like sqlite but there are many advantage.
    Interestingly though, Kodi access MySQL database on faster than locally, but not much faster. At least Raspberry Pi. He is there comparable to the speed of the media portal with a local database.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    How many files are in the folder where you see the differencing?
     

    Users who are viewing this thread

    Top Bottom