in reply to What databases are monks using?
I also tend to do things in Perl that I should do in SQL. It pays off when you may switch DBs but it kills you when you start to spread out and have to keep copying rules and tests about. Put the rules in Modules and you wind up adding a million methods to the Module or turning it into a spaghetti-calling nightmare with all the logic hid from you.
I suggest if it is time to fix your habits that you move the data correctness rules to the DB first. Don't get fancy, just setup case controls and ranges and such. Ease up on contorted tainting and start testing your inserts for failure. I was really pleased with myself for ust going that far =)
--
$you = new YOU;
honk() if $you->love(perl)
|
|---|