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

[ajs]

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]

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.

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

 

[ajs]

Yes. Please read the 1st post

Oh, went to read

<entry name="username">root</entry>

If another user is, what the right cut? Same as in Kodi?

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

 

[regeszter]

If another user is, what the right cut? Same as in Kodi?

The root is a sample. You can use different user of course.

 

[ajs]

@regeszter
Long lists the contents of the folder with movies about 2-3 times longer.

 

[regeszter]

@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]

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]

Long lists the contents of the folder with movies about 2-3 times longer.

Do you use share view?

 

[ajs]

Do you use share view?

Yes.

 

[regeszter]

How many files are in the folder where you see the differencing?