You are here

MySQL Plugins and UDF's

At the DOAG 2010 we found that there are already a lot of Plugins etc. for MySQL available. Therefor it will be a good time to start with a collection of Plugins, UDF's etc. available.

Because we have done already a collection of MySQL Storage Engines earlier please look there form more information.

Name Type works with Version License Useful for
mnoGoSearch Plugin MySQL 5.1 v3.2.43 GPL v2? Pluggable fulltext parsers interface.
HandlerSocket Plugin MySQL Public Domain? HandlerSocket is a NoSQL plugin for MySQL. It works as a daemon inside the mysqld process, accept tcp connections, and execute requests from clients. HandlerSocket does not support SQL queries. Instead, it supports simple CRUD operations on tables.
Mycached UDF MySQL Memcached protocol support for MySQL.
Sphinx Plugin MySQL GPL v2 Sphinx fulltext search as MySQL Storage Engine (SphinxSE). More details you can find at our collection of MySQL Storage Engines.
plugin to produce an integer timestamp UDF MySQL Creating a MySQL plugin to produce an integer timestamp
udf_spin_wait_delay UDF MySQL GPL v2 Getting and setting MySQL internal variables (spin_wait_delay).
Daemon Example Plugin? MySQL Daemon Example.
MySQL error log UDF UDF MySQL GPL v2 UDF to write messages to the MySQL error log.
lib_mysqludf_str UDF MySQL str_numtowords converts numbers written in arabic digits to an english word. Positive and negative numbers up to 9 digits long are supported.
lib_mysqludf_sys UDF MySQL This library lib_mysqludf_sys contains a number of functions that allows one to interact with the operating system.
lib_mysqludf_ta UDF MySQL Implements technical analysis functions as MySQL UDFs.
lib_mysqludf_udf UDF MySQL 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.
lib_mysqludf_xql UDF MySQL 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. This improves performance and simplifies your code.
lib_mysqludf_fPROJ4 UDF MySQL This library is based on program PROJ.4 which is a standard Unix filter function which converts geographic longitude and latitude coordinates into cartesian coordinates, by means of a wide variety of cartographic projection functions. It is in active use by GRASS GIS, MapServer, PostGIS, Thuban, OGDI, Mapnik, TopoCad, and OGRCoordinateTransformation as well as various other projects.
lib_mysqludf_json UDF MySQL JSON is an abbreviation of JavaScript Object Notation. JSON uses a subset of the ecmascript (javascript) language to denote javascript data structures (see also RFC 4627). As such, JSON is a text-oriented data format.
lib_mysqludf_log UDF MySQL Often it can be useful to write to a log file from inside a SQL statement or stored procedure. Currently this library contains only one function that allows you to write to the error log file.
This library lib_mysqludf_log can be used to write debug information to the log files.
lib_mysqludf_myxml UDF MySQL lib_mysqludf_myxml_info, myxml_innerxml, myxml_outerxml
lib_mysqludf_preg UDF MySQL lib_mysqludf_preg is a library of MySQL UDF's that provide access to the PCRE (perl compatible-regular-expressions) library for pattern matching. The PCRE library is a set of functions that implement regular expression pattern matching using the same syntax and semantics as Perl 5.
lib_mysqludf_stat UDF MySQL MySQL supports a few statistical functions natively. However, for moderately more advanced statistical analysis, you need to resort to custom queries or third party tools. This library lib_mysqludf_stat aims to offer a complete set of commonly used statistical functions.
lib_mysqludf_stem UDF MySQL The lib_mysqludf_stem library provides stemming capability for a variety of languages using Dr. M.F. Porter's Snowball API.

See also the following book: MySQL Plugin Development