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
Development
General Development (no feature request here!)
Database: Refactor MP1 database for multi seat usage
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="Anthony Vaughan" data-source="post: 1286235" data-attributes="member: 153283"><p>I thought I should let you know exactly what changes I have made to VideoDatabase5.db3. They are as follows:</p><ol> <li data-xf-list-type="ol">Move strFilename from files to movie;</li> <li data-xf-list-type="ol">Remove files table;</li> <li data-xf-list-type="ol">Remove duration;</li> <li data-xf-list-type="ol">Remove hasSubtitles from filesmediainfo.</li> </ol><p>Both duration and hasSubtitles were being stored in two places and I have rationalized that. </p><p></p><p>I have amended all processing related to these changes throughout the application.</p><p></p><p>These changes mean that duration, watched, times watched and watched percent are all available straight from movie (which is used to identify a video throughout, anyway). So there is no need to handle duration separately from the core processing (which it needs to do currently).</p><p></p><p>Getting rid of the files table, which was superfluous, and removing the duplication of hasSubtitles and duration, has simplified processing considerably.</p><p></p><p>I hope this helps you to understand why I felt it was necessary to change the database layout before handling the multi-user issue. I think it'll really be worth it in the end.</p><p></p><p>Tony</p></blockquote><p></p>
[QUOTE="Anthony Vaughan, post: 1286235, member: 153283"] I thought I should let you know exactly what changes I have made to VideoDatabase5.db3. They are as follows: [LIST=1] [*]Move strFilename from files to movie; [*]Remove files table; [*]Remove duration; [*]Remove hasSubtitles from filesmediainfo. [/LIST] Both duration and hasSubtitles were being stored in two places and I have rationalized that. I have amended all processing related to these changes throughout the application. These changes mean that duration, watched, times watched and watched percent are all available straight from movie (which is used to identify a video throughout, anyway). So there is no need to handle duration separately from the core processing (which it needs to do currently). Getting rid of the files table, which was superfluous, and removing the duplication of hasSubtitles and duration, has simplified processing considerably. I hope this helps you to understand why I felt it was necessary to change the database layout before handling the multi-user issue. I think it'll really be worth it in the end. Tony [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
Database: Refactor MP1 database for multi seat usage
Contact us
RSS
Top
Bottom