Triggers/stored procedures

Discussion forum for Extension Writers regarding Extension Development.
Post Reply
Toxyy
Registered User
Posts: 456
Joined: Mon Oct 24, 2016 3:22 pm

Triggers/stored procedures

Post by Toxyy » Sun Jun 17, 2018 9:18 pm

Does phpbb support triggers/stored procedures for mysql?
I am a web developer/administrator, specializing in forums. If you have work you need done or are too lazy to do, pm me!

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 24398
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Triggers/stored procedures

Post by Paul » Mon Jun 18, 2018 6:20 am

No
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

Toxyy
Registered User
Posts: 456
Joined: Mon Oct 24, 2016 3:22 pm

Re: Triggers/stored procedures

Post by Toxyy » Mon Jun 18, 2018 6:23 am

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

Are there plans to do so in the future?
I am a web developer/administrator, specializing in forums. If you have work you need done or are too lazy to do, pm me!

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 24398
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Triggers/stored procedures

Post by Paul » Mon Jun 18, 2018 7:40 am

No, not all supported DBMS's support triggers and stored procedures.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
JoshyPHP
Code Contributor
Posts: 944
Joined: Mon Jul 11, 2011 12:28 am

Re: Triggers/stored procedures

Post by JoshyPHP » 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.
I wrote the thing that does BBCodes in 3.2.

Toxyy
Registered User
Posts: 456
Joined: Mon Oct 24, 2016 3:22 pm

Re: Triggers/stored procedures

Post by Toxyy » Mon Jun 18, 2018 11:38 pm

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.
I am a web developer/administrator, specializing in forums. If you have work you need done or are too lazy to do, pm me!

Post Reply

Return to “Extension Writers Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests