Unemployed Developer

There are two schools of thought regarding stored procedures. On side for them, you’ll hear about the virtues of cross-language functionality (any language with a Postgres database wrapper can run the functions, saving re-writing in separate libraries), they’re fast (precompiled), they operate in transactions and you can specify varying amounts of permissions. On the side against them, you’ll hear about the difficulty debugging them due to caching issues, testing can be a pain in the butt and deployment isn’t all that fun when you’ve got clustered databases to worry about. I believe there is a use for stored procedures, and, when used correctly, can make for some modular goodness. Firstly, let’s take a look at a sample stored procedure.
Read more »