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: Arataxe Taulkis
Country: Singapore
Language: English (Spanish)
Genre: Finance
Published (Last): 8 February 2007
Pages: 387
PDF File Size: 8.20 Mb
ePub File Size: 10.43 Mb
ISBN: 893-5-52190-300-7
Downloads: 50804
Price: Free* [*Free Regsitration Required]
Uploader: Nijind

Perfect scenarios that people face in a corporate environment of washed up responsibilities and diplomatic immunity.

If you like books and love to build cool products, we may be looking for you. I regret that I did not read it before, because it will resolve some of issues during my work.

SQL Antipatterns

I fully understand that, like most tools, Hibernate is only as useful as the developer’s understanding of it which is why I try and read up on the ins and outs of Hibernate as much as I can. Now you can stamp out these common database errors once and for all. Antipatternz Karwin collected the most uses anti-patterns and explains how you can do a better job. I justify 1 week as enough time to understand the issues since I faced most of them in projects that had databases falling in at least anti-patterns.

Aug 02, Ronald rated it really liked it. I am a strong advocate of best practices.


SQL Antipatterns [Book]

As of late, I’ve been letting Hibernate do most of the heavy lifting for me, trusting that it will generate reasonable SQL and keep me out of hot water. I would have appreciated some concrete discussions on writing performant SQL queries.

Application Development Antipatterns Chapter Tailored to Fit Chapter 5: Then even if it mostly is harmful, there are situations when that pattern is the better solution.

Bill Karwin sqk helped thousands of people write better SQL and build stronger relational databases. It is antipattern at people with beginner-medium SQL experience.

The book is well-written, and I will likely require it of my students if I ever A very good book for younger developers, but I’ve learned most of these solutions already so I wanted a bit more out of this book. Establish Primary Key Conventions Antipattern: Store and Query Hierarchies Antipattern: This book was recommended by some programmer friends of mine, and proved to be a good read. A very good book which highlights all of the common anti patterns which are met when designing and antipattterns a database.

To find out more, including how to control cookies, see here: Partition and Normalize Part 2: Your email address kagwin not be published. Dinged also for nothing on de normalization and what you need to be careful about when doing tbis, after all de normalization can look like an anti pattern. Published July 2nd by Pragmatic Bookshelf first published June 25th This will not only result in slow queries but in hours wasted to figure out what you try to achieve.


I think the chapters are well written, and seem to cover a lot of issues a developer might encounter in his first few years of development. Sign me up for the newsletter! I would recommend it especially to young web developers and all the “rockstar ninjas”, who think they do not need to read it. With Safari, you learn the way you learn best. Restrict a Column to Specific Values Antipattern: This is a very readable book covering best practice in relational database design and some related areas of interest to software developers.

See No Evil Objective: It’s easy to fall into some of the anti-pattern traps that Bill Karwin discusses.

Book Review – SQL Antipatterns – Vlad Mihalcea

Those things are really important when discussing potentially dry topics. The catalogue of anti-patterns follows a bit the one from Refactoring: Chapter 25 “Magic Beans” is a bit weird. Feb 23, David rated it liked it. Source code Errata Releases.

I really like how Bill has approached this book; it shows his unique style and sense of humor. Avoiding the Pitfalls of Database Programming reads a heck of a lot like it sounds it would. In No Particular Order… Chapter