What's the problem with maintainability of stored procedures?
For example, one can keep them in 'stored-procedures.sql' under Git version control and deploy them via one command, like `psql ...`.
Won't it work that way?
For example, one can keep them in 'stored-procedures.sql' under Git version control and deploy them via one command, like `psql ...`.
Won't it work that way?
Tooling is a devs best friend. Using an IDE or vim/emacs with the correct extensions allows developers to easily see where a class is being used, allowing quick inspection. I do believe stored procedures have a place but they've been abused too much.
No. I was thinking about something like a greenfield project, small or medium size. Where about 100 stored procedures are all named nicely and 2-3 developers working on the project fully understand what they are doing with them :)