Difference between applcation and database validations
Application validation validate input filed value before the migrate the data in database.
In database validation such as datatype length (these are also validate in application side)but some validate likeunique relationship with other data and some null value are validate on database side.
Eg. like Django application unique username name validate in model label(database) validate.
required filed validate on form label or say application label validate
If i defined a database schema where some field cannot contain a NULL field
But i enter a NULL value, would the validation occur on the database software?
If that database server where run on a different machine, would be sent through the network before receiving an error response?
is this what the mean by Database validations and application validations?
Where application validations are enforced before data transmission?