list  

Re: [DFW CFUG] database standards

Robert Gatti
Thu, 01 Nov 2007 08:02:14 -0800

Conrad,

I don't think he was talking about you. Recently I put someone through the
ringer trying to figure out why some extremely weird stuff was going on in
an app I was working on. It turned out I had
Variabales.insatance.personIdall over the place in some cfc's. Teaches
me to type that fast.

Robert



On 11/1/07, Conrad Davis <[EMAIL PROTECTED]> wrote:
>
> "... because I have never worked with a developer that had very good
> spelling skills"
>
> You don't have to tell everybody about my spelling skills.
>
> -Conrad
>
> On 11/1/07, Mike Kelp <[EMAIL PROTECTED]> wrote:
> >
> >  Haha, the following is why all the argument over plural and singular
> > database names needs to be stopped.
> >
> > http://www.google.com/search?q=plural+database+names&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
> >
> > Read and let other people continue the endless, time wasting argument
> > for you.
> >
> > I personally have used singular names because I have never worked with a
> > developer that had very good spelling skills and plurals add more typos and
> > translation problems (even when its an english-speaking developer). And if
> > you generate code at all, you end up teaching your generator to speak in
> > plurals or entering all the forms of the word.
> >
> > Mike.
> >
> > Robert Gatti wrote:
> >
> > John,
> >
> > I've heard that companies with non-English speaking employees sometime
> > require non-plural naming because it is hard to spell the plural form of
> > many words correctly.
> >
> > For instance these three words each require different changes to
> > pluralize:
> > user -> user(s)
> > address -> address(es)
> > charity -> charit(ies)
> >
> > If anyone knows the validity of this please post. Thanks.
> >
> >
> > Robert
> >
> >
> >
> > On 10/24/07, Sona Solanki <[EMAIL PROTECTED] > wrote:
> > >
> > > Great find!  Thanks!
> > >
> > >
> > > On 10/24/07 12:33 PM, "Joe Kelly" <[EMAIL PROTECTED]> wrote:
> > >
> > > > Found on Google:
> > > > http://justinsomnia.org/writings/naming_conventions.html
> > > > Joe Kelly
> > > >
> > > > On 10/24/07, Dave Crandell <[EMAIL PROTECTED]> wrote:
> > > >> I usually just name my tables tblCustomers, tblUsers, tblInventory,
> > > etc.
> > > >>
> > > >> As far as field names, I use the datatype + field name like,
> > > intCustomerID,
> > > >> autUserID, txtFirstName, memNotes, etc...
> > > >>
> > > >>
> > > >>  On 10/24/07, Kevin < [EMAIL PROTECTED]> wrote:
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> I am trying to work on a list of database standards for all of my
> > > >> applications.  Do any of you have some that you would like to share
> > > to
> > > >> assist me in developing this?
> > > >>>
> > > >>>
> > > >>>
> > > >>> Table naming conventions, field naming conventions, etc.
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> --------------------------------------------------------
> > > >>>
> > > >>>
> > > >>>
> > > >>> Kevin Fricke
> > > >>>
> > > >>> Lone Star Media
> > > >>>
> > > >>> [EMAIL PROTECTED]
> > > >>>
> > > >>> Office: (512) 371-1822
> > > >>>
> > > >>> Mobile: (512) 626-0528
> > > >>>
> > > >>> Fax: (512) 597-0909
> > > >>>
> > > >>> Toll Free: (877) 791-7083
> > > >>>
> > > >>>
> > > >>>
> > > >>> http://www.lonestarmedia.com
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> _______________________________________________
> > > >>> Reply to DFWCFUG:
> > > >>>  List@list.dfwcfug.org
> > > >>> Subscribe/Unsubscribe:
> > > >>>  http://lists1.safesecureweb.com/mailman/listinfo/list
> > > >>> List Archives:
> > > >>>     http://www.mail-archive.com/list%40list.dfwcfug.org/
> > > >>>   http://www.mail-archive.com/list%40dfwcfug.org/
> > > >>> DFWCFUG Sponsors:
> > > >>>  www.instantspot.com/
> > > >>>   www.teksystems.com/
> > > >>>
> > > >>>
> > > >>
> > > >>
> > > >>
> > > >> --
> > > >> Dave C
> > > >> www.davesbizarre.com
> > > >>
> > > >> "First get your facts; then you can distort them at your leisure."
> > > >> - Mark Twain
> > > >> _______________________________________________
> > > >> Reply to DFWCFUG:
> > > >>   List@list.dfwcfug.org
> > > >> Subscribe/Unsubscribe:
> > > >>   http://lists1.safesecureweb.com/mailman/listinfo/list
> > > >> List Archives:
> > > >>     http://www.mail-archive.com/list%40list.dfwcfug.org/
> > > >>   http://www.mail-archive.com/list%40dfwcfug.org/
> > > >> DFWCFUG Sponsors:
> > > >>   www.instantspot.com/
> > > >>   www.teksystems.com/
> > > >>
> > > >>
> > > >
> > > > _______________________________________________
> > > > Reply to DFWCFUG:
> > > >   List@list.dfwcfug.org
> > > > Subscribe/Unsubscribe:
> > > >   http://lists1.safesecureweb.com/mailman/listinfo/list
> > > > List Archives:
> > > >     http://www.mail-archive.com/list%40list.dfwcfug.org/
> > > >   http://www.mail-archive.com/list%40dfwcfug.org/
> > > > DFWCFUG Sponsors:
> > > >   www.instantspot.com/
> > > >   www.teksystems.com/
> > >
> > >
> > >
> > > _______________________________________________
> > > Reply to DFWCFUG:
> > >   List@list.dfwcfug.org
> > > Subscribe/Unsubscribe:
> > >    http://lists1.safesecureweb.com/mailman/listinfo/list
> > > List Archives:
> > >     http://www.mail-archive.com/list%40list.dfwcfug.org/
> > >    http://www.mail-archive.com/list%40dfwcfug.org/
> > > DFWCFUG Sponsors:
> > >   www.instantspot.com/
> > >   www.teksystems.com/
> > >
> >
> >
> >
> > --
> > Robert Gatti
> > [EMAIL PROTECTED]
> >
> > ------------------------------
> >
> > _______________________________________________
> > Reply to DFWCFUG:
> >   List@list.dfwcfug.org
> > Subscribe/Unsubscribe:
> >   http://lists1.safesecureweb.com/mailman/listinfo/list
> > List Archives:
> >     http://www.mail-archive.com/list%40list.dfwcfug.org/
> >
> > http://www.mail-archive.com/list%40dfwcfug.org/
> > DFWCFUG Sponsors:
> >   www.instantspot.com/
> >   www.teksystems.com/
> >
> >
> > _______________________________________________
> > Reply to DFWCFUG:
> >  List@list.dfwcfug.org
> > Subscribe/Unsubscribe:
> >  http://lists1.safesecureweb.com/mailman/listinfo/list
> > List Archives:
> >     http://www.mail-archive.com/list%40list.dfwcfug.org/
> >   http://www.mail-archive.com/list%40dfwcfug.org/
> > DFWCFUG Sponsors:
> >  www.instantspot.com/
> >   www.teksystems.com/
> >
> >
>
> _______________________________________________
> Reply to DFWCFUG:
>  List@list.dfwcfug.org
> Subscribe/Unsubscribe:
>  http://lists1.safesecureweb.com/mailman/listinfo/list
> List Archives:
>    http://www.mail-archive.com/list%40list.dfwcfug.org/
>  http://www.mail-archive.com/list%40dfwcfug.org/
> DFWCFUG Sponsors:
>  www.instantspot.com/
>  www.teksystems.com/
>
>


-- 
Robert Gatti
[EMAIL PROTECTED]
_______________________________________________
Reply to DFWCFUG: 
  List@list.dfwcfug.org
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.instantspot.com/
  www.teksystems.com/