Joining is easy.
Subscribe to our announce list. We'll send you a confirmation email in reply. Come back, enter the confirmation password, and you're done!
Reviewed by Major Keary
The sub-title of this book is Avoiding the Pitfalls of Database Programming, which nicely encapsulates its purpose: to present good and practical advice. In his introduction the author defines an antipattern as: … a technique that is intended to solve a problem but often leads to other problems. The concept of antipatterns has been around for a long time; a book, Antipatterns [William J. Brown et al., John Wiley and Sons] was published in 1998, and there is documentation in the Portland Pattern Repository [http://c2.com/cgi-bin/wiki?AntiPattern].
David Karwin has been a software engineer for over twenty years and since 1992 has worked with SQL in a range of contexts: developing applications, technical support, and development of libraries for SQL programming in Perl and PHP. In the introduction to SQL Antipatterns he says, "I've answered thousands of questions on Internet mailing lists and newsgroups. I see a lot of repeat business—frequently asked questions that show that software developers make the same mistakes over and over again". He brings that vast store of experience to this detailed discussion of SQL antipatterns.
The content is in four parts, each of which groups topics:
Each antipattern chapter follows a common format:
Example code is used to illustrate discussions, and there are useful diagrams. The author is able to maintain technical depth without resort to techspeak. The focus is on practical application with discussions of issues on both the development and administration sides of database technology. A narrative style makes for easy reading; however, readers are expected to 'speak SQL', but not necessarily to be fluent.
An important resource that brings together information that would otherwise be spread over many texts and documents—or, perhaps, not recorded at all.
David Karwin: SQL Antipatterns
Published by ragmatic Bookshelf, 333 pp., RRP AU$ 50.95
Woodslane. This title can be purchased from the Australian distributor at
A discount can be redeemed by entering the following code at the checkout: