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
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