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!)
weirdness in mysql schema?
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="deebo" data-source="post: 177887" data-attributes="member: 19876"><p>dont nail me to the cross but im just wondering here, im doing my own personal spring+hibernate+ajax based webinterface and i was going through the mysql schema of the TvLibrary from a dump i made and noticed some stuff</p><p></p><p>a) MyISAM, doesnt support FK's</p><p>b) all fk's are just indexes</p><p>c) default charset latin1</p><p></p><p>to begin with a+b means the database cant do integrity checks or cascades, which means that possible errors in coding wont result in errors and/or data might be left behind and the database will unnecessarily grow over time</p><p></p><p>and c just means that only basic western+nordic characters are supported</p><p></p><p>and to get to my question: is this a design choice (please explain <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" />), or has it just been overlooked</p></blockquote><p></p>
[QUOTE="deebo, post: 177887, member: 19876"] dont nail me to the cross but im just wondering here, im doing my own personal spring+hibernate+ajax based webinterface and i was going through the mysql schema of the TvLibrary from a dump i made and noticed some stuff a) MyISAM, doesnt support FK's b) all fk's are just indexes c) default charset latin1 to begin with a+b means the database cant do integrity checks or cascades, which means that possible errors in coding wont result in errors and/or data might be left behind and the database will unnecessarily grow over time and c just means that only basic western+nordic characters are supported and to get to my question: is this a design choice (please explain :)), or has it just been overlooked [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
weirdness in mysql schema?
Contact us
RSS
Top
Bottom