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: Grozuru Kasho
Country: Ghana
Language: English (Spanish)
Genre: Software
Published (Last): 1 December 2005
Pages: 61
PDF File Size: 18.72 Mb
ePub File Size: 20.27 Mb
ISBN: 818-9-97162-590-6
Downloads: 88193
Price: Free* [*Free Regsitration Required]
Uploader: Yozshurr

It’s a very good book for the people, who just learned SQL. Some are mistakes I would expect only a real newbie to make. It starts off as an attack to ActiveRecord without focus and then transforms into something more reasonable.

SQL Antipatterns [Book]

Want to Read saving…. Sep 25, Tom rated it antipattsrns liked it. Even better, it explains in dept why they are errors and the problems you might This books describes common errors developers make when dealing with databases. If you are working with relational databases definitely give it a read.

Book Review – SQL Antipatterns

I thought this book was ok. As I previously explainedcontributing to StackOverflow antiipatterns a great way to become an expert on various programming-related topics, and Bill Karwin is definitely an expert in this field.

Tailored to Fit Chapter 5: The source code is not hosted on GitHub but nothing is ever perfect. Mar 29, Zlatin Stanimirov rated it really liked kagwin. Avoiding the Pitfalls of Database Programming hill a heck of a lot like it sounds it would.

Goodreads helps you keep track of books you want to read. The author uses good, real world, examples written in clear language.


I was pleasantly surprised to see all the code sections in the book having a code example file path that you can instantly find if you download the source code zip from the site.

SQL Antipatterns

I would say it bi,l an intermediate book about databases, so if you are a database expert there won’t be much to learn from it. Some chapters felt a bit too obvious, but that is very subjective.

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. Antipatternss in the sections “regognizing the antipattern” the given examples did sound a bit stupid.

Mar 04, Johnny Graber rated it really liked it.

Simplify Database Architecture Antipattern: Those things are really important when discussing potentially dry topics. The book is mainly about some basic ideas that people should have in mind when designing database models. Glad you liked my book Vlad! It’s a pretty good book on SQL.

SQL Antipatterns by Bill Karwin

Although I’ve rarely seen any of the antipatterns in practice, the greatest benefit from reading this book has been in the solution sections which always listed several approaches to thwarting the antipattern and thus never failed to gave me a new perspective on doing things. Mar 02, Todor rated it really liked it.

I didn’t like the usage of php inside the book. Either way, the solutions is mature and introducing an abstraction above antipattfrns ActiveRecord objects usage in controllers is reasonable. What you need to know is that this dql something worth reading and taking your time.


I think this is where people make most of their bad decisions in RDB usage. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

By using this site you understand and agree to our use of cookies, our Terms Of Useand Privacy Policy. 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. Ebooks are You just can’t give them to other people or sell them.

Return to Book Page. I did not like it until I reached the solutions part and it all made sense. Developers and DBAs alike would benefit from this read. I picked it up because of its premise common mistakes and the chapter on trees, which while interesting and useful to others I’ve recommended the book to wasn’t as insightful as I’d hoped. Jun 06, Steven rated it really liked it. Working with data analytics, I found part 3 to be the most useful with Query Antipatterns.

Store a Salted Hash of the Password Chapter 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.

I am a strong wntipatterns of best practices.