ShehanPerera@programming.dev to Programming@programming.devEnglish · 1 year agoSQL Stored Proceduresdomesticatedbrain.comexternal-linkmessage-square19fedilinkarrow-up122arrow-down113file-textcross-posted to: programming@programming.dev
arrow-up19arrow-down1external-linkSQL Stored Proceduresdomesticatedbrain.comShehanPerera@programming.dev to Programming@programming.devEnglish · 1 year agomessage-square19fedilinkfile-textcross-posted to: programming@programming.dev
minus-squaredeegeese@sopuli.xyzlinkfedilinkEnglisharrow-up13·1 year agoA 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.
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.