>>Personally, I don't favour this approach as I like to separate business logic out of the database. This makes it easier to port your application onto other databases etc.
>
>I don't understand this. How can you separate business logic away from the database? By definition the database is a business entity. It seems to me that by keeping the business logic with the database and excluded from any app, you can use several different apps with the same database.
What happens if you have to switch databases? Pulling the logic out of the database and the main app allows it to be used by multiple apps and multiple databases.