08
Dec
MySQL provides cascading updates / deletes with the relationships, but I tend not to use them, specifically because I want to control just how far these updates and deletes cascade! But, given a situation where I have a design similar to this: I would like to be able to remove a single Foo, without having [...]
23
Nov
I’ve long neglected this blog, and the power behind it to discuss my feelings toward database design. Proper database design is the backbone to a solid application. Failing to correctly normalize tables and enforce business logic with foreign key relationships can cause undue headaches. What I’ll be doing is going through some simple applications, and [...]
