mysql-udf-0.3_3.txz


Advertisement

Description

mysql-udf - Set of user-defined functions for the MySQL server

Property Value
Distribution FreeBSD 11
Repository FreeBSD Ports Latest amd64
Package filename mysql-udf-0.3_3.txz
Package name mysql-udf
Package version 0.3
Package release 3
Package architecture amd64
Package type txz
Category databases
Homepage http://mysql-udf.sourceforge.net/
License -
Maintainer ports@FreeBSD.org
Download size 14.12 KB
Installed size 90.04 KB
This package adds several user-defined statistics functions
to the MySQL server providing the ability to:
* calculate the median of any values,
* calculate the skewness and kurtosis of a distribution of value
* retrieve the effective length of the longest value in a STRING column,
* get the longest value from a STRING column,
* calculate the faculty of a value,
* calculate linear regression parameters (intercept, slope, correlation
coefficent) of any values
WWW: http://mysql-udf.sourceforge.net/
To add the custom functions to your MySQL server use the following syntax:
(you may install only the functions you need):
CREATE AGGREGATE FUNCTION median RETURNS REAL SONAME 'udf_median.so';
CREATE AGGREGATE FUNCTION correlation RETURNS REAL SONAME 'udf_correlation.so';
CREATE AGGREGATE FUNCTION intercept RETURNS REAL SONAME 'udf_intercept.so';
CREATE AGGREGATE FUNCTION slope RETURNS REAL SONAME 'udf_slope.so';
CREATE AGGREGATE FUNCTION skewness RETURNS REAL SONAME 'udf_skewness.so';
CREATE AGGREGATE FUNCTION kurtosis RETURNS REAL SONAME 'udf_kurtosis.so';
CREATE FUNCTION confidence_higher RETURNS REAL SONAME 'udf_confidence_higher.so';
CREATE FUNCTION confidence_lower RETURNS REAL SONAME 'udf_confidence_lower.so';
CREATE FUNCTION stdnorm_density RETURNS REAL SONAME 'udf_stdnorm_density.so';
CREATE FUNCTION stdnorm_dist RETURNS REAL SONAME 'udf_stdnorm_dist.so';
CREATE AGGREGATE FUNCTION geomean RETURNS REAL SONAME 'udf_geomean.so';
CREATE AGGREGATE FUNCTION weightedavg RETURNS REAL SONAME 'udf_weightedavg.so';
CREATE FUNCTION noverm RETURNS INTEGER SONAME 'udf_noverm.so';
CREATE FUNCTION faculty RETURNS REAL SONAME 'udf_faculty.so';
CREATE AGGREGATE FUNCTION COLWIDTH RETURNS INTEGER SONAME 'udf_colwidth.so';
CREATE AGGREGATE FUNCTION LONGEST RETURNS STRING SONAME 'udf_longest.so';
Example for deinstalling a function:
DROP FUNCTION median;
For function descriptions, see the following webpage:
http://mysql-udf.sourceforge.net/
===>   NOTICE:
The mysql-udf port currently does not have a maintainer. As a result, it is
more likely to have unresolved issues, not be up-to-date, or even be removed in
the future. To volunteer to maintain this port, please create an issue at:
https://bugs.freebsd.org/bugzilla
More information about port maintainership is available at:
https://www.freebsd.org/doc/en/articles/contributing/ports-contributing.html#maintain-port

Alternatives

Package Version Architecture Repository
mysql-udf-0.3_3.txz 0.3 i386 FreeBSD Ports Quarterly
mysql-udf-0.3_3.txz 0.3 amd64 FreeBSD Ports Quarterly
mysql-udf-0.3_3.txz 0.3 i386 FreeBSD Ports Latest
mysql-udf - - -

Requires

Name Value
mysql56-client = 5.6.43

Download

Type URL
Mirror pkg.freebsd.org
Binary Package mysql-udf-0.3_3.txz
Source Package databases/mysql-udf

Install Howto

Install mysql-udf txz package:

# pkg install mysql-udf

See Also

Package Description
mysql2odbc-0.99.2_5.txz Openlink MySQL-ODBC Gateway
mysql2pgsql-1.2,1.txz Convert a MySQL dump to a PostgreSQL dump
mysql55-client-5.5.62_3.txz Multithreaded SQL database (client)
mysql55-server-5.5.62_3.txz Multithreaded SQL database (server)
mysql56-client-5.6.45.txz Multithreaded SQL database (client)
mysql56-server-5.6.45.txz Multithreaded SQL database (server)
mysql57-client-5.7.27.txz Multithreaded SQL database (client)
mysql57-server-5.7.27.txz Multithreaded SQL database (server)
mysql80-client-8.0.17_1.txz Multithreaded SQL database (client)
mysql80-server-8.0.17_1.txz Multithreaded SQL database (server)
mysqlbackup-2.8.txz Creates MySQL backups on a periodic basis
mysqld_exporter-0.11.0.txz Prometheus exporter for MySQL server metrics
mysqldump-secure-0.16.3.txz Simple tool for dumping/backing up MySQL and MariaDB databases
mysqlidxchk-1.0_1.txz Checks MySQL databases/tables for unused indexes
mysqlphp2postgres-0.95.txz Convert MySQL calls in a PHP page into PostgreSQL calls
Advertisement
Advertisement