SQL AntiPatterns

From Technical Presentations

Jump to: navigation, search
SQL AntiPatterns
Presenter(s): Bill Karwin, Product Engineering Manager, Zend Technologies
Where: MySQL Conference and Expo 2007 (description)
When: April 24, 2007
Topics: MySQL, Design Patterns
Download: PowerPoint

[edit] Description

Presentation about AntiPatterns in MySQL-based applications. Karwin gave a very similar presentation, SQL Antipatterns, at the following year's conference.

[edit] AntiPatterns reviewed

  • Using comma-separated lists
  • Ambigous GROUP BY
  • Entity-Attribute-Value (EAV) tables
  • Letting users crash your server
  • Security issues from SQL injection
  • Forcing primary keys to be contiguous
Facts about SQL AntiPatternsRDF feed
Date April 24, 2007  +
PowerPoint Slides URL http://conferences.oreillynet.com/presentations/mysql07/karwin_AntiPatterns.ppt  +
Presented at MySQL Conference and Expo 2007  +
Presenter Bill Karwin  +
Presenter Company Zend Technologies  +
Screenshot SQL AntiPatterns.jpg  +
Topic MySQL  +, and Design Patterns  +
Retrieved from "http://www.techpresentations.org/SQL_AntiPatterns"
Personal tools