SqlPattern

Sql-related IdiomOrPattern can help those of us who are using relational database for more than a persistent storage for objects. They are applicable only in StructuredQueryLanguage, which is, however, the only relational language around, so they can be considered patterns.

Some patterns are:

• ThinkSqlAsConstraintSatisfaction
• TemplateTables
• SliceResultVertically
• TreeInSql

See also SqlMyopia - hopefully patterns help to cure it ;)

---

Table-Oriented GOF-like patterns: http://geocities.com/tablizer/prpats.htm

---

See Also: SqlFlaws, DatabaseBestPractices

CategorySqlProgramming