Database configurable

Nightmare77 · 2007-06-13, 04:48

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 · 2007-06-13, 07:24

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 · 2007-06-13, 15:56

MediaPortalDirs.xml:


<Dir id = "Database">
<Path>Database\</Path>
</Dir>

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

allanp81 · 2008-02-21, 13:01

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 · 2008-02-21, 13:48

Quote:

Originally Posted by allanp81

Do you think we might ever get to a point.

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

allanp81 · 2008-02-21, 14:11

Excellent.

2007-06-13, 04:48	#1 (permalink)
Nightmare77 Portal Member Join Date: Jul 2005 Location: Canberra Age: 29 Posts: 520 Thanks: 2 Thanked 1 Time in 1 Post Country: My System	Database configurable 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?

2007-06-13, 15:56	#3 (permalink)
rtv Portal Developer Join Date: Apr 2005 Location: Osnabruck Posts: 2,698 Thanks: 120 Thanked 126 Times in 87 Posts Country: My System	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... __________________

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Configurable skins	villadom	Skins	5	2006-11-15 13:57
More configurable quick jumps	robomonkey	Improvement Suggestions	7	2006-08-29 12:48
Configurable MCE remote	MJGraf	The old Bugreport Forum	1	2006-04-16 18:44
Configurable Power Off on Home Screen	TVKiwi	Improvement Suggestions	6	2006-03-19 11:39
Configurable actions with MCE remote when in TV FullScreen	a.dimuzio	Improvement Suggestions	0	2005-05-23 10:03

2007-06-13, 07:24	#2 (permalink)
scythelt Portal Member Join Date: Dec 2006 Age: 29 Posts: 138 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	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.

2008-02-21, 13:01	#4 (permalink)
allanp81 Portal Member Join Date: Oct 2006 Posts: 465 Thanks: 2 Thanked 7 Times in 7 Posts	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.

2008-02-21, 14:11	#6 (permalink)
allanp81 Portal Member Join Date: Oct 2006 Posts: 465 Thanks: 2 Thanked 7 Times in 7 Posts	Excellent.