RE: SQL Constraints (was "losing out 'cuz 'o grammar")

["Bullard, Claude L (Len)" <clbullar@ingr.com>]

The problem is that the app sometimes 
gets written before the schema.  Then it is 
a real nightmare to publish a schema whose 
constraints reveal the boilerplate in welded 
code. Doesn't happen?  Happens every day.

There is no substitute for experience and 
no cure for bad management except entropy.

Len 
http://www.mp3.com/LenBullard

Ekam sat.h, Vipraah bahudhaa vadanti.
Daamyata. Datta. Dayadhvam.h


-----Original Message-----
From: Charles Reitzel [mailto:creitzel@mediaone.net]

Schemas and database stored procedures do help.  But they (or anyplace the
logic happens to be kept) are just as susceptible to ad hoc updates.  Again,
it comes down to engineering management.  

The weight of the world does not rest on the schema language designers'
shoulders.  Somebody still has to write the app.