One Database file - multiple clients

[GoogleCodeExporter]

What enhancement or feature would you like?
As I have a large NAS I would like to maintain 1 TV-Series database file
and use this database from various clients.
Currently a client "locks" the database which results in a "damaged" view
when other clients tries to access the database

Original issue reported on code.google.com by jtegif...@gmail.com on 16 Apr 2009 at 12:35

[GoogleCodeExporter]

Doesn't StreamedMP take care of this?  I haven't used it, but it's what came to 
mind
:)  Look into it if you haven't already.

Original comment by pgjensen on 16 Apr 2009 at 1:47

[GoogleCodeExporter]

I am talking about the file "TVSeriesDatabase4.db3" which is locked by the first
TV-Series "client" - which makes it impossible for a second TV-Series client to
open/read the same file. Which results in an empty TV-Series-screen.
This has nothing to do with the Skin. I just have multiple computers in my LAN
pointing to a SAN where this TV-Series-file is stored. Now I make regular 
copies for
each client and each have configuration pointing to it's configured database 
file.

I would suggest that when the first TV-series client claims the database for
"writing" then other TV-Series clients would instantly become passive clients 
(= NO
scanning for new files --> NO updating database entries)

Original comment by jtegif...@gmail.com on 16 Apr 2009 at 1:58

[GoogleCodeExporter]

"Me too". I have 2 Mediaportal machines now, and it's annoying having to 
remember to
mark what's been watched on one machine on the other one. 

I tried the import/export watched flags feature, but it overwrote the flags on 
the
imported machine instead of doing a merge. Moreover, it's not automatable, so 
it's
not very easy to use. Being able to share the DB file would be a nice solution, 
but
there's definitely race conditions that could be an issue.

IMO the important thing here is knowing what's been watched. All the clients 
should
be able to parse the episodes out easily enough such that the only thing that 
really
needs to be RW for all clients is the watched episodes DB. 

Original comment by steve...@gmail.com on 5 May 2009 at 10:48

[GoogleCodeExporter]

Having MP TV-Series Multi Seat would be a vast improvement. As Mediaportal it 
self 
has went multiseat it makes no sense why you have to update / maintain multiple 
databases on multiple machines. I currently have 5 mediaportal machines around 
the 
house and it's really not possible to keep them all sych'ed.

Original comment by nor...@gmail.com on 18 May 2009 at 4:23

[GoogleCodeExporter]

Another star from me.
I need to close one client before another will work.
This enhancement would be great!

Original comment by rekenaa...@gmail.com on 27 Dec 2009 at 4:18

[GoogleCodeExporter]

This will be possible with the experimental service version.

Original comment by jonathan...@gmail.com on 4 Jan 2010 at 5:38

• Changed state: Accepted
• Added labels: Experimental-Service, Priority-Medium
• Removed labels: Priority-Low

[GoogleCodeExporter]

What does experimental service version mean? How to get it?

Original comment by ste...@prie.be on 23 Aug 2010 at 10:31

[GoogleCodeExporter]

There is a working server+client system that is being coded. It works, but only 
by itself. I've got it running on my system to help with testing, and it works 
to the extend that it parses the files, grabs the right info from TheTVdB and 
adds it into an SQL database (focus lies on MySQL right now, but in the end 
MS-SQL and SQLite will also be made to work). Airdate and episode title match 
is also working, so that will be another great feature a lot of people are 
waiting on.

There still needs to be a lot of things sorted out to integrate it into the 
next release of MP-TVSeries. Personal life caught up with some developers that 
are putting a lot of work into this, but it will eventually get done.

So just be patient.

Original comment by RoChess....@gmail.com on 24 Aug 2010 at 4:43

[GoogleCodeExporter]

Sounds great! Keep up the good work!

Original comment by ralphj.s...@gmail.com on 24 Aug 2010 at 1:18

[GoogleCodeExporter]

Please Sir, for Xmas Sir? an early Xmas gift maybe? ah go on!

Can't wait for this really a must have for multi client system.

Original comment by subaz...@gmail.com on 4 Nov 2010 at 10:51

[GoogleCodeExporter]

Issue 504 has been merged into this issue.

Original comment by damien.haynes@gmail.com on 11 Mar 2011 at 5:50

[GoogleCodeExporter]

I have run a setup with DB and thumbs on the network shares and all clients 
pointed to them. It was terrible... crashed constantly, EXTREMELY SLOW (altho I 
think if the thumbs were to remain local that would be a big improvement). The 
main problem is having all the clients access the DB and make changes. I tried 
to counter this problem by only letting one client handle all importing. It 
sure did help with MOST of the crashing, but I went back to individual 
databases and have been much happier since.

I think one of the features of MP 2 will be a true client/server setup for 
shares, but I could be guessing.

Original comment by datahaza...@gmail.com on 14 Jun 2011 at 10:02

[GoogleCodeExporter]

Original comment by damien.haynes@gmail.com on 7 Sep 2011 at 3:34

[GoogleCodeExporter]

hi,
is there any progress with mysql support?
Would love it! sqlite really sucks with more than 1 client.

Original comment by bleim...@googlemail.com on 1 Feb 2013 at 9:24

[GoogleCodeExporter]

Thumbnails on my network storage, 4 clients are working fine. Tried to make a 
database on network storage. Started to slow down and crashes. Mainly the 
errors were in the series plugin. Other plug-ins if they rarely were failing. 
In My Videos do not never noticed.

Original comment by ajs.blackhole on 6 Jan 2015 at 10:55