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.
The library provides the same functionality as SQL/XML, seen
in MS SQL server and Oracle. However it uses normal functions.
By using subqueries the same results as SQL/XML can be generated.
WWW: http://www.mysqludf.org/lib_mysqludf_xql/index.php
To add the custom functions to your MySQL server use the following syntax:
(you may install only the functions you need):
USE mysql;
DROP FUNCTION IF EXISTS lib_mysqludf_xql_info;
DROP FUNCTION IF EXISTS xql_textdecl;
DROP FUNCTION IF EXISTS xql_pi;
DROP FUNCTION IF EXISTS xql_dtd;
DROP FUNCTION IF EXISTS xql_element;
DROP FUNCTION IF EXISTS xql_forest;
DROP FUNCTION IF EXISTS xql_concat;
DROP FUNCTION IF EXISTS xql_agg;
DROP FUNCTION IF EXISTS xql_comment;
DROP FUNCTION IF EXISTS xql_cdata;
DROP FUNCTION IF EXISTS xql_encode;
CREATE FUNCTION lib_mysqludf_xql_info RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_textdecl RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_pi RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_dtd RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_element RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_forest RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_concat RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE AGGREGATE FUNCTION xql_agg RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_comment RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_cdata RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_encode RETURNS STRING SONAME 'lib_mysqludf_xql.so';
Example for deinstalling a function:
DROP FUNCTION xql_encode;
For function descriptions, see the following webpage:
http://http://www.mysqludf.org/lib_mysqludf_xql/index.php
Remove expired ports without open PRs:
2016-07-04 security/openpgpsdk: Broken for more than 6 months
2016-07-04 security/radiusniff: Broken for more than 6 months
2016-07-04 security/pear-Auth_OpenID: Broken for more than 6 months
2016-07-04 security/sshit: Broken for more than 6 months
2016-07-04 security/ifd-slb_rf60: Broken for more than 6 months
2016-07-04 security/rainbowcrack: Broken for more than 6 months
2016-07-04 security/vlog: Broken for more than 6 months
2016-07-04 security/cryptstring: Broken for more than 6 months
2016-07-04 x11/libdnd: Broken for more than 6 months
2016-07-04 x11/xlupe: Broken for more than 6 months
2016-07-04 x11/xco: Broken for more than 6 months
2016-07-04 x11/xclick: Broken for more than 6 months
2016-07-04 devel/ocfpcsc: Broken for more than 6 months
2016-07-04 devel/dits: Broken for more than 6 months
(Only the first 15 lines of the commit message are shown above )
The FreeBSD x11@ and graphics team proudly presents
a zeising, kwm production, with help from dumbbell, bdrewery:
NEW XORG ON FREEBSD 9-STABLE AND 10-STABLE
This update switches over to use the new xorg stack by default on FreeBSD 9
and 10 stable, on osversions where vt(9) is available.
It is still possible to use the old stack by specifying WITHOUT_NEW_XORG in
/etc/make.conf .
FreeBSD 8-STABLE and released versions of FreeBSD still use
the old version.
A package repository with binary packages for new xorg will
be available soon.
This patch also contains updates of libxcb and related ports, pixman, as well
(Only the first 15 lines of the commit message are shown above )
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.
The library provides the same functionality as SQL/XML, seen
in MS SQL server and Oracle. However it uses normal functions.
By using subqueries the same results as SQL/XML can be generated.
WWW: http://www.mysqludf.org/lib_mysqludf_xql/index.php
PR: ports/142086
Submitted by: Mina R Waheeb <syncer at gmail.com>
