use Perl

• __ (Score:1)

  by Abigail (26)

  I don't get the connection between table names and class names. I don't care whether a table uses a singular or a plural name, but I don't follow that if you use plural table names, you should use plural class names as well. A table is a collection - a class is a type. I think one should apply the same rules for naming tables as one should use naming arrays. If you use some reasoning that table names should always be plural (or singular), then the same reasoning should give you all plural (singular) array n
  • Tables vs Classes (Score:2)

    by grantm (164)

    I don't get the connection between table names and class names.

    The english word class (in its generic non-CS use) derives from the same root as 'classification'. Dictionary definitions for class use words like 'a collection of things sharing a common attribute', 'A group of individuals ranked together as possessing common characteristics'. In this respect, a class is a collection in the same way that a table is.

    I agree 100% that class names should usually be singular. It seems obvious to me that the same logic behind that decision applies in exactly the same way
• foot vs. feet (Score:1)

  by janus (3624)

  I'm also in favor of singularity, mainly because pluralization is not generally and uniformly possible:
  
  head vs. heads: simple
  foot vs. feet: not as simple
  
  Here, no generalized form is possible, thus it can't be done without explicit naming.
  That of course costs time as you need to think about it every time you encounter it, especially if your mother tongue isn't english.
• but common use cases differ... (Score:1)

  by rjbs (4671)

  In SQL, the minimum likely use case is:

  SELECT id, name, alignment FROM characters;

  With a class, the minimum likely use case is:

  object = Class.new;

  I don't think anyone who uses other than the pluralization that I use deserves a painful death, but I also don't see that the number of tables and classes needs to be tied.

  --
  rjbs
  • Re: (Score:2)

    by grantm (164)

    In SQL, the minimum likely use case is:

    SELECT id, name, alignment FROM characters;

    And each row you get back is made up of those attributes of a 'character'. Sure you get multiple rows, but I don't get how that's different from defining a class in order to instantiate multiple objects.

    With a class, the minimum likely use case is:

    object = Class.new;

    A common case in Rails is:

    @character_list = Character.find(:all)

    Which ultimately generates SQL along the lines of:

    SELECT * FROM CHARACTERS

    And the application will then instantiate one Character object for each row retrieved from the table. In this case there is a clear and deliberate one-to-
• one more thing (Score:1)

  by mattk (7945)

  Plurals seem more natural to me, though I don't really care one way or the other. I do hate CamelCase names though, especially when it comes to ones like AccountPlanOptionLinkSeq...
• Plural bad! (Score:2)

  by autarch (914)

  I really hate plural table names. There are two common problems plural table names have. First, as janus mentioned, plurals in English can be irregular. A common real-world example is "people" and "person". If I have a table named "People" I'll probably end up referring to "person_id" as well, which just irritates me.
  
  Another problem is that it degrades badly when you have "linking" tables. Say I have Accounts and Users, then I might have an AccountsUsers table. Yuck! If I have Accounts, Users, and Roles, th
  • Re: (Score:2)

    by grantm (164)

    The proposed standard naming convention from $cow_orker also mandated the use of CamelCase. With the added wrinkle of a short suffix on every table name. E.g.: Account_act or ProductCommissionGroup_pcg. Any advance on Triple-Yuck ?
    • Re: (Score:1)

      by sigzero (5768)

      I just barfed on my keyboard...thanks.
    • Re: (Score:2)

      by autarch (914)

      I do like camel case for table names, as a way to distinguish them from column names. This is very similar to the the Perl standard of camel case for package names.
      
      That suffix thing is truly awful, though. What possible purpose could it serve? It's like naming everything twice.
      
      • Re: (Score:2)

        by grantm (164)

        The aforementioned proposed standard justified camel case for table names in the same way - to distinguish them from column names. I found that argument a bit spurious since a) I don't recall ever confusing column names for table names and b) the table names are easy to identify already - they're the words following the FROM and JOIN keywords :-)
      • Re: (Score:1)

        by btilly (5037)

        It seems that most databases make table names case insensitive unless you go out of your way to use " everywhere. So using camelCase becomes an unenforced convention that is then not maintained. You also have the potential problem that a given name could be broken into English words in multiple ways, making capitalization ambiguous.
        
        This is why I prefer using _ instead.
        
        For the record, note that my job involves a lot of reporting. I spend more time writing SQL than Perl.
        • Re: (Score:1)

          by Abigail (26)

          It seems that most databases make table names case insensitive

          Yeah, except for a particular free-of-charge database that seems to be quite popular. Tables are files on the underlaying filesystem, and if the underlaying filesystem is case sensitive, your tables are as well. Columns, OTOH, aren't case-sensitive.
          • Re: (Score:1)

            by runrig (3385)

            Yeah, except for a particular free-of-charge database...

            ...and a certain well-known commercial database (*cough* Sybase *cough*). There is a global switch you (i.e. the DBA) can flip to change that, but then all havok breaks loose...