← Back to team overview

maria-discuss team mailing list archive

will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)

 

Hi,

I was wondering if mariadb plans to overcome mysqls limitations such as
- foreign key operations do not start triggers
- triggers can’t be recursive (error 1442)

I know that mariadb wants to be compatible with mysql but maybe these features could be optional?
The mysql/mariadb comparison shows additional features which wont break compatibility I guess because they don’t exist in mysql (yet?).
But besides additional features, is there a chance that mariadb could ever overcome limitations?
Is this even a goal of this project?

So far I only found postgres to support these features.

Background of this question:
I am developing an object relational mapper and my goal is to have the database enforce the consistency.
So triggers and foreign key constraints working together are vital for this.

regards
Ludwig

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail


Follow ups