After using MySQL 4.1 for quiet a while at work and seeing how it is getting closer to what most DBs demand now adays, I’m excited about this new release. I learned databases in Oracle and this release brings the Open Source database poster child closer to that level. Some of the features include:
- Views (both read-only and updateable views)
- Stored Procedures and Stored Functions, using the SQL:2003 syntax, which is also used by IBM’s DB2
- Triggers (row-level)
- Server-side cursors (read-only, non-scrolling)
Let’s hope MySQL’s main feature (performance) was not compromised with these new changes.