Reply to thread

Message

<blockquote data-quote="doskabouter" data-source="post: 1286627" data-attributes="member: 98267">Did a quick read of this thread.Couple of questions/remark:1: You want to have 1 central database for all mediaportal clients in your house?&nbsp;&nbsp; Am I understanding it correctly that you created some kind of service managing a sqlite database?&nbsp;&nbsp; If that's the case, I would go with just a regular Mysql or something...2: <a href="https://forum.team-mediaportal.com/threads/database-refactor-mp1-database-for-multi-seat-usage.140621/post-1286235" target="_blank">https://forum.team-mediaportal.com/threads/database-refactor-mp1-database-for-multi-seat-usage.140621/post-1286235</a>did you think of movies consisting of multiple files? ajs already asked that3: I've added some try/catches All errors are properly logged I assume?4: percentage watched I agree with ajs, as soon as you've watched more than x % increase numberoftimeswatched and set watched to true (that matches our usecase)5: lost knowledge due to leaving devs: Ideally all design decisions should be documented somewhere (at te very least in the jira ticket or findable through that)&nbsp; I always try to trace back how things evolved by doing git-blame but too often that leads to a deadend...6: incompatible databases can probably have a view in them for backwards compatibility?7: any other discussions about database-things: you can also ask me I've got some experience in those as well (right [USER=68833]@ajs[/USER]? <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />)</blockquote>

[QUOTE="doskabouter, post: 1286627, member: 98267"] Did a quick read of this thread. Couple of questions/remark: 1: You want to have 1 central database for all mediaportal clients in your house? Am I understanding it correctly that you created some kind of service managing a sqlite database? If that's the case, I would go with just a regular Mysql or something... 2: [URL]https://forum.team-mediaportal.com/threads/database-refactor-mp1-database-for-multi-seat-usage.140621/post-1286235[/URL] did you think of movies consisting of multiple files? ajs already asked that 3: I've added some try/catches All errors are properly logged I assume? 4: percentage watched I agree with ajs, as soon as you've watched more than x % increase numberoftimeswatched and set watched to true (that matches our usecase) 5: lost knowledge due to leaving devs: Ideally all design decisions should be documented somewhere (at te very least in the jira ticket or findable through that) I always try to trace back how things evolved by doing git-blame but too often that leads to a deadend... 6: incompatible databases can probably have a view in them for backwards compatibility? 7: any other discussions about database-things: you can also ask me I've got some experience in those as well (right [USER=68833]@ajs[/USER]? :)) [/QUOTE]

Verification