Database configurable (1 Viewer)

[Nightmare77]

Wondering if its possible to have the database location a configurable option in the configuration.exe , so normally the databases are stored in \Media Portal\database folder, it would be kind of handy if possible to set a different location so you could have them say set to a network location on a server, so that all the clients point to the same location, that way they share the same music database, movies and radio.
What do you think?

 

[scythelt]

I don't think SQlite is thread-safe or meant for concurrent access to databases, so if you pointed the databases to a network share there is the potential for two clients to be accessing the same db at the same time...

There has been talk in the tvseries plugin forum about enabling that database to use the tve3 server database so information on watched tv shows and show data is stored in one place, for all clients to access.

This request may also tie into the "users" plugin that is being discussed elsewhere.

Definitely a worthwhile suggestion tho, something that I would find very useful being in a multi-client setup.

 

[rtv]

MediaPortalDirs.xml:

<!-- The Path for the databases -->
<Dir id = "Database">
<Path>Database\</Path>
</Dir>

E.g. for ramdisks, etc
Multi-Access isn't possible with SQLite...

 

[allanp81]

Do you think we might ever get to a point where the whole set of databases could be installed into the same database server as the tv engine so that we could share our databases? I have multiple clients and it would be so nice to only need to update things like imdb and music information once and have it available to all clients. I can do this manually at the moment but like you say, you run into difficulties if more than 1 client tries to access it at the same time.

 

[rtv]

Do you think we might ever get to a point.

Yeah, MP-II is designed with use-cases just like that in mind

 

[allanp81]

Excellent.