Sample explanation and code to create data cubes in MySQL using a Gearman UDF and a perl worker. No need to know Perl. This method allows anyone to create crosstabs in SQL, regardless of the programming language used to query the database.

With the User Defined Function (UDF) Interface you can plug your C/C++ functions into the MySQL database server, and call them from your SQL statements just like any other SQL function. You can even use them to create aggregate functions. In this article, you'll learn how to create and run MySQL UDFs on Windows using the Express Edition of the popular Microsoft Visual C++ IDE.