To Stored Procedure or Not

Or: My personal Object-Relational Mapping Vietnam war story tl;dr Choose the right tool for the job. What that is, well, it depends. The standard reaction of a lot of java developers (add enterprisey language X) to the question: ‘Stored procedures?’ is often a plain ‘No’. The reasoning goes somewhat like this: ‘A database is a dumb datastore that might be swapped out, so we don’t want to add intelligence there.' At least that is what I heard multiple times in the past, and as you can guess by now: the database is never, ever swapped out. [Read More]