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
Popular Plugins
My TVSeries
Move to SQL server instead of db3 file?
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="Zasurus" data-source="post: 530226" data-attributes="member: 26856"><p>No I understand. And I disagree. It MAY be possible to crate a "multi-seat" system on a SQLite db structure for ONE application but as "aj1405" pointed out bellow SQLite does completely lock the complete DB file during read/write operations making it next to impossible to use with more than one application at once.</p><p></p><p>Don't get me wrong I understand what you mean by it not being the complete solution due to the system needed to make sure one doesn't write over the others changes and that if one made a change the others would need to be constantly checking for those changes to be up to date (especially before making there own changes) for me multi-seat is a second problem and something I wanted for the future as I currently don't have more than one PC accessing this DB (don't get me wrong I DO want to be able to do this soon! ;-)).</p><p></p><p>I was only trying to say that out of the choice of DB types (file or full server SQL) I would like it to swing towards server SQL so it can ALSO be access (maybe only for reads and a few writes to its own columns/tables) with db like access and sqlite they don't handle this very well (or at all! ;-)).</p><p></p><p>Hope this makes more sense? <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused :confused:" loading="lazy" data-shortname=":confused:" /> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin :D" loading="lazy" data-shortname=":D" /></p><p></p><p>I didn't mean to upset you fforde <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite10" alt=":oops:" title="Oops! :oops:" loading="lazy" data-shortname=":oops:" /></p><p></p><p>Regards,</p><p></p><p>Zas</p></blockquote><p></p>
[QUOTE="Zasurus, post: 530226, member: 26856"] No I understand. And I disagree. It MAY be possible to crate a "multi-seat" system on a SQLite db structure for ONE application but as "aj1405" pointed out bellow SQLite does completely lock the complete DB file during read/write operations making it next to impossible to use with more than one application at once. Don't get me wrong I understand what you mean by it not being the complete solution due to the system needed to make sure one doesn't write over the others changes and that if one made a change the others would need to be constantly checking for those changes to be up to date (especially before making there own changes) for me multi-seat is a second problem and something I wanted for the future as I currently don't have more than one PC accessing this DB (don't get me wrong I DO want to be able to do this soon! ;-)). I was only trying to say that out of the choice of DB types (file or full server SQL) I would like it to swing towards server SQL so it can ALSO be access (maybe only for reads and a few writes to its own columns/tables) with db like access and sqlite they don't handle this very well (or at all! ;-)). Hope this makes more sense? :S :D I didn't mean to upset you fforde :ooops: Regards, Zas [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
Move to SQL server instead of db3 file?
Contact us
RSS
Top
Bottom