The MySQL crystal ball says …

Ronald Bradford
May 18, 2009

As the recipient of the 2009 MySQL Community Member of the Year award I received a MySQL crystal ball. While it looks good in my bookcase, unfortunately the best advice I can offer during this time of uncertainty is “watch this space”.

A number of topics where information is still very much unknown and I’m either asked about, or am following includes:

The Oracle acquisition of Sun, owner of MySQL.
MySQL 5.4 Alpha release and schedule for production release
The end of MySQL 5.0 Community/Enterprise split
The future of Falcon in MySQL 6.0?

Thanks to Julian Cash of the Human Creativity Project of his photograph at the 2009 MySQL Conference.

View Photo . View all 2009 MySQL Conference photos.

Tagged with: Databases General MySQL Open Source

Producing Alternative Means statistics with SQL

Ronald Bradford
June 23, 2026

MySQL’s built-in AVG() computes the arithmetic mean — the sum divided by the count. That is the right default for many questions, but it is not always the right measure of central tendency.

MySQL

Extending MySQL Capabilities with UDFs, Plugins and Components

Ronald Bradford
June 22, 2026

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual For the purposes of this post I will be using the current LTS version MySQL 8.

Producing One-Sample Z-Test statistics with SQL

Ronald Bradford
June 20, 2026

The one-sample Z-test determines whether a sample mean differs significantly from a known population mean when the population standard deviation is also known. It is the appropriate test when the population parameters are established — quality control benchmarks, national averages, long-run process measurements — and you want to evaluate whether a new sample is consistent with them.