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
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
Foreign Key Constraints missing with RC1
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="dsnaith" data-source="post: 258770" data-attributes="member: 19783"><p><strong>Why MyIsam</strong></p><p></p><p>As ISAM is a very old database engine and MySQL supports other engines which do have "foreign key constraints" and SQL Server support "foreign key constraints", why take them out.</p><p></p><p>I notice the constraints where missing only when I queried the database directly and have seen them there in the SVN builds. To assume that programs will do the right thing is not the safest approach. I work with databases all day and have seen corrupted data many times due to lack of constraints. This also makes life harder when working on plugins etc as they can aid the developers understanding of the database.</p><p></p><p>I'm new to Media Portal but I'm impress so far, it would be a shame if something as simple as lack of constraints was to spoil the product.</p></blockquote><p></p>
[QUOTE="dsnaith, post: 258770, member: 19783"] [b]Why MyIsam[/b] As ISAM is a very old database engine and MySQL supports other engines which do have "foreign key constraints" and SQL Server support "foreign key constraints", why take them out. I notice the constraints where missing only when I queried the database directly and have seen them there in the SVN builds. To assume that programs will do the right thing is not the safest approach. I work with databases all day and have seen corrupted data many times due to lack of constraints. This also makes life harder when working on plugins etc as they can aid the developers understanding of the database. I'm new to Media Portal but I'm impress so far, it would be a shame if something as simple as lack of constraints was to spoil the product. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
Foreign Key Constraints missing with RC1
Contact us
RSS
Top
Bottom
