| > devs that have no problem reading your backend language will not necessarily be good at reading stored procedures But again ... why do they need to ? If you are a developer and you want to convert a string to upper case, you just use `strings.ToUpper($foo)` or whatever based on the signature. Again, its no different with stored procedures. Dev wants to add a new user ? They look through the stored procedure headers and see a `add_user($foo,$bar)` signature and code a call against that. Do they need to know that in the background `add_user($foo,$bar)` inserts into table `users`, `groups` etc. ? No. Infact it makes the dev's life simpler because instead of sending multiple calls themselves (or perhaps forgetting one or two), they just called the stored procedure. That is my problems with devs who think they are some sort of geniuses that need absolute access to the database because they think nobody can write SQL queries as well as they can ... too many times they come running to me complaining the database is "slow" when in fact it is their sloppy SQL queries that are slow. |