yeah, I agree it's good for communicating stuff to people but becomes a nightmare as soon as you start joining lots a tables together...
just like people using a, b ,c, d , e as table aliases rather than something meaningful like u for user, r for report and so on... lets not get into the whole ID for primary keys thang please! :) z On Thu, Oct 9, 2008 at 7:20 PM, Peter Bell <[EMAIL PROTECTED]> wrote: > > The one use I find out something like tbl_User is when I'm writing an > article or blog post. I never prefix tables with tbl in my real life > code, but I find by doing it in articles and blog posts it seems to me > to make it clearer exactly what I'm talking about as almost everyone > is familiar with the idiom so when I'm talking in the text from > pulling data from tbl_User I don't have to make it clear that I mean > the User table as opposed to a cache of user objects or whatever. I do > usually worry that people will think that's the way that I actually > code, but what are you gonna do?! > > Best Wishes, > Peter > > On Oct 9, 2008, at 3:12 PM, Zac Spitzer wrote: > >> >> my person favourite is the sql-server-ism pattern of >> >> tbluser >> tblcontent >> >> and so on >> >> I do like >> >> V_USER_LAST_LOGIN for a view >> MV_USER_LAST_LOGIN for a materialised view >> >> but that's my oracle background where camel case is useless because >> it's all upper case >> >> z >> >> On Thu, Oct 9, 2008 at 6:57 PM, Sean Corfield >> <[EMAIL PROTECTED]> wrote: >>> >>> On Tue, Sep 30, 2008 at 3:01 AM, Stephen Moretti >>> <[EMAIL PROTECTED]> wrote: >>>> oVarName : java object or component >>>> stVarName : struct >>>> aVarName : array >>>> lVarName : list of simple values >>>> qVarName : query object >>> ... >>>> Basically, I think I fall in to the Sean camp - naming that makes >>>> the code >>>> read like english. >>> >>> No, not if you have cryptic prefixes on them. That's my whole point. >>> stWhatever is *not* readable and is *not* English. These cryptic >>> prefixes are exactly the thing that I'm railing against! >>> -- >>> Sean A Corfield -- (904) 302-SEAN >>> An Architect's View -- http://corfield.org/ >>> >>> "If you're not annoying somebody, you're not really alive." >>> -- Margaret Atwood >>> >>>> >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> >> > > > > > > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
