Re: Where to do Data Validation?

Vijai Kalyan wrote:

> I have a question about data validation. I have been reading some
> articles that indicate that data validation should be done at the
> application level (while also having integrity constraints in the
> database) whereas other articles mention that data validation should
> be done only at the database level because that's what integrity
> constraints are for.
>
> Any for or against on these two viewpoints?

As Mark and Frank suggest, do both. If you have to pick one or the other, definitely do it at the database. Fortunately, you don't have to choose one or the other.

My take is that you do validation at the database to enforce data integrity, and you do validation at the application level to provide a more pleasant experience for the user.

//Walt Received on Mon Nov 19 2007 - 15:18:08 CST