Last read book: SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Hello!  Today I'm going to share my impressions about
SQL Antipatterns: Avoiding the Pitfalls of Database Programming.


Almost every developer claims himself to work well with SQL. What could be hard with writing INSERT, UPDATE or DELETE queries? That's why SQL is often a second-class citizen in programmer's belt.

But SQL is not only about data manipulation, it is also about relations. In a small to medium projects developer is also a data architect. He designs the database. And very often false database design leads to bad programs.

The book on SQL antipatterns contains four parts about different types of patterns:

• logical database design antipatterns
• physical database design antipatterns
• query antipatterns
• application development antipatterns

 Every chpater on antipattern has a real world example, the problems which arises when applying the antipattern, and the solution which can applied to solve the task.

This book is valuable to me because i recognized the antipatterns that i have met. Also it should be the reference guide when dealing with database design.

The book is a pleasure to read. It also has a good bibliography. Some of interesting to mention books:

1. William J. Brown, Raphael C. Malveau, Hays W. McCormick III, and Thomas J. Mowbray. AntiPatterns. John Wiley and Sons, Inc., New York, 1998.
2. Joe Celko. Joe Celko’s Trees and Hierarchies in SQL for Smarties. Morgan Kaufmann Publishers, San Francisco, 2004.
3. Joe Celko. Joe Celko’s SQL Programming Style. Morgan Kaufmann Publishers, San Francisco, 2005.
4. Robert L. Glass. Facts and Fallacies of Software Engineering. Addison-Wesley Professional, Reading, MA, 1992.
5. Vadim Tropashko. SQL Design Patterns. Rampant Techpress, Kittrell, NC, USA, 2006. See here.