The Russian developer Alexey “Holyfoot” Botchkov improved MySQL’s built-in GIS functions in order to use precise operations instead of MBR-based operations. Binary packages of a MySQL release containing his work are available for public testing here (FTP).
According to the GIS Functions wiki entry following MySQL GIS functions have been added to the MySQL 5.1.23 beta GIS release:
- BUFFER
- DIFFERENCE
- DISTANCE
- INTERSECTION
- SYM_DIFFERENCE
- UNION
I haven’t had the chance to test it yet, but I remember being very excited when I first read about the MySQL spatial extension a couple of years ago, followed by disappointment because of the MBR limits. Finally I decided to go with PostgreSQL/PostGIS back then.
However, if this functions make it into the official release it would be a good tool for proper storage and inclusion of geospatial data in (lightweighted) mapping applications like map mashups, compared to file based XML (KML) storage for instance. MySQL is supported by every other shared hosting plan, so the install base would be quite considerable I guess. [via heise]
A new version of MAMP, containing the latest updates of its components, is available for download.
MAMP (Macintosh, Apache, Mysql and PHP) is an excelent environment if you’re planning to do some PHP development on your Mac. As they state on the MAMP website, it should therefore not be used as Live Webserver for the Internet.
Included software & libraries
- Apache Version: 2.0.55
- MySQL Version: 4.1.12
- PHP Version: 4.4.2 & 5.1.2
- eAccelerator: 0.9.4-rc1
- Zend Optimizer: 2.6.0
- phpMyAdmin 2.7.0-pl2
- SQLite Version: 2.8.16
- SQLiteManager Version: 1.1.3
- Freetype Version: 2.1.9
- t1lib Version: 5.1.0
- curl Version: 7.14.0
- jpeg Version: 6b
- libpng Version: 1.2.5
- gd Version: 2.0.28
I use MAMP primarily to test or modify WordPress upgrades, themes or plugins on my local machine before installing them on my webserver. The installation, administration and removal of MAMP is pretty straightforward – a highly recommended package!
Vollständige Migration der Scripts auf MySQL 4.1
Erarbeitung des schriftlichen Teils
Abgabe des Rohentwurfes Ende August 2003
Einbindung der Unfallhäufungsstellen (in der Unfalldatenbank aggregierte Unfallpunkte).
Nach einer erfolgreichen Testphase wurde der MySQL Datenbankserver auf die Version 4.1-alpha umgestellt.
Grund dafür waren die in dieser Version bereits implementierten Geometrie-Erweiterungen (OpenGIS-Spezifikationen) des Datenbankservers (siehe MySQL-Dokumentation).