This explains SQL stored procedures and their advantages.

  • @[email protected]
    link
    fedilink
    English
    131 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.