SQL antipatterns: avoiding the pitfalls of database programming
โ Scribed by Karwin, Bill
- Publisher
- Pragmatic Programmers, LLC, The
- Year
- 2014
- Tongue
- English
- Series
- Pragmatic programmers
- Edition
- Book version P4.0
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
Jaywalking -- Naive trees -- ID required -- Keyless entry -- Entity-attribute-value -- Polymorphic associations -- Multicolumn attributes -- Metadata tribbles -- Rounding errors -- 31 flavors -- Phantom files -- Index shotgun -- Fear of the unknown -- Ambiguous groups -- Random selection -- Poor man's search engine -- Spaghetti query -- Implicit columns -- Readable passwords -- SQL injection -- Pseudokey neat-freak -- See no evil -- Diplomatic immunity -- Magic beans.
โฆ Table of Contents
Jaywalking --
Naive trees --
ID required --
Keyless entry --
Entity-attribute-value --
Polymorphic associations --
Multicolumn attributes --
Metadata tribbles --
Rounding errors --
31 flavors --
Phantom files --
Index shotgun --
Fear of the unknown --
Ambiguous groups --
Random selection --
Poor man's search engine --
Spaghetti query --
Implicit columns --
Readable passwords --
SQL injection --
Pseudokey neat-freak --
See no evil --
Diplomatic immunity --
Magic beans.
๐ SIMILAR VOLUMES
SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasi