• Rev. Layle
    link
    fedilink
    English
    118 months ago

    I never use all caps when I write SQL, not sure why people insist on it so much

    • @[email protected]
      link
      fedilink
      8
      edit-2
      8 months ago

      I write it in lowercase but then the auto-formatter we use at work converts it to uppercase when I save the file.

      I love auto formatters. Prettier (the initial version for JS) really popularized the concept. If the coding style is automated where possible (things like tabs vs spaces, tab width, line wrap at 80/100/120 characters, where to put line breaks in long statements, etc), it ensures the entire codebase is consistent, and I can jump between different code bases with different coding styles without having to think too much about it.

    • @dylanTheDeveloper
      link
      2
      edit-2
      8 months ago

      I was taught it when working with Oracle SQL (their certification was not cheap and the exam also not easy)

      Personally do what’s easiest if it’s your own database

    • @rasputin
      link
      18 months ago

      It feels important when it’s bold. To the untrained eye, maybe even impressive.

      • Rev. Layle
        link
        fedilink
        English
        38 months ago

        I dunno, I don’t need it to be important, I need it to work and be readable and, to me, all caps is unreadable

        • @rasputin
          link
          28 months ago

          The more you look away the bigger the text gets to grab your attention!