View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Trigger + database link - ProjeQtOr
 
 

Trigger + database link

More
13 Jun 2013 12:07 #1 by DjackJack
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

Please Log in or Create an account to join the conversation.

More
13 Jun 2013 14:10 - 13 Jun 2013 14:11 #2 by babynus
Replied by babynus on topic Re: Trigger + database link

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.

Babynus
Administrator of ProjeQtOr web site
Last edit: 13 Jun 2013 14:11 by babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.026 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.