General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Madya
The question is whether you control data entry with a rule a) enforced in the application code or b) by the database.
My take is that there is no best answer, but rather a case of perspective. SQL and Oracle people will probably say use table rules. I go the otherway and try to have a business rule in the code to handle it. Why? Because I might want to switch database engines (VFP to MS SQL or mySQL). My belief is that I will have less refactoring to do if I enforce all of the rules in the application, fewer places to look when something goes wrong. Not to be misleading, I do use RI, but the triggers refer to code.
- Don Lowrey
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only