• Rev. Layle
    link
    fedilink
    English
    arrow-up
    11
    ·
    8 months ago

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

    • dan@upvote.au
      link
      fedilink
      arrow-up
      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.

    • alci@jlai.lu
      link
      fedilink
      arrow-up
      2
      ·
      8 months ago

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

    • dylanTheDeveloper@lemmy.world
      link
      fedilink
      arrow-up
      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

      • Rev. Layle
        link
        fedilink
        English
        arrow-up
        3
        ·
        8 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