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: Mikree Nikomuro
Country: Belarus
Language: English (Spanish)
Genre: Spiritual
Published (Last): 8 December 2018
Pages: 55
PDF File Size: 14.38 Mb
ePub File Size: 15.24 Mb
ISBN: 185-3-57405-281-8
Downloads: 73265
Price: Free* [*Free Regsitration Required]
Uploader: Shaktirn

This book shows you all the common mistakes, and then leads you through the best fixes. It is not about TSQL thought.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

More times than not, however, the bull team has to craft the SQL ourselves. Jan 18, Eric Hogue added it. As someone struggling to design my website’s database, this book hit the spot. This is a very readable book covering best practice in relational database design and some related areas of interest to software developers. Mar 29, Zlatin Stanimirov rated it really liked it. Get the most out of your persistence layer!

SQL Antipatterns by Bill Karwin

Fear of the Unknown Objective: Harmed with this knowledge, I should not repeat those mistakes zql I should have better arguments next time someone in my team is about to commit one. Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5the InterBase relational database, and the Enhydra Java application server.

Simplify the Relationship Chapter 8: Jul 27, Vasil Kolev rated it really liked it Shelves: As of late, I’ve been letting Hibernat I’m a software developer who gets paid mostly for working on the back end portion of solutions and I’ve worked in both small and large companies. Oct 15, Javier rated it it was bkll Shelves: May 10, Lisa rated it it was ok.


I thought this book was ok. Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern.

Name Columns Explicitly Part 4: That’s something that I’ve been trying to address a lot in projects and teams I participate in. 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 kadwin author considers widespread bad practices in the use of relational databases and SQL programming.

The book is good and has a good explanation of some very common errors and stupidities especially the chapter on trees was very interesting for me, as I haven’t seen some of the solutions.

Thanks for telling us about the problem. Bill has written an engaging, useful, important, and unique book.

Open Preview See a Problem? This boo Bill Karwin has helped thousands of people karwib better SQL and build stronger relational databases. Sep 09, Matias Fernandez rated it it was amazing. There is an appendix covering the principles of relational databases, which is useful as a reminder. I’m a software developer who gets billl mostly for working on the back end portion of solutions and I’ve worked in both small and large companies.


The book is written in a format that gives the antipattern as an example, th With many relational database systems available in the market, I find there is not much need to design a RDBMS product to the level this book gives. Application Development Antipatterns Chapter Skip to main content. I did not like it until I reached the solutions part bilo it all made sense. The final verdict is: The section on application development was a pleasant surprise to me because it talks about testing and possible migration strategies.

Antipattwrns really like how Bill has approached this book; it shows his unique style and sense of humor. I wish I had read this book sooner. Use Null as a Unique Value Chapter I would say it is an intermediate book about databases, so if you are a database expert there won’t be much to learn from it.

Bil Columns Unambiguously Chapter Simplify Database Architecture Antipattern: Very well written – concise and to the point text interspersed with both SQL and general software development bits of wisdom, followed by simple but not simplistic examples. To ask other readers questions about SQL Antipatternsplease sign up. Jan 18, Bill rated it liked it.

An especially helpful point is the legitimate use of the anti-pattern. Notify billl of follow-up comments by email.

Mar 02, Todor rated it really liked it. Trust No One Chapter Paperbackpages.