Linked by Eugenia Loli on Tue 26th Oct 2004 22:58 UTC
Databases MySQL announced the general availability of MySQL 4.1. Certified by the company as production-ready for large-scale enterprise deployment, this significant upgrade to the MySQL database server features advanced querying capabilities through subqueries, faster and more secure client-server communication, new installation and configuration tools, and support for international character sets and geographic data.
Permalink for comment
To read all comments associated with this story, please click here.
by Uno Engborg on Wed 27th Oct 2004 15:08 UTC

MySQL have had transactions for quite some time now.
However transactions are not a all you need to keep your database consistent. Things like check constraints (have no idea if its supported in MySQL), triggers and stored procedures to build such triggers is very useful to keep your data in shape.

Even though you can compensate for the lack of stored procedures in your applications, it is nice to be able to have your business rules implemented close to the data. It makes the risk of breaking them much less when you modify your applications, net to mention that the SQL like languages used in many database products is far more effective and compact than most programinglanguages used outside of the database.