Post reply

Naming Is Hard

  • April 7, 2016 at 1:42 pm

    #1870648

    Re - table names that are GUIDs...

    If this is a pre-configured database intended as part of a system/application "as is", then whoever did that was at least mildly insane.

    However, some systems (such as one I work with) are designed to allow Customer personnel to dynamically create new complex objects within the application, and these new objects come with associated tables, indexes, etc., that are dynamically created. In this situation, creating the tables with GUIDs as names ensures that no future release of the application will possibly conflict with existing customer-created table names.

    While GUID table names are definitely hard for us "meatware" to read, the software has no problem with the internal manifest that provides all the associations, and it is fairly rare that we really need to write direct SQL statements against the GUID tables.

  • April 7, 2016 at 4:06 pm

    #1870684

    There are still systems in common use out there with surprisingly short length naming restrictions. I seem to remember that there is something like an ANAME record for Linux systems that is limited to 15 characters. If it's not an ANAME record it is something with a similar name.

    LinkedIn Profile

  • April 8, 2016 at 1:44 am

    #1870720

    David.Poole (4/7/2016)

    There are still systems in common use out there with surprisingly short length naming restrictions. I seem to remember that there is something like an ANAME record for Linux systems that is limited to 15 characters. If it's not an ANAME record it is something with a similar name.

    Also Oracle.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • April 12, 2016 at 12:13 pm

    #1871492

    What I loved about the JD Edwards database I had peripherally deal with was the lack of enforced foreign keys. Thus, you got to guess at where the proper joins were.

    But ... from a developer standpoint it often doesn't matter what the table name is. Especially if one uses an ORM, where they can easily name them in code in a meaningful manner. In fact, I did just that kind of thing for dealing with the JD Edwards database. I gave my tables friendly names, and setup relationships.

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply