I am putting the final touches on the database design for the new version of badice.com. I designed it with flexibility in mind and wanting to have the ability in the future to expand it. The one thing I am dissappointed about is the fact that my host does not allow InnoDB type tables. Because of this I am forced to make sure all updates, inserts, and deletions are carried out in the program instead of internally in the database. From a systems design standpoint it is the wrong thing to do. Why?
- More code
- More of a chance to miss a small detail. With a parameter in the database design (with InnoDB) you can have all tables reliant on another table delete their records related to a record that is its parent.
That’s all I can think of at the moment, but you catch my drift.