mysql_sphere 0.1
Based on pgSphere 1.1.1
Ported by: Adrian M. Partl
Original: The pgSphere team
Now available for dolphins!
mysql_sphere provides spherical data types, functions, and operators for MySQL and MariaDB. It is based on pgSphere 1.1.1 pre2 (see http://pgsphere.projects.pgfoundry.org/) and constitutes a port of pgSphere from PostgreSQL to MySQL/MariaDB. Indexing is not yet supported, due to the unextensibility of indexing in MySQL.
The project is hosted at github.com.
This document describes installation and usage of this module.
Table of Contents
- 1. What is mysql_sphere?
- 2. Installation
- 2.1. Download
- 2.2. Installation
- 3. Data types
- 3.1. Overview
- 3.2. Point
- 3.3. Euler transformation
- 3.4. Circle
- 3.5. Line
- 3.6. Ellipses
- 3.7. Path
- 3.8. Polygon
- 3.9. Coordinates range
- 4. Constructors
- 4.1. Point
- 4.2. Euler transformation
- 4.3. Circle
- 4.4. Line
- 4.5. Ellipse
- 4.6. Polygon
- 4.7. Path
- 4.8. Coordinates range
- 5. Operators
- 5.1. Casting
- 5.2. Equality
- 5.3. Contain and overlap
- 5.4. Crossing of lines
- 5.5. Distance
- 5.6. Length and circumference
- 5.7. Center
- 5.8. Change the direction
- 5.9. Turn the path of a line
- 5.10. Transformation
- 6. Functions
- 6.1. Area function
- 6.2. spoint functions
- 6.3. strans functions
- 6.4. scircle functions
- 6.5. sellipse functions
- 6.6. sline functions
- 6.7. spath functions
- 6.8. spoly functions
- 6.9. sbox functions
- 7. Create an index
- 7.1. Spherical index
- 8. Usage examples
- 8.1. General
- 8.2. Geographical
- 8.3. Astronomical
- 9. FAQ
- 10. Appendixes