EmergencyEMERGENCY? Get 24/7 Help Now!

Using UDFs for geo-distance search in MySQL

 | June 19, 2014 |  Posted In: MySQL

In my previous post about geo-spatial search in MySQL I described (along with other things) how to use geo-distance functions. In this post I will describe the geo-spatial distance functions in more details. If you need to calculate an exact distance between 2 points on Earth in MySQL (very common for geo-enabled applications) you have at […]

Read More

Creating GEO-enabled applications with MySQL 5.6

 | March 24, 2014 |  Posted In: MySQL, Percona Live

In my previous post I’ve showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post I will show how we can obtain open-source GIS data, convert it to MySQL and use it in our GEO-enabled applications. I will also present at the upcoming Percona Live conference on this […]

Read More

MySQL Spatial Functions for Geo-Enabled Applications

 | October 21, 2013 |  Posted In: MySQL

Geo-enabled (or location enabled) applications are very common nowadays and many of them use MySQL spatial functions. The common tasks for such applications are: Find all points of interests (i.e. coffee shops) around (i.e. a 10 mile radius) the given location (latitude and longitude). For example we want to show this to a user of […]

Read More