This explains SQL stored procedures and their advantages.

  • Distributed@lemmy.ml
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    1 year ago

    Whats your preferred method of accessing sql, in that case? Most companies I’ve worked for use sprocs. ORM?

    • wvenable@lemmy.ca
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      Direct queries and ORM. A stored procedure doesn’t provide much value as a unit of abstraction that couldn’t just exist in the code.