This weekend I put the finishing touches on the Snap Affiliates package and was getting ready to push it out the door. Late last night I had a change of heart, though. The short story is I’ve been struggling with the database layout. Ask any developer and they’ll tell you that it’s something you need to get right the first time out. If you don’t and need to patch it later, you’re in for an ugly fight.
For weeks I had been convincing myself that the database structure was alright. I came up with lots of excuses why it should stay the way it is. None of them were good. The big secret one I wasn’t owning up to was that I didn’t want to have to rip the guts out of every SQL statement and make sure they’re still correct. This being a database-driven application, that means gutting and re-testing the entire module.
Obviously, I want this project to succeed. If I want it to succeed, it needs to be done right at every step of the way. In this instance, that means fixing the database layout, gutting every SQL statement, and re-testing the whole module. With the kids and the day job keeping me busy, I figure I can have it done by the end of the week. Keep your eyes peeled for the package next Monday.
Interact
TrackbackMake a Comment
Digg This
Submit to Reddit
Submit to Del.icio.us