MySQL Version 4.1 - "Production-Ready"

csn

Features & Benefits of MySQL 4.1

MySQL version 4.1 offers dozens of important product enhancements and new features, including support for:

* Subqueries and derived tables -- allowing users to search complex data sets with greater ease and efficiency;
* A significantly faster and more flexible client-server protocol with support for prepared statements, providing optimized query execution and improved warning information;
* New GUI installer and configuration wizards for Linux and Windows, making it easier for developers to set up and optimize their MySQL databases;
* Encrypted client-server communication using OpenSSL (GPL), greatly increasing security against malicious intrusion and unauthorized access.
* A more highly-optimized MySQL server library with a smaller memory footprint that performs significantly faster when embedded in third-party software.
* Extensive Unicode support through the utf8 and ucs2 international character sets for applications that require the use of local languages;
* Industry-standard GIS spatial types for storing and managing geographic data;
* Improved full text search and Help features.

[...]

Commercial pricing for the MySQL database server starts at $595 per server.

http://www.mysql.com/news-and-events/press-release/release_2004_32.html

Hey Sxooter - anything that PostgreSQL doesn't already have?

csn

What are derived tables?

csn

Ah . PostgreSQL can do all that, no?

Sxooter

There's no embedded lib for PostgreSQL, but I consider that a feature for postgresql.

A derived table, in most instances I've seen them defined, has just been a subselect.

Most of the new features for MySQL have been in PostgreSQL for years now, with the accompanying user testing that would go with it.

Glad to see MySQL adding features, but the things that bother me are still there (being able to initiate a transaction on mixed table types and not being able to roll it all back, those kinds of things, accepting illegal dates like 2003-02-31, mathmatical overflows that don't result in an error, and so on...) are not likely to go away.

csn

It appears a derived table is nothing more than a subselect in place of a table in a query - like in the FROM clause.

What is an "embedded lib"? The only lib I can think of is like the mysql one that PHP had possible legal problems with.

csn

Ah, right in my own post ;P

A more highly-optimized MySQL server library with a smaller memory footprint that performs significantly faster when embedded in third-party software.