It seems that everyone and their mom is switching to WordPress for their blogging needs. Chu Yeow did and it seems that he is already very happy with the change.

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.