Antipattern: Follow the Leader
The real antipattern in this chapter is not the use of stored procedures. The antipattern is to use any technology featureâstored procedures is just a good exampleâbecause it was done before you. Just because stored procedures were right in some prior project doesnât necessarily make it a good choice for your current project.
Stored procedures (or more broadly, stored routines, which also includes functions, triggers, and packages) are a traditional part of application development if you use one of the major commercial SQL database platforms such as Oracle, Microsoft SQL Server, IBM DB2, Informix, or Sybase. However, there are several hidden costs to using stored procedures.
Procedure Language
Despite ...
Get SQL Antipatterns, Volume 1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
