SQL Antipatterns Strike Back

Architecture and Technology, Tutorial
Location: Ballroom D Level: Intermediate
Average rating: ****.
(4.00, 2 ratings)

The database is the foundation of any innovative project, but you can’t innovate if you’re making the same mistakes of yesteryear.

Bill Karwin has supported SQL developers for more than twelve years. Some blunders occur so frequently that we call them antipatterns: brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Bill describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.

This revises Bill’s popular tutorial at MySQL Conference 2008, and adds many new topics. The presentation includes the following topics:

Database Design Antipatterns:

  • Entity-Attribute-Value
  • Polymorphic Associations (NEW!)
  • Storing tree-structure data (NEW!)
  • Metadata Tribbles
  • Rounding errors in FLOAT
  • Using ENUM
  • Indexes are Magical (NEW!)
  • Using NULL (NEW!)

Query Antipatterns:

  • Using GROUP BY ambiguously
  • Using HAVING instead of WHERE
  • Goldberg Machine queries (NEW!)
  • Using JOIN… or Not (NEW!)

Application Development Antipatterns:

  • Parameter Facade
  • Phantom Side Effects
  • See No Evil (NEW!)
  • Magic Beans (NEW!)
  • Diplomatic Immunity (NEW!)
Photo of Bill Karwin

Bill Karwin

Karwin Software Solutions

Bill Karwin has been a software developer and technical writer since 1988. He is widely known for his talent for explaining complex topics and practical techniques with accuracy and a little humor. Recently he worked as the Product Engineering Manager developing the award-winning Zend Framework library for PHP 5.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.