[eluser]gte451f[/eluser]
I'm designing a number of applications and have run into a delima that I'd like to get your opinion on.
When developing business applications do you think it's a good idea to use built in features like cascade, triggers and stored procedures?
Let's keep the discussion focused,so comment on Cascading deletes or updates.
Is this better done in PHP or in the database?
I can think of a few pros...which I'll update if others add their points.
PHP Cascades:
Database independent, that is you can more easily switch RDMS if deletes are in PHP code.
One codebase, no need to check the database for additional programming logic.
No need to learn RDMS specific logic since it's all done in PHP.
Database Cascades:
Faster
The RDMS might include built in Roll Back for failed transactions.
It's probably easier to implement in the DB than app code.