license

All libraries hosted at mysqludf.com are free software; you can redistribute them and/or modify them under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

about

MySQL UDFs offer a powerful way to extend the functionality of your MySQL database.

The UDFs on this site are all free: free to use, free to distribute, free to modify and free of charge. Even for commercial projects.

Libraries

For downloads, place navigate to either one of the library documentation pages. You will find the source, binary and resources in the top of each documentation page.

Please understand that in most cases, the libraries themselves are not considered complete. We intend to add more functions to these libraries. However, we are currently not thinking of changing any of the function names or signatures, so it should be safe to build with whatever is there now.

Currently, the following libraries are available:

lib_mysqludf_fPROF4
An extended set of scientific functions which converts geographic longitude and latitude coordinates into cartesian coordinates and vice versa.
Contributed by Ferhat Bingol
lib_mysqludf_json
A library of functions to map relational data to the JSON format. JSON is a principal format next to XML for data exchange in AJAX architectures.
Contributed by Roland Bouman
lib_mysqludf_log
This library lib_mysqludf_log can be used to write debug information to the log files.
Contributed by Roland Bouman
lib_mysqludf_myxml
Comming soon!
Contributed by Barry Solomon
lib_mysqludf_preg
A library to access the functionality in the PCRE library, offering Perl 5 compatible regular expressions. This can be as an enhancement to (or replacement of) the RLIKE or REGEXP syntax native to MySQL, or to replace regular expressions in the client or application layer (such as the PHP preg_ functions).
Contributed by Rich Waters of GoodHumans
lib_mysqludf_stat
A library of statistical functions. Most of these functions are aggregrate functions.
Contributed by Roland Bouman
lib_mysqludf_stem
The lib_mysqludf_stem library provides stemming capability for a variety of languages using Dr. M.F. Porter's Snowball API.
Contributed by Arnold Daniels of Javeline
lib_mysqludf_str
A library of string functions complementing the set of native ones provided by MySQL.
Contributed by Claudio Cherubino
lib_mysqludf_sys
A library with functions to interact with the operating system. These functions allow you to interact with the execution environment in which MySQL runs.
Contributed by Roland Bouman
Contributed by Bernardo Damele
lib_mysqludf_ta
Provides functions commonly used in technical analysis of financial markets.
Contributed by Joao Costa
lib_mysqludf_udf
This library lib_mysqludf_udf contains a number of functions that allows one to look directly at the internal structures passed to the UDF. It is primarily intended for UDF authors to debug UDFs and to verify what MySQL passes to the UDF.
Contributed by Roland Bouman
lib_mysqludf_xql
The lib_mysqludf_xql library provides an array of functions, which can be used to create XML output directly from MySQL using a single SQL query. This prevents having to convert a MySQL result to XML in a PHP script, Ruby script, etc.
Contributed by Arnold Daniels of Javeline

Special thanks

Roland Bouman
For founding and managing the UDF repository for MySQL
Arnold Daniels
For maintaining the mysqludf.org website
Gabor Krizsanits
For building Windows DLLs