
SQL antipatterns
Bill Karwin · 2010
Programming and computer science › Databases and distributed data
#1,160 most recommended
Hacker News
43
mentions by 37 people · top 8% of 15,732 books
Open Library
4.33★★★★★★★★★★
3 ratings · 7 want to read
Wikipedia
—
No article yet
About the book
A practical guide to recurring mistakes in SQL database design, queries, and the application code that uses them. It covers logical design such as tree structures, entity-attribute-value tables, and polymorphic associations, along with physical design, query writing, and application-level habits. It is aimed at readers who already know SQL basics and want to see where common designs go wrong. Many database problems come from familiar solutions that look reasonable at first and fail as data, users, or queries grow. For each named antipattern, the book shows the naive approach, explains the specific way it breaks, and offers a relational alternative with its tradeoffs. It also argues that some antipatterns have legitimate uses in narrow cases, so the goal is informed choice rather than blanket avoidance.
Written by Claude from what it knows of this book.
What Hacker News says 84% recommend · 3% critical
In the commenters’ own words
> But even then, I'm afraid I am not producing the software to the highest standards of the industry since we don't have any rigorous cross-checking, I…
The relational model, by being based directly on set theory and first order logic, is the most robust method for managing data today. Yes, SQL is not the best…
What Open Library readers say 4.33 from 3 ratings
- 51
- 42
- 30
- 20
- 10
- 7 want to read
- 0 reading
- 4 have read
Only 3 ratings: treat the average as a hint.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
Details
- First published
- 2010
- ISBN
- 9781934356555
- Editions known
- 4 at Open Library
- Open Library
- OL16178433W
Antipatterns (Software engineering)SQL (Computer program language)
Read next: its neighbours on the mosaic
Clean ArchitectureRobert C. Martin · 2017 · recommended by 47 people · 5 people recommended both
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · 2 people recommended both
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 5 people recommended both
Patterns of Enterprise Application ArchitectureMartin Fowler · 2002 · recommended by 34 people · 2 people recommended both
Grokking AlgorithmsAditya Y. Bhargava · 2016 · recommended by 42 people · similar by subject and what people say about it
A Philosophy of Software DesignJohn K. Ousterhout · 2018 · recommended by 163 people · 4 people recommended both
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Programming PearlsJon Bentley · 1999 · recommended by 158 people · 2 people recommended both
Clean CodeRobert C. Martin · 2008 · recommended by 298 people · 5 people recommended both
Design PatternsErich Gamma · 1994 · recommended by 95 people · similar by subject and what people say about it
Domain-Driven DesignEric Evans · 2003 · recommended by 104 people · similar by subject and what people say about it
Smalltalk best practice patternsKent Beck · 1997 · recommended by 17 people · similar by subject and what people say about it
Refactoring to PatternsJoshua Kerievsky · 2004 · recommended by 15 people · similar by subject and what people say about it
Design Patterns in RubyRuss Olsen · 2007 · recommended by 15 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
Rails antipatternsChad Pytel · 2009 · recommended by 6 people · similar by subject and what people say about it
Effective JavaJoshua Bloch · 2001 · recommended by 172 people · 3 people recommended both
AntiPatternsWilliam J. Brown · 1998 · recommended by 4 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
Analysis PatternsMartin Fowler · 1996 · recommended by 6 people · similar by subject and what people say about it
Head First design patternsEric Freeman · 2004 · recommended by 65 people · similar by subject and what people say about it