Название: SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Version P4.0)
Автор: Bill Karwin
Издательство: Pragmatic Bookshelf
Год: August 2014
Страниц: 309
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

What is an antipattern? An antipattern is a technique that is intended to solve a problem but that often leads to other problems. An antipattern is practiced widely in different ways, but with a thread of commonality. People may come up with an idea that fits an antipattern independently or with help from a colleague, a book, or an article. Many antipatterns of object-oriented software design and project management are documented at the Portland Pattern Repository.

SQL Antipatterns describes the most frequently made missteps I’ve seen people naively make while using SQL as I’ve talked to them in technical support and training sessions, worked alongside them developing software, and answered their questions on Internet forums. Many of these blunders I’ve made myself; there’s no better teacher than spending many hours late at night making up for one’s own errors.

Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.

Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the anti​patterns in terms of logical database design, physical database design, queries, and application development.

The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.

SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.

Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. 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.

Who This Book Is For:
I’m writing SQL Antipatterns for software developers who need to use SQL so I can help you use the language more effectively. It doesn’t matter whether you’re a beginner or a seasoned professional. I’ve talked to people of all levels of experience who would benefit from the subjects in this book. You may have read a reference on SQL syntax. Now you know all the clauses of a SELECT statement, and you can get some work done. Gradually, you may increase your SQL skills by inspecting other applications and reading articles. But how can you tell good examples from bad examples? How can you be sure you’re learning best practices, instead of yet another way to paint yourself into a corner?