F/OSS Database experiences & recommendations

[Dan Coutu]

On Wed, 2004-03-17 at 16:46, Travis Roy wrote:
> > - 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.

Interesting! I had not heard that they were planning to support triggers too.
Thanks for pointing that out.

-- 

Dan Coutu
Managing Director
Snowy Owl Internet Consulting, LLC
http://www.snowy-owl.com/