This explains SQL stored procedures and their advantages.

  • AlecSadler@lemmy.world
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    Could you explain more? Almost everywhere I’ve worked from Fortune 250 on down has used stored procedures with applications and it seems extremely clean and performance-oriented.

    If anything, it separates code from the data more as far as I can tell, so maybe I’m missing something?

    Also, if something is somewhat data driven and there’s a bug, you simply alter a procedure versus doing a build and deploy of the entire application.