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: Daigal Maujas
Country: Kenya
Language: English (Spanish)
Genre: Medical
Published (Last): 18 December 2015
Pages: 29
PDF File Size: 2.62 Mb
ePub File Size: 9.71 Mb
ISBN: 289-6-28920-198-4
Downloads: 89363
Price: Free* [*Free Regsitration Required]
Uploader: Kegami

May 10, Lisa rated it it was ok.

What’s more, it shows you what’s behind these fixes, so you’ll learn a lot about relational databases along the way. Apr 29, Rafalp rated it it was ok. Establish Primary Key Conventions Antipattern: Jun 06, Steven rated it really liked it.

For the reader with no experience in database design another book should be read first to gain a thorough understanding of the basics. Others, like SQL injection, are useful sections that try to dispel myths believed by experienced antipatgerns even now. Some of the patterns seem really out of date with current development strategies, but reviewing them to prevent implementing the sins of the past is still a good thing.

Working with data analytics, I found part 3 to be the most useful with Query Antipatterns. This is a catalog of what the author considers widespread bad practices in the use of relational databases and SQL programming. I’m so glad I found karwln gem. Fetch a Sample Row Antipattern: The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development. I wish I had read this book sooner.


SQL Antipatterns

The book is a must-have reference for any developer that antlpatterns to interact with a relational database system. Goodreads helps you keep track of books you want to read.

Jul 27, Vasil Kolev rated it really liked it Shelves: A sound coverage of typical SQL schema mistakes, with a useful exposition of the choices available in implementing inheritance. The book is mainly about some basic ideas that people should have in mind when designing database models.

Book Review – SQL Antipatterns – Vlad Mihalcea

Ebooks are You just can’t give them to other people or sell them. This book is obviously the product of many years of practical experience with SQL databases. Write Less Code Antipattern: Description Resources Extracts Author. I would recommend it especially to young web developers and all the “rockstar ninjas”, who think they do not need to read it. Oct 10, Ben Rand rated it really liked it Shelves: Posted on January 10, by vladmihalcea. It’s a nice compendium of practices to avoid with highly memorable titles “Pseudokey neat-freak” is my favoritebut I’m not sure this would be the first title one should read on the subject.

By continuing to use this website, you agree to their use.

Apr 27, Simon Fermor rated it really liked it. The book was easy to read and well explained. Now you can stamp out these common database errors once and for all. Also in the sections “regognizing the antipattern” the given examples did sound a bit stupid. This book was recommended by some programmer friends of mine, and proved to be a good read. I enjoyed the discussions around security and can appreciate that storing passwords in the database is a bad idea I’ve seen that more than once and have a better understanding on how to protect against SQL injection attacks.


Book Review – SQL Antipatterns

Sadly I have made many of the errors described in the book. So I knew most of the anti patterns and their solution. Most developers aren’t SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. Other reviewers said that the “Application development Anti-patterns” section is a hit or miss in regards of content quality and relevance.

Want to run krawin data access layer at warp speed? Return to Book Page. A great book, that is easy to read, and includes many important topics. What you need to know is that this is something worth reading and taking your time.