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 to [...]
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 start [...]
