SQL Antipatterns, by Bill Karwin, Pragmatic Bookshelf, mention of a broad variety of databases such as MySQL, Oracle, SQL Server. Common blunders of SQL database design, queries, and software SQL Antipatterns Strike Back Bill Karwin 1 Monday, April 20, 1. Bill Karwin has helped thousands of people write better SQL and buildstronger relational databases. Now he’s sharing his collection of antipatterns–the most.

Author: Bratilar Kajijar
Country: Malaysia
Language: English (Spanish)
Genre: Health and Food
Published (Last): 3 March 2013
Pages: 155
PDF File Size: 10.92 Mb
ePub File Size: 13.92 Mb
ISBN: 216-2-85668-330-7
Downloads: 24637
Price: Free* [*Free Regsitration Required]
Uploader: Tugal

Bll easy to fall into some of the anti-pattern traps that Bill Karwin discusses. The book would shine even brighter in the solutions part if a way better relational database as PostgresSQL and a programming language with antipatternns as in style, wit, manners, good intentions were used.

This book is full of good examples of bad practices including some that SEEM like they would help you out and ways that you can avoid them.

SQL Antipatterns [Book]

Even better, it explains in dept why they are errors and the problems you might have because of these errors. Now you can stamp out these common database errors once and for all. Even better, it will also show you how antiatterns fix them, and how to avoid these and other problems in the future.

I was hoping to get a little more out of this book. Lists with This Book. Perfect scenarios that people face in a corporate environment of washed up responsibilities and diplomatic immunity. Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. Simplify the Relationship Chapter 8: Start Free Trial No credit card required. Beginners will not really understand what’s happening there.


Books by Bill Karwin. Create an Intersection Table Chapter 3: I struggled for a long time with a database that had a large tree structure, so I’m always looking for better ways of dealing with trees in databases.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. The final verdict is: For instance, the database backing a blog whose posts can have an arbitrary number of tags would have a column TAGS with entries such as ‘tag1, tag2, This is a catalog of what the antipatterna considers widespread bad practices in the use of relational databases and Sqll programming.

More times than not, however, the development team has to craft the SQL ourselves. Nov 25, Horia rated it really liked it Shelves: Store and Query Hierarchies Antipattern: This boo Bill Karwin has helped thousands of people ,arwin better SQL and anitpatterns 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. Oct 21, Turner rated it really liked it. With many relational database systems available in the market, I bbill there is not much need to design a RDBMS product to the level this book gives.

For the reader with no experience in database design another book should be read first to gain a t This is a very readable book covering best practice in anfipatterns database design and some related areas of interest to software developers.


Most antipatterns are about misunderstandings on good database design; for example, the author discusses such timeless classics as implementing many-to-many relationships by putting multiple comma-separated values in a row. In No Particular Order… Chapter SQL Antipatterns should become a useful tool for DBAs and database programmers to help them create well-designed databases and applications…and to help us eliminate these common errors from our database implementations.

SQL Antipatterns by Bill Karwin

To find out more, including how to control cookies, see here: Tailored to Fit Chapter 5: And if you’ve written the database interface layer for apps, it might be partially interesting for you. I would have appreciated some concrete discussions on writing performant SQL queries.

This book shows you all the common mistakes, and then leads you through the best fixes. Bill has written an engaging, useful, important, and unique book. The “Polymorphic associations” anti-patterns really resonated with me.

SQL Antipatterns

Model the Subtypes Chapter 7: Avoiding the Pitfalls of Database Programming reads a heck of a lot like it sounds it would. I am a strong advocate of best practices. Sign me up for the newsletter! Return to Book Page. A great book, that is easy to read, and includes many important topics. The chapters are very cohesive and are easy to consume in a single sitting. View table of contents. Aug 02, Ronald rated it really liked it.