• Rev. Layle
    link
    fedilink
    English
    111 year ago

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

    • @dan@upvote.au
      link
      fedilink
      8
      edit-2
      1 year 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@lemmy.world
      link
      fedilink
      2
      edit-2
      1 year 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

    • @alci@jlai.lu
      link
      fedilink
      21 year ago

      Was an Oracle thing. Postgresql is rather on the lowercase side of things…

      • Rev. Layle
        link
        fedilink
        English
        31 year 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