Skip to Main Content
SQL Antipatterns, Volume 1
book

SQL Antipatterns, Volume 1

by Bill Karwin
October 2022
Intermediate to advanced content levelIntermediate to advanced
380 pages
9h 35m
English
Pragmatic Bookshelf
Content preview from SQL Antipatterns, Volume 1

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 the fact ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning SQL, 3rd Edition

Learning SQL, 3rd Edition

Alan Beaulieu
SQL Antipatterns

SQL Antipatterns

Bill Karwin
High Performance MySQL, 4th Edition

High Performance MySQL, 4th Edition

Silvia Botros, Jeremy Tinley
SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

Anthony Molinaro, Robert de Graaf

Publisher Resources

ISBN: 9798888650011Errata Page