Re: Where to do Data Validation?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 20 Nov 2007 09:57:44 -0800
Message-ID: <1195581457.432688@bubbleator.drizzle.com>

Brian Tkatch wrote:
>
> If the database is just a convenient place to store data, it is the
> equivalent of having a flat file with speedy querying. What protection
> is there against a flat file? Probably backups. Same here.

Nonsense. Total and complete nonsense. What you've written is roughly the equivalent of "if the car is just a way to move from place to place it doesn't need an emergency brake."

Your statement is totally irresponsible. If someone can use 3x5 cards then by all means they should use 3x5 cards. If they have purchased Oracle licenses and hired trained Oracle professionals their data, by definition, is more important than your mother's cookie recipes.

>>> If the program is just a convenient way to work with the data, and the
>>> database is what matters, put the validation in the database.
>> And, yet, why should the users be subjected to what can be 'terse' and
>> 'cryptic' error messages from Oracle when the application can, and
>> should, validate the input data for proper format?  Validation should
>> occur here, too, regardless.

>
> Methinks you have never seen error messages before. Most of the time
> the application is even more cryptic!

Irrelevant and offensive nonsense.

>> The answer to the question, then, is validate in both, and there is no
>> conditional response to that.  Failure to do so is carelessness and
>> poor design, in my opinion.

>
> I do not disagree. But i have yet to see it happen.

Then you live in a cave.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Nov 20 2007 - 11:57:44 CST