Page 1 of 1

Triggers/stored procedures

Posted: Sun Jun 17, 2018 9:18 pm
by Toxyy
Does phpbb support triggers/stored procedures for mysql?

Re: Triggers/stored procedures

Posted: Mon Jun 18, 2018 6:20 am
by Paul
No

Re: Triggers/stored procedures

Posted: Mon Jun 18, 2018 6:23 am
by Toxyy
Paul wrote:
Mon Jun 18, 2018 6:20 am
No
Thank you for the clarification :)

Are there plans to do so in the future?

Re: Triggers/stored procedures

Posted: Mon Jun 18, 2018 7:40 am
by Paul
No, not all supported DBMS's support triggers and stored procedures.

Re: Triggers/stored procedures

Posted: Mon Jun 18, 2018 10:24 pm
by JoshyPHP
What kind of support would you expect? AFAIK you can create triggers and run any SQL commands using a custom migration.

Re: Triggers/stored procedures

Posted: Mon Jun 18, 2018 11:38 pm
by Toxyy
JoshyPHP wrote:
Mon Jun 18, 2018 10:24 pm
What kind of support would you expect? AFAIK you can create triggers and run any SQL commands using a custom migration.
To be honest I'm not quite sure, I've been looking into sql recently and having to loop through a lot of things so triggers/stored procedures seemed good for what I was doing and there are solutions using them, and more complicated ones that don't. I think I'll be fine without them, and postgre and others have cte's which can take their place anyways. I just wanted to ask before I started to try and use them only to find out that it was the wrong way to go about things.