Re: OO and relation "impedance mismatch"
Date: 5 Oct 2004 08:32:43 -0700
Message-ID: <1096990363.097865.279760_at_h37g2000oda.googlegroups.com>
Kenneth Downs wrote:
> > Presumably you don't mean that the tables wouldn't ALSO have
primary,
> > unique, foreign key constraints do you?
>
> Correct, they would not also have the constraints. The purpose is to
> completely control error reporting and have it behave the same way
across
> all platforms, and declarative constraints don't let me do that.
Well I don't agree with that. Have triggers IN ADDITION to the
constraints if you like, to improve the "user experience", but I would
NEVER dispense with such fundamental integrity constraints as primary
keys, foreign keys etc. Why?
manner
No, what you are doing is throwing away decades of development by the
DBMS vendors and making yourself decades of work, plus a database that
won't perform as well as it should, and will likely have plenty of data
corruption in it.
IMHO, I suppose I'd better add!