F/OSS Database experiences & recommendations

[Travis Roy]

> - You can define triggers (MySQL can't do this).

From: http://www.mysql.com/products/mysql/

"Stored procedures and triggers

     Stored procedures allow you to create functions and subroutines 
that run on the server. This makes it possible to grant access to 
specific queries without granting carte blanche access to the underlying 
data, or validate data in the database before it is stored. Triggers can 
be configured to fire when certain conditions are fulfilled.

     The MySQL database server will provide hooks for implementing 
stored procedures in multiple languages, as well as including support 
for the Persistent Stored Modules syntax defined as part of ANSI SQL-99.

     Support for stored procedures was added in version 5.0, and support 
for triggers will be added in version 5.1."

Plus they have some documentation for it already.

http://www.mysql.com/documentation/maxdb/a7/41ee0b605911d3a98800a0c9449261/content.htm

A friend of mine that uses MySQL says that it's in the dev version already.