What do you see as the pros and cons of each approach? Andy
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matt Liotta Sent: Thursday, November 13, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] Best Practices Business Rules CFC, Stored Procs, Constraints Here is the same response I gave on my blog. No matter what your architecture, if you are going to use a relational database constraints should always be in place to ensure the integrity of the database. I don't consider constraints to be business logic. While there may be a business reason for constraints, I feel constraints are part of the schema, which is designed to provide a data store for an application. So the question is really should business logic be in stored procedures at the database level or objects at the application level? I think that completely depends on the chosen architecture for said application. Both have advantages that should be weighed. However, I believe that it isn't useful to place business logic in both objects and stored procedures; just pick one or the other. An application will be much more maintainable if the business logic is all in the same place. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
