This explains SQL stored procedures and their advantages.

  • deegeese@sopuli.xyz
    link
    fedilink
    English
    arrow-up
    13
    ·
    1 year ago

    A stored procedure is like making an API for your DB schema. It made a fair bit of sense before microservices existed.

    Nowadays you really shouldn’t be exposing the DB schema in the first place.