DEV Community

Discussion on: Thick Databases

Collapse
 
cassidymountjoy profile image
Cassidy Mountjoy

This was a pleasant read. I agree that databases can and should be used to enforce constraints in the business logic. What's unexpected in your application should be unexpected in your database. When database software doesn't enforce pk/fk, unique, or null constraints, it results in disconnect between the database and the application. Null names might be in there or there might be two names that are the same... sounds hectic.