Press Release


Print. Print

Email. Email press release link

June 15, 2010

SQL Antipatterns--New from Pragmatic Bookshelf

Request review copy

Raleigh, NC—Applications that store data often end up using SQL, either directly or through a mapping layer. Well, here's a sad secret—most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong.

Author Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns—the most common errors he's identified in those thousands of requests for help in his new book.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Bookshelf, $34.95 USD) shows you all the common mistakes and leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.

Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development.

The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.

SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.

Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert.

You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.

For a review copy or more information please email pragprogpr@oreilly.com. Please include your delivery address and contact information.

Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server.

Additional Resources
For more information about the book, including code, errata, discussions, full table of contents, excerpts from the book and more, see the catalog page for SQL Antipatterns.

SQL Antipatterns
Publisher: Pragmatic Bookshelf
Bill Karwin
ISBN: 9781934356555, 300 pages,
Book Price: $34.95 USD
order@oreilly.com
1-800-998-9938
1-707-827-7000


About Pragmatic Bookshelf
Pragmatic Bookshelf is an imprint of the Pragmatic Programmers, LLC. Our titles are distributed to bookstores internationally by O'Reilly Media.

The Pragmatic Bookshelf features books written by developers for developers. The titles continue the well-known Pragmatic Programmer style, and continue to garner awards and rave reviews. As development gets more and more difficult, the Pragmatic Programmers will be there with more titles and products to help programmers stay on top of their game.

About O'Reilly

O'Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O'Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.

Return to: O'Reilly Press Room

Recent Press Releases


2/26/14 Solid Heralds the Merging of the Physical and Virtual Worlds
2/4/14 O'Reilly Media & Safari Books Online Donate Over $100 Million in Technology Education Resources to US K-12 Schools
12/3/13 Windows 8.1: The Missing Manual--New from O'Reilly Media
11/20/13 iPad: The Missing Manual, 6th Edition--New from O'Reilly
11/7/13 Designing for Behavior Change--New from O'Reilly

Press Release Archive »

Resources

Press Contacts

Corporate

Sara Winge
800/998-9938 x7109

Media Relations - North America

Sara Peyton
800/998-9938 x7118

Media Relations - Germany

Corina Pahrmann
+49-221-973160-22

Media Relations - Japan

Kenji Watari
+81-3-3356-5227

Media Relations - United Kingdom

Josette Garcia
+44 (0)1252-721284

Media Relations - Conferences

Maureen Jennings
800/998-9938 x7083