Database design almost complete

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?

  1. More code
  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *