laziness, impatience, and hubris | |
PerlMonks |
Re: What's your favorite SQL generation module?by UnderMine (Friar) |
on Jun 07, 2006 at 05:40 UTC ( [id://553966]=note: print w/replies, xml ) | Need Help?? |
There are arguments for and against SQL generation.
Coming from a DBA background I personally tend to do a minimal wrapping of DBI as a lot of these modules don't process transactions effectively and can be quite difficult to get to write optimised SQL code. SQL::Interpolate does a mimimal amount of work for you. Allowing you to be helped by it(i.e. selects, inserts, updates especially) but still have control enough to bypass it during a transaction if you have to. My opinion is you should always hand code a delete if you have to do it as these are too risky to leave to a code generator. However it is better to do a logical delete and then you can roll it back at any time. Hope it helps
In Section
Seekers of Perl Wisdom
|
|