Changes

m
Line 322: Line 322:  
Database triggers are not portable. Compatibility may be broken when upgrading your version of your database, database triggers are often not included into backup tools, database triggers need permissions that you may not have (and should not have) on a common secured database, database triggers means also that you include some "business rules" of your application into the database where most other rules are managed by the code itself creating conflict or code that can't be debugged with a step by step debugger, ...
 
Database triggers are not portable. Compatibility may be broken when upgrading your version of your database, database triggers are often not included into backup tools, database triggers need permissions that you may not have (and should not have) on a common secured database, database triggers means also that you include some "business rules" of your application into the database where most other rules are managed by the code itself creating conflict or code that can't be debugged with a step by step debugger, ...
 
There is tons of reason why we do not recommand to use database triggers in your own development.  
 
There is tons of reason why we do not recommand to use database triggers in your own development.  
Using Database triggers can save you time when you make development but is a very bad practive that is forbidden. External modules that uses Database triggers may also be refused on the market place since it won't work for more than 50% of users.
+
Using Database triggers can save you time when you make development but is a very bad practice, so is forbidden as it is not compatible with the high level of quality of code expected by Dolibarr team. External modules that uses Database triggers may also be refused on the market place since it won't work for more than 50% of users.
    
==Mysql specificities==
 
==Mysql specificities==