EmergencyEMERGENCY? Get 24/7 Help Now!

New GIS Features in MySQL 5.7

 | February 3, 2016 |  Posted In: MySQL

MySQL GROUP_CONCAT

MySQL 5.7 has been released, and there are some exciting new features now available that I’m going to discuss in this blog — specifically around geographic information system (GIS). I’ve used GIS features in MySQL for a long time. In my previous blog entries I’ve shown how to create geo-enabled applications with MySQL 5.6 and use MySQL 5.6 […]

Read More

MySQL and geospatial programming: An introduction to GIS

 | March 13, 2015 |  Posted In: Insight for Developers, MySQL

Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical interest (the list is endless). In a nutshell, GIS captures, store, checks and displays data […]

Read More

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