NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
Ovid (2709)
Ovid
(email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)
(email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)
Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.
Friday July 24, 2009
04:29 AM
SQL Keywords Are Not Good Column Names
In retrospect, my accidentally naming a column after an SQL reserved word ("key") was pretty stupid and now I have a fair chunk of code to change.
But I briefly toyed with the idea of keeping a straight face and telling people it was defense-in-depth against SQL injection attacks. It would be fun to see how many people would buy that rationale.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Full
Abbreviated
Hidden
Loading... please wait.
I pour myself a cup of strong coffee. :-)
-- Jarkko Hietaniemi
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Table names either (Score:1)
Re: (Score:2)
We ran into that problem ourselves. We have a table named "grouping".
bad SQL column names (Score:1)
'call'. That was a poor choice for a column name for such things, since user defined procedures in SQL have to be invoked by a call keyword. I had to expand the column name such that it is wider than the longest likely value (except Roman Italic compresses Callsign more than Roman Bold does WB1GOF) http://fd.ema.arrl.org/History.php [arrl.org]* why 'not quite unique? Two issues --
Bill
# I had a sig when sigs were cool
use Sig;