MySQL 5.0
MySQL AP the group that handles development of the MySQL database is looking to release a major milestone in this software package's history. Things to look for in this release
- Triggers
- Views
- Stored procedures.
Stored Procedures for Enterprise Applications
MySQL 5.0 adds support for stored procedures, which can facilitate the adoption of MySQL for existing legacy database applications. Stored procedures are SQL (Structured Query Language) statements that are stored in the database in compiled form so that they can be accessed in a standard way across multiple applications. MySQL stored procedures are based on SQL:2003, a common standard for syntax, data structures, and retrieval processes of SQL databases. In addition to better accessibility, stored procedures can improve data integrity and developer productivity.
The stored procedures functionality in MySQL 5.0 also integrates server side cursor support. MySQL cursor support inside stored procedures and functions is now only limited by available memory, which further improves scalability.
MySQL 5.0 also includes new functionality to enhance portability and migration, internationalization and general usability.
“"We are pleased to make version 5.0 available to the community, as it addresses strong user demand for stored procedures",” stated Michael (Monty) Widenius, MySQL AB co-founder and CTO. "While it is designed to support more enterprise applications, 5.0 retains the MySQL hallmarks of high performance and stability, so it continues to be ideal for Web sites, packaged applications and other database deployments.”"