Some of you may be too young to remember this, but writing your application logic in Stored Procedures was all the rage back in the day (PG devs you wouldn’t understand). That is mostly because they were typically written by consultants from IBM and Oracle that cost a fortune and told you to do it this way. Eventually people wised up and realized they (both) sucked and as all things in Software Development, the pendulum swung the other way and people started treating databases like dumb storage. A 15 year old blog post from Jeff Atwood lists some of the problems:
- Written in T-SQL/PL-SQL, not a real programming language.
- Cannot be debugged in the same IDE
- Little to no feedback when things go wrong
- Can’t pass objects.
- No idea what a proc is doing