home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
[Deprecated] WatchedSynchronizer
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="antihero05" data-source="post: 1122279" data-attributes="member: 151192"><p>Hi popy,</p><p></p><p>here the answer regarding your questions:</p><p></p><p>Regarding the caching:</p><p>This is currently only in use for the TVSeries database since I needed to create the SQL statements on my own. The idea behind the cache is to reduce the number of database queries.</p><p>For example I get the unique_id of the episode,season and series by the filepath of the video file. If you now for example stop playback an event is triggered which writes the watched information and related to the database. If you now continue and stop again or finish the playback it is not necessary to access the database to get the unique_id again. This unique_id does not change during playback so I cached it.</p><p>Writes are currently done immediatly - So no problems with the shutdown scenario you were thinking about.</p><p></p><p>When accessing the video database there is no caching since I just "injected" a other database and use the default methods of the respective classes.</p><p></p><p>Regarding the locking I am more or less relying on the SQLlite library.</p><p>Your suggestion of implementing some sort if queue which is handled by a separate thread is something I already thought about during my initial coding. The issue I need to investigate on is the lock detection of the database since sqlite is not the best regarding that. Well my databases did not get corrupt since I use the plugin so I have it not done yet. But this is something I absolutely want to do in the future, but at the moment and next few weeks I am very busy at work so hardly time for coding in the freetime.</p><p></p><p>Regarding Moving Pictures:</p><p>I don't use that plugin so I did not have a look at it yet. When I have more time I will definetly have a look at it and take steps to support it but handling the synchronizing in separate threads will be coming first.</p><p></p><p>Hope this answers your question.</p><p></p><p>Best Regards,</p><p>Max</p></blockquote><p></p>
[QUOTE="antihero05, post: 1122279, member: 151192"] Hi popy, here the answer regarding your questions: Regarding the caching: This is currently only in use for the TVSeries database since I needed to create the SQL statements on my own. The idea behind the cache is to reduce the number of database queries. For example I get the unique_id of the episode,season and series by the filepath of the video file. If you now for example stop playback an event is triggered which writes the watched information and related to the database. If you now continue and stop again or finish the playback it is not necessary to access the database to get the unique_id again. This unique_id does not change during playback so I cached it. Writes are currently done immediatly - So no problems with the shutdown scenario you were thinking about. When accessing the video database there is no caching since I just "injected" a other database and use the default methods of the respective classes. Regarding the locking I am more or less relying on the SQLlite library. Your suggestion of implementing some sort if queue which is handled by a separate thread is something I already thought about during my initial coding. The issue I need to investigate on is the lock detection of the database since sqlite is not the best regarding that. Well my databases did not get corrupt since I use the plugin so I have it not done yet. But this is something I absolutely want to do in the future, but at the moment and next few weeks I am very busy at work so hardly time for coding in the freetime. Regarding Moving Pictures: I don't use that plugin so I did not have a look at it yet. When I have more time I will definetly have a look at it and take steps to support it but handling the synchronizing in separate threads will be coming first. Hope this answers your question. Best Regards, Max [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
[Deprecated] WatchedSynchronizer
Contact us
RSS
Top
Bottom
