• Rev. Layle@lemm.ee
    link
    fedilink
    English
    arrow-up
    11
    ·
    1 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
      arrow-up
      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.

    • alci
      link
      fedilink
      arrow-up
      2
      ·
      1 year ago

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

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

      • Rev. Layle@lemm.ee
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 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