This explains SQL stored procedures and their advantages.
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.
Hope you enjoy the instance!
Follow the wormhole through a path of communities !webdev@programming.dev
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.