DeepRead
Cover of SQL antipatterns

SQL antipatterns

Bill Karwin · 2010

Programming and computer science › Databases and distributed data

#1,160 most recommended

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

051020102015202020252020 peak · 8
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 4.33 from 3 ratings

  1. 51
  2. 42
  3. 30
  4. 20
  5. 10
  • 7 want to read
  • 0 reading
  • 4 have read

Only 3 ratings: treat the average as a hint.

Open Library’s page for the book

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)

Explore in the mosaic

Read next: its neighbours on the mosaic