• xmunk@sh.itjust.works
    link
    fedilink
    arrow-up
    1
    ·
    2 years ago

    Speaking as a Senior Dev specialized in database access and design… you don’t have to use all caps - SQL is actually case agnostic.

    But… but my fucking eyes man. I’m old, if your branch doesn’t have control keywords in all caps I’m going to take it out back and ol’ yeller it.

    There are few hills I’ll die on but all caps SQL and singular table names are two of them.

  • rwhitisissle@lemmy.ml
    link
    fedilink
    arrow-up
    1
    ·
    edit-2
    2 years ago

    The phrase “SQL programmers” is so fucking weird. SQL isn’t a programming language. It’s a query language. You don’t “program” things with SQL. You utilize SQL as a component of programs for data insertion and lookup, but the actual logic of execution is done in a programming language. Unless you’re doing Oracle PL/SQL, in which case why are you giving money to Oracle?

    Edit: Damn, this comment made people mad.

    • KarmaPolice@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      2 years ago

      Most database engines support stored procedures. You don’t need to give money to oracle, you can give it to Microsoft instead.