Stories
Slash Boxes
Comments
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

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

SQL Keywords Are Not Good Column Names 1 Comment More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I too feel your pain. It is quite natural in ham radio to abbreviate Callsign (our government issued not-quite* unique ids) as '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 --

    1. A call can be reissued after a period of disuse**, so is only unique id within a time range.
    2. There is an overlap in FCC + treaty definitions for US callsigns
      • $ham = qr/[WANK][A-Z]? \d [A-Z]{2,3}/xism;
      • $plane=qr/N \d+ [A-Z]{1,2}/xism;

    ** this over simlifies several ways. the US has q(AA)..q(AL) but not A1 .. A9, AM .. AZ. http://en.wikipedia.org/wiki/ITU_prefix [wikipedia.org]. There is more than a year between disuse and re-issue of personal callsigns to persons. Exceptions include bequething or memorializing a callsign to/with a club or relative after death, or special event callsigns, which flip week to week: in the US, volunteers loan out so-called 1x1 callsigns > $spe=qr/[WNK] \d [A-Z]/xism; to special events, eg W4H [ik3qar.it] is sed in Bosten once a year but is used for other events elsewhen elsewhere, eg Knoxville TN (Fourth of July), Hunterdon Co 4H Fair, and Key Biscayne FL (in 4th call district), so the uniqueness is but for a weekend, not for a decade. And the equivalence range isn't even autoritatively defined online.

    Moral of the story is that seemingly unique identifiers that you don't control issuance of are as likely to bite as seemingly good English word column names that turn out to be SQL reserved words.

    --
    Bill
    # I had a sig when sigs were cool
    use Sig;
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.