MySQL Plugins and UDF's
Sat, 2010-11-20 12:58 —
oli
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
tags:
