SQL Antipatterns: Avoiding the Pitfalls of Database Programming

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.

Table of Contents

Chapter 1 Introduction

Part 1 Logical Database Design Antipatterns
Chapter 2 Jaywalking
Chapter 3 Naive Trees
Chapter 4 Id Required
Chapter 5 Keyless Entry
Chapter 6 Entity-Attribute-Value
Chapter 7 Polymorphic Associations
Chapter 8 Multicolumn Attributes
Chapter 9 Metadata Tribbles

Part 2 Physical Database Design Antipatterns
Chapter 10 Rounding Errors
Chapter 11 31 Flavors
Chapter 12 Phantom Files
Chapter 13 Index Shotgun

Part 3 Query Antipatterns
Chapter 14 Fear Of The Unknown
Chapter 15 Ambiguous Groups
Chapter 16 Random Selection
Chapter 17 Poor Man’S Search Engine
Chapter 18 Spaghetti Query
Chapter 19 Implicit Columns

Part 4 Application Development Antipatterns
Chapter 20 Readable Passwords
Chapter 21 Sql Injection
Chapter 22 Pseudokey Neat-Freak
Chapter 23 See No Evil
Chapter 24 Diplomatic Immunity
Chapter 25 Magic Beans

Part 5 Appendixes
Appendix.A Rules Of Normalization
Appendix.B Bibliography