MySQL port of pgSphere 1.1.1
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is even with aipescience:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
doc
src
test
.gitignore
CMakeLists.txt
LICENSE
NOTICE
README
install_sphere.sql
mysql_sphere.sublime-project
mysql_sphere.sublime-workspace
mysql_sphere_udf_list.csv
uninstall_sphere.sql

README

+-----------------------------------------------------------------------------+
|                 mysql_sphere 0.1 for MySQL 5.5 and MariaDB                  |
+-----------------------------------------------------------------------------+


This is a port of the pgSphere 1.1.1 library to MySQL. Ported are all spherical
functions but not the spherical index part.

Changes:
- made UDF calls coherent
- object wrapping is done using BLOBs that can either be base64 encoded or not
- due to non extensibility of MySQL SQL syntax, no operators are available for
  sphere objects and everything needs to be done using direct UDF function calls

No documentation is available yet, but this will be available in the future.

To install
----------

1) Download the mysql source corresponding to your installed
   version. Building mysql from scratch is recommended.

   Note: ONLY MYSQL VERSION 5.5 AND ABOVE ARE CURRENTLY 
   	 SUPPORTED

2) edit CMakeList.txt accordingly to point to the directory 
   where mysql is installed.

3) edit CMakeList.txt accordingly to point to the directory
   of the mysql sources

4) mkdir build
   cd build

5) cmake ..

6) make

7) make install

8) log into mysql server as root and execute the commands in 
   install_udfs.sql

How to use
----------

See the documentation under ./doc/index.html