Skip to main content



Why Stored Procedures? Pros and Cons

I had to learn Stored Procedures extensively some months ago and I've found that it is somewhat quite a debated topic in the software engineering world. While most I've found favors stored procedures, there are quite many devs who are not a supporter. It can get pretty confusing deciding whether or not you should go for them. So I decided to compile a list of pros and cons based on my research to help my fellow hackers out there. I'm not explaining what Stored Procedures are and how to write them. I will write a follow-up with what Stored Procedures are and how to write them in PL/PGSQL & PLPYTHONU. For now, you can take a look at the links I used for reference at the end of this article. **18+ Alert: I prefer to write in a frank tone so you may find some slang as you go in. Proceed with caution. Pros: The pros of stored procedures circle mainly around separating database interface from code layer and prevention of SQL injection. We'll discuss these two first and so

Latest Posts

What is Machine Learning and How Google Assistant Uses It