Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
All processing is done through php, the base just used to store information. That does not bind some table between them (it improved safety)? And most importantly why not put up most of the treatments through trigger, it will automate a lot of treatment more quickly, it will reduce the code and would secure
All processing is done through php, the base just used to store information.
Yes.
That does not bind some table between them (it improved safety)?
For fluency on upgrading and during imports. And also because of refType / refId link type : cannot be represented by a foreign key as target table in not fix.
why not put up most of the treatments through trigger
Because the products wished to be Database independent. MySql is not the only target, and triggers language change from one database to another. Today, it is compatible with MySql and PostgreSql. Possibly in some future, it could be also Oracle compatible.
it will automate a lot of treatment more quickly
Possibly, but not sure
it will reduce the code
No, just move it from PHP to database
and would secure
Really not sure about this.