Forgive yourself and move on. :D We've all made bad design decisions
at one point or another in the past. The most important part is that
you are active in a developer community and seek to do better. I hope
that I am a better developer today than I was yesterday. There are a
ton of VFP developers and they've never reached out to their community
to improve their skills and it shows in their code.
On 2/22/19 12:57 PM, M Jarvis wrote:
On Fri, Feb 22, 2019 at 6:11 AM Kevin J Cully <[email protected]>
wrote:
<snip>
I had a potential client where they based their primary keys based on
employee Social Security Numbers. They didn't like it when I told them
that they'd need a complete rewrite. Notice this would have been the case
no matter what language/technology they were using. It was just piss poor
design.
<snip>
I must confess.... I did this once and used SSN's as a primary key. It is
my shame....
I was told I had a year and a half to write a enterprise wide application
and out of the blue the reality was I had about 3 weeks, and failure would
have cost millions and millions... oh - and my job...
I was panicked and the first thing I thought to use was the SSN thinking
that certainly they wouldn't be changing so as a PK would be handy to use.
I went for it w/o thinking it through...
Granted, this was back in the day when the internet wasn't what we think of
today, but still - it was a really dumb dumb idea I always regretted...
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
