Triggers/stored procedures

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

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!

My extensions:
[3.2][BETA] Anonymous Posts || [3.2][RC] Show User Activity

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 24745
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

User avatar
Toxyy
Registered User
Posts: 554
Joined: Mon Oct 24, 2016 3:22 pm
Contact:

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!

My extensions:
[3.2][BETA] Anonymous Posts || [3.2][RC] Show User Activity

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 24745
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: 963
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.

User avatar
Toxyy
Registered User
Posts: 554
Joined: Mon Oct 24, 2016 3:22 pm
Contact:

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!

My extensions:
[3.2][BETA] Anonymous Posts || [3.2][RC] Show User Activity

Post Reply

Return to “Extension Writers Discussion”

Who is online

Users browsing this forum: Baidu [Spider] and 9 guests